MS EXCEL Multiple Choice Questions and Answers

11. Give me an example of a cell address.

1. 911
2. 41A
3. A21
4. 4

12. Selecting the Column G & H then choose Insert->Columns. What will happen?

1. 2 Columns will be inserted after Column G
2. 2 Columns will be inserted after Column H
3. 2 Columns will be inserted after Column I
4. 1

13. Where a row and a column meet, what do you call that?

1. A block
2. A box
3. None of the above
4. 1

14. In Excel, a Data Series is defined as what ?

1. A type of chart
2. A cell reference
3. None of the above
4. 1

15. In Excel, Columns are labelled as ………………………….

1. 1,2,3 etc
2. A1, A2, etc
3. $A$1, $A$2, etc.
4. 1

16. In Excel, Rows are labelled as …………………….

1. 1,2,3 etc
2. A1, A2, etc
3. $A$1, $A$2, etc.
4. 2

17. The cell reference for cell range of A2 to M12 is …………………………

1. A2.M12
2. A2;M12
3. A2:M12
4. 4

18. The first cell in EXCEL worksheet is labeled as

1. A1
2. Aa
3. A0
4. 2

19. Statistical calculations and preparation of tables and graphs can be done using

1. Excel
2. Notepad
3. Power Point
4. 2

20. What is the shortcut key to insert new sheet in current workbook ?

1. Ctrl + F11
2. Shift + F11
3. None of the above
4. 3