Chapter 9 Spreadsheet Computer Science 11th Class Punjab MCQ Tests
11th Class Computer Science Chapter 9 MCQ Tests
Chapter 9 of 11th Class Computer Science has 20 questions. If you take an online MCQ test, the system will randomly choose the questions. If you want to take the quiz by chapter then click the start test button.
Total Questions: 20
Total Marks: 20
Time: 20 Mins
Total Questions: 20
Total Marks: 20
Time: 20 Mins
20Min : 00 Sec Remaining
Question # 1
if student marks are 34 in cell K6. then what will be the result of following formula =IF(K6<33,"True","False")
Question # 2
If a cell is restricted to add text of 100 characters then what will be the datatype of cell, while implementing data validation?
Question # 3
To make a link between two worksheets it is compulsory that both exist is same workbook.
Question # 4
if value of a in a cell A6 is 7 then what will be the result of (A6 * A6)?
Question # 5
If there are first three multiples of 3 in following cells (K5,L5,M5) then what will be the result o following formula (=K5+L5+M5)?
Question # 6
if Ali is a student who got highest marks in Maths , if marks list is sort from smallest to largest then his name will be on:
Question # 7
If there is workbook of 100 student result card then how many sheets will be required to enter data of seven subjects.
Question # 8
In MS Excel, a workbook can consist of only one worksheet.
Question # 9
(a+b)^2 is an Algebraic formula, in MS Excel it is an example of:
Question # 10
Changing font size in a single cell is an example of:
Question # 11
The central cell address in following cell range(K5:M5) will be:
Question # 12
In sheet 1 there is value 45 stored in D4 and in sheet 2 there is a value 45 stored in D5, then which expression will multiply both cells values (D4 and D5) of two different sheets?
Question # 13
In menu bar, page layout is associated with:
Question # 14
A worksheet name can be renamed according to data sheet function.
Question # 15
If formula is applied on one cell then it can also be replicated on below rows. It is an example of:
Question # 16
The primary purpose of data validation is:
Question # 17
Which menu bar option is clicked to access "Sort and Filter" operation?
Question # 18
Any name given to any cell range , its scope is only limited to one sheet of workbook.
Question # 19
Any mathematical formula . Which is not built in can easily be implementable on MS excel.
Question # 20
To give meaningful name to any cell which option is selected at Formulas section?
Total Questions
1234567891011121314151617181920
Question # 1
if student marks are 34 in cell K6. then what will be the result of following formula =IF(K6<33,"True","False")
Question # 2
If a cell is restricted to add text of 100 characters then what will be the datatype of cell, while implementing data validation?
Question # 3
To make a link between two worksheets it is compulsory that both exist is same workbook.
Question # 4
if value of a in a cell A6 is 7 then what will be the result of (A6 * A6)?
Question # 5
If there are first three multiples of 3 in following cells (K5,L5,M5) then what will be the result o following formula (=K5+L5+M5)?
Question # 6
if Ali is a student who got highest marks in Maths , if marks list is sort from smallest to largest then his name will be on:
Question # 7
If there is workbook of 100 student result card then how many sheets will be required to enter data of seven subjects.
Question # 8
In MS Excel, a workbook can consist of only one worksheet.
Question # 9
(a+b)^2 is an Algebraic formula, in MS Excel it is an example of:
Question # 10
Changing font size in a single cell is an example of:
Question # 11
The central cell address in following cell range(K5:M5) will be:
Question # 12
In sheet 1 there is value 45 stored in D4 and in sheet 2 there is a value 45 stored in D5, then which expression will multiply both cells values (D4 and D5) of two different sheets?
Question # 13
In menu bar, page layout is associated with:
Question # 14
A worksheet name can be renamed according to data sheet function.
Question # 15
If formula is applied on one cell then it can also be replicated on below rows. It is an example of:
Question # 16
The primary purpose of data validation is:
Question # 17
Which menu bar option is clicked to access "Sort and Filter" operation?
Question # 18
Any name given to any cell range , its scope is only limited to one sheet of workbook.
Question # 19
Any mathematical formula . Which is not built in can easily be implementable on MS excel.
Question # 20
To give meaningful name to any cell which option is selected at Formulas section?
Total Questions
1234567891011121314151617181920
Computer Science MCQ Test by Topics
- +9.1 Overview
- +9.2 Features of Spreadsheet Software
- +9.3 The Spreadsheet's Interface
- +9.4 Entering Data in a Worksheet
- +9.5 Basics of Worksheet
- +9.6 Working with Formulas
- +9.7 Functions
- +9.8 Formatting and Customizing Data
- +9.9 Introducing Charts
- +9.10 Printing Worksheets and Charts
Computer Science
11th Class Online Classes 2026
Updated on: 21-05-2026
11th Class Online Preparation
11th Class 2026 Online
11th Class 2026
Add a Comment
Comments will be shown after admin approval.
Spam comments will not be approved at all.
Matric Result 2026 Punjab
10th Class Result 2026 Punjab
9th Class Result 2026 Punjab Boards
10th Class Result Gazette 2026 Punjab
Punjab Past Papers Matric 9th 10th
Primary Results 5th & 8th Class
BISE Results Intermediate & Matric
BISE Punjab Boards
Sindh Educational Boards
KPK Examination Boards
Technical Boards
Public Service Commission
University Results Gruaduation, Masters Classes
Subscribe by Email
Subscribe by Email
Subscribe to Rss Feed
Position Holders Matric 2026
Position Holders 9th Class 2026
Position Holders Inter 2026
Position Holders 11th Class 2026
Punjab 11th Class Computer Science