# 11th Computer Science MCQ’s with Answers Chapter no 9 | 1st Year Computer Science Mcqs

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

Encircle the most appropriate answer among the following options  choose which one is correct?

1          Which of the following is a spreadsheet

1. MS Word
2. MS Excel
3. MS Power Point
4. Both b and a

2                 is a spreadsheet choose which one is correct?

1. MS Word
2. MS Excel
3. MS PowerPoint
4. Both a and b

3          The intersection of a row and column form a choose which one is correct?

1. Cell
3. Reference
4. Field

4          The actual working area in Microsoft Excel is choose which one is correct?

1. Workbook
2. Worksheet
4. Note sheet

5          A cell at third column and 15 rows has a cell address choose which one is correct?

1. A15
2. B15
3. C15
4. 15

6          A collection of related worksheets is called choose which one is correct?

2. Cells
3. File
4. Workbook

7          The currently selected cell where data can be entered or edited is called choose which one is correct?

1. Idle cell
2. Active cell
3. Passive cell
4. Present cell

8          In a worksheet, a bold rectangle border indicates (n) choose which one is correct?

1. Present cell
2. Active cell
3. Passive cell
4. Idle cell

9          – is not a feature of spreadsheet program choose which one is correct?

1. Rows and columns
2. Formula
3. Print
4. WordArt

10        The actual working area in Microsoft Excel is

1. Workbook
2. Worksheet
4. Note sheet

11        A cell of worksheet, which is not active is called choose which one is correct?

1. Active cell
2. Idle cell
3. Passive cell
4. Present cell

12        – cell addresses is correct choose which one is correct?

1. Z2
2. AZ3
3. 2Z
4. Both a and b

13        – represents a label choose which one is correct?

2. 736
3. =Al + B2
4. None

14        The 0.0000000001 is displayed in default column width as choose which one is correct?

1. 1E – 10
2. E-10
3. 1E-9
4. 01E-9

15        — menus contains the ‘Cells’ command choose which one is correct?

1. File
2. View
3. Format
4. Edit

16        Which of the following is an absolute address?

1. A1
2. A1\$
3. \$A\$1
4. None of the above

17        Each number format consists of –

1. 2
2. 3
3. 4
4. 5

18        The default number format assigned to a cell is the choose which one is correct?

1. Currency
2. Number
3. Text
4. General

19        If the custom format is 00000 then the number 420 will be displayed as choose which one is correct?

1. 420
2. 0420
3. 00420
4. 420.00

20        If the custom format is ##,### then the number 23349 will be displayed as choose which one is correct?

1. 167,00
2. 23,349
3. 16.300
4. 16.3

21        If the custom format is # ##.000 then the number 16.3 will be displayed as choose which one is correct?

1. 016.3
2. 16.30
3. 16.300
4. 16.3

22        For a currency format cell, the number 461.593 will be displayed as choose which one is correct?

1. 461,593
2. \$4615.19
3. \$46159.3
4. \$461.59

23        Formula can only be applied on choose which one is correct?

1. Values
2. Labels
3. Unmerged cells
4. 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?

1.  = C9 + B2
2. = Sheet3!C9+B2
3. = Sheet3!B2+C9
4. = Sheet3!B2+sheet3!C9

25        Formula can only be applied on

1. Values
2. Labels
3. Unmerged cells
4. None of the above

26                is an absolute address choose which one is correct?

1. A1
2. A1\$
3. A\$1\$
4. None

27        The absolute reference of cell address A15 is written as;

1. \$ A15
2. \$ A15\$
3. A \$ 15
4. \$A\$ 15

28               menus contains the ‘Name’ command choose which one is correct?

1. File
2. View
3. Insert
4. Format

29        – symbols is used before the formula choose which one is correct?

1. &
2. =
3. #
4. \$

30        Range of cells from C2 to C100 is referenced as choose which one is correct?

1. C2-100
2. C2 choose which one is correct?C100
3. C2 to C100
4. C2 choose which one is correct?100

31               represents valid range in Excel choose which one is correct?

1. C1 choose which one is correct?C3
2. C1, C2, C3
3. =C1+C2+C3
4. C1 to C3

32        Calling a cell with the reference of its address is called choose which one is correct?

1. Absolute referencing
3. Relative referencing
4. None

33              symbols is used in absolute referencing choose which one is correct?

1. &
2. =
3. #
4. \$

34        To add values of cells C9 and D10, the formula by using absolute reference can be written as choose which one is correct? ]

1. =\$C9+D10
2. =\$C\$9+\$D\$10
3. =\$C9+\$D10
4. =\$C\$9+#10

35               function is used to return current system date choose which one is correct?

1. Max
2. Min
3. Today
4. None

36        Which of the following function is used to get the current date?

1. Exact()
2. Today
3. Month()
4. Year()

37        — menus contains the ‘Function command used to active to function wizard choose which one is correct?

1. File
2. Format
3. Insert
4. View

38        — is not a table of Page Setup dialog box of Excel choose which one is correct?

1. Page
2. Margins
3. Paper

39        —menus contains the ‘Print command choose which one is correct?

1. File
2. Edit
3. Format
4. Insert

40        In a spreadsheet, rows are labeled by choose which one is correct?

1. Letters
2. Numbers
3. Cell reference
4. None

41        In a spreadsheet, columns are labeled by choose which one is correct?

1. Letters
2. Numbers
3. Cell references
4. None

42.       A workbook is a group of choose which one is correct?

1. Many rows
2. Many columns
3. Worksheets
4. None

43        A mathematical expression that is used to perform calculation on worksheet is

called choose which one is correct?

1. Cell
2. Format
3. Formula