MS EXCEL MCQ Questions and Answers Quiz

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
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Question and Answer