MS Excel Shortcuts MCQs with Answers

Past Paper MCQ

Which of the following is NOT a correct method to edit the contents of a cell?

• A.Press F2 key
• B.Press Alt key
• C.Click in the formula bar
• D.Double-click the cell

Past Paper MCQ

What is the shortcut key for accessing Help in MS Excel?

• A.F7
• B.F2
• C.F5
• D.F1

Which function key is used to switch between absolute and relative references while typing a formula in Excel?

• A.F2
• B.F4
• C.F5
• D.F8

In a spreadsheet application like MS Excel, what is the primary function of the F4 key?

• A.Toggle absolute/relative cell references
• B.Close the current workbook
• C.Open the Find dialog box
• D.Repeat the last action

If the automatic calculation mode is disabled in MS Excel, which key can be used to update the values of formula cells?

• A.F5
• B.F9
• C.F7
• D.F11

Which keyboard shortcut is used to open the print dialog box in MS Excel?

• A.Ctrl+P
• B.Ctrl+Shift+P
• C.Alt+P
• D.Ctrl+F2

In MS Excel, which key combination is used to quickly copy formulas from the cell above?

• A.Ctrl + D
• B.Ctrl + '
• C.Ctrl + R
• D.Ctrl + C

Which key is used to insert text in a cell?

• A.Tab
• B.Enter
• C.Spacebar
• D.Shift

What is the shortcut key for recalculating the current worksheet in MS Excel?

• A.F9
• B.Ctrl + F9
• C.Shift + F9
• D.Alt + F9

Which keyboard shortcut is used to navigate between worksheets in an MS Excel workbook?

• A.Ctrl+Tab
• B.Ctrl+Page Up/Page Down
• C.Alt+Page Up/Page Down
• D.Shift+Tab