MS Excel MCQs with Answers

Which of the following represents an absolute cell reference in MS Excel?

• A.@A@1
• B.A1
• C.#A#1
• D.$A$1

In MS Excel, what does the cell range C7:C9 refer to?

• A.Cells C7 and C9 only
• B.Cells C7 through C9
• C.Column C, rows 7 and 9
• D.Cells C7, C8, and C9 individually selected

Which feature in Microsoft Excel allows users to keep specific rows or columns visible while scrolling through the worksheet?

• A.Freeze Panes
• B.Split Window
• C.Lock Cells
• D.Arrange All

Past Paper MCQ

The basic unit of a spreadsheet where you enter text and numbers is called a _?

• A.Cell
• B.Row
• C.Column
• D.Sheet

In a database or spreadsheet, what can you do with columns and rows?

• A.They can only be deleted but not added
• B.They can only be added but not deleted
• C.They are fixed and cannot be modified
• D.They can be added and deleted as needed

In a spreadsheet program, how are the column headings usually identified?

• A.Alphabets
• B.Numbers
• C.Symbols
• D.Special characters

When you press the Enter key in a spreadsheet with the active cell as B4, which cell will become active?

• A.B5
• B.C4
• C.A4
• D.B3

In Microsoft Excel, what is a group of worksheets collectively called?

• A.Spreadsheet Group
• B.Worksheet Set
• C.Workbook
• D.Sheet Bundle

What does the Paste Special command in MS Excel allow you to paste instead of the actual formula?

• A.Cell formatting only
• B.The resulting values of a formula
• C.Only cell comments
• D.Only data validation rules

Which Excel function is used to switch the orientation of rows and columns in a data set?

• A.SWITCH
• B.TRANSPOSE
• C.ROTATE
• D.FLIP