We are providing accurate mcq questions for class 11 computer science chapter wise. You can read 1st year computer science mcqs with answers.
Chapter 9
Spreadsheet Processing
Encircle the most appropriate answer among the following options choose which one is correct?
1 Which of the following is a spreadsheet
- MS Word
- MS Excel
- MS Power Point
- Both b and a
2 is a spreadsheet choose which one is correct?
- MS Word
- MS Excel
- MS PowerPoint
- Both a and b
3 The intersection of a row and column form a choose which one is correct?
- Cell
- Address
- Reference
- Field
4 The actual working area in Microsoft Excel is choose which one is correct?
- Workbook
- Worksheet
- SpreadsheeT
- Note sheet
5 A cell at third column and 15 rows has a cell address choose which one is correct?
- A15
- B15
- C15
- 15
6 A collection of related worksheets is called choose which one is correct?
- Spreadsheet
- Cells
- File
- Workbook
7 The currently selected cell where data can be entered or edited is called choose which one is correct?
- Idle cell
- Active cell
- Passive cell
- Present cell
8 In a worksheet, a bold rectangle border indicates (n) choose which one is correct?
- Present cell
- Active cell
- Passive cell
- Idle cell
9 – is not a feature of spreadsheet program choose which one is correct?
- Rows and columns
- Formula
- WordArt
10 The actual working area in Microsoft Excel is
- Workbook
- Worksheet
- Spreadsheet
- Note sheet
11 A cell of worksheet, which is not active is called choose which one is correct?
- Active cell
- Idle cell
- Passive cell
- Present cell
12 – cell addresses is correct choose which one is correct?
- Z2
- AZ3
- 2Z
- Both a and b
13 – represents a label choose which one is correct?
- Mubeen Ahmad
- 736
- =Al + B2
- None
14 The 0.0000000001 is displayed in default column width as choose which one is correct?
- 1E – 10
- E-10
- 1E-9
- 01E-9
15 — menus contains the ‘Cells’ command choose which one is correct?
- File
- View
- Format
- Edit
16 Which of the following is an absolute address?
- A1
- A1$
- $A$1
- None of the above
17 Each number format consists of –
- 2
- 3
- 4
- 5
18 The default number format assigned to a cell is the choose which one is correct?
- Currency
- Number
- Text
- General
19 If the custom format is 00000 then the number 420 will be displayed as choose which one is correct?
- 420
- 0420
- 00420
- 420.00
20 If the custom format is ##,### then the number 23349 will be displayed as choose which one is correct?
- 167,00
- 23,349
- 16.300
- 16.3
21 If the custom format is # ##.000 then the number 16.3 will be displayed as choose which one is correct?
- 016.3
- 16.30
- 16.300
- 16.3
22 For a currency format cell, the number 461.593 will be displayed as choose which one is correct?
- 461,593
- $4615.19
- $46159.3
- $461.59
23 Formula can only be applied on choose which one is correct?
- Values
- Labels
- Unmerged cells
- None
24 To add the value of cell “C9′ of worksheet “Sheet3” with the cell ‘B2′ of current worksheet, the formula is written as choose which one is correct?
- = C9 + B2
- = Sheet3!C9+B2
- = Sheet3!B2+C9
- = Sheet3!B2+sheet3!C9
25 Formula can only be applied on
- Values
- Labels
- Unmerged cells
- None of the above
26 is an absolute address choose which one is correct?
- A1
- A1$
- A$1$
- None
27 The absolute reference of cell address A15 is written as;
- $ A15
- $ A15$
- A $ 15
- $A$ 15
28 menus contains the ‘Name’ command choose which one is correct?
- File
- View
- Insert
- Format
29 – symbols is used before the formula choose which one is correct?
- &
- =
- #
- $
30 Range of cells from C2 to C100 is referenced as choose which one is correct?
- C2-100
- C2 choose which one is correct?C100
- C2 to C100
- C2 choose which one is correct?100
31 represents valid range in Excel choose which one is correct?
- C1 choose which one is correct?C3
- C1, C2, C3
- =C1+C2+C3
- C1 to C3
32 Calling a cell with the reference of its address is called choose which one is correct?
- Absolute referencing
- Reference address
- Relative referencing
- None
33 symbols is used in absolute referencing choose which one is correct?
- &
- =
- #
- $
34 To add values of cells C9 and D10, the formula by using absolute reference can be written as choose which one is correct? ]
- =$C9+D10
- =$C$9+$D$10
- =$C9+$D10
- =$C$9+#10
35 function is used to return current system date choose which one is correct?
- Max
- Min
- Today
- None
36 Which of the following function is used to get the current date?
- Exact()
- Today
- Month()
- Year()
37 — menus contains the ‘Function command used to active to function wizard choose which one is correct?
- File
- Format
- Insert
- View
38 — is not a table of Page Setup dialog box of Excel choose which one is correct?
- Page
- Margins
- Paper
- Header/Footer
39 —menus contains the ‘Print command choose which one is correct?
- File
- Edit
- Format
- Insert
40 In a spreadsheet, rows are labeled by choose which one is correct?
- Letters
- Numbers
- Cell reference
- None
41 In a spreadsheet, columns are labeled by choose which one is correct?
- Letters
- Numbers
- Cell references
- None
42. A workbook is a group of choose which one is correct?
- Many rows
- Many columns
- Worksheets
- None
43 A mathematical expression that is used to perform calculation on worksheet is
called choose which one is correct?
- Cell
- Format
- Formula
- Address Bar