MS Excel Shortcuts MCQs with Answers

Which shortcut key is used to hide rows in MS Excel?

• A.Ctrl+8
• B.Ctrl+9
• C.Ctrl+0
• D.Ctrl+7

Which key should not be used when attempting to edit the content of a cell in MS Excel?

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

In MS Excel, which shortcut key is used to format numbers in comma format?

• A.Ctrl+Shift+1
• B.Ctrl+Shift+2
• C.Ctrl+1
• D.Ctrl+Shift+$

In Microsoft Excel, which keyboard shortcut is used to format numbers as currency?

• A.Ctrl+Shift+4
• B.Ctrl+Shift+3
• C.Ctrl+Shift+5
• D.Ctrl+Shift+2

Past Paper MCQ

Which shortcut key combination is used in Excel to select an entire column?

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

Which function key allows you to quickly navigate to a specific cell in MS Excel?

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

What does the Shift+F11 shortcut do in Excel?

• A.Insert worksheet
• B.Delete worksheet
• C.Rename worksheet
• D.Hide worksheet

What does the shortcut Ctrl+R do in MS Excel?

• A.Opens the Find and Replace dialog box
• B.Fills the selection with active cells to the bottom
• C.Fills the selection with active cells to the right
• D.Aligns the selected text to the right

Which key do you press in combination with drag and drop to copy the contents of a cell in MS Excel?

• A.Ctrl
• B.Shift
• C.Alt
• D.Tab

Past Paper MCQ

Shortcut to repeat last action in Excel:

• A.Ctrl + R
• B.F5
• C.Ctrl + Y
• D.F4