MS Excel Shortcuts MCQs with Answers

What is the keyboard shortcut for accessing the Paste Special function in Microsoft Excel?

• A.ALT + H + V + S
• B.CTRL + ALT + V
• C.CTRL + SHIFT + V
• D.ALT + E + S

Which key combination is used in MS Excel to copy the content from the cell directly above?

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

What is the keyboard shortcut to quickly insert a SUM formula in MS Excel?

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

Past Paper MCQ

What is the shortcut key to insert a new worksheet in MS Excel?

• A.Ctrl + F11
• B.Ctrl + N
• C.Alt + Shift + F1
• D.Shift + F11

What is the shortcut key to display active cells in MS Excel?

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

Which keyboard shortcut is used to apply strikethrough formatting to selected text in MS Excel?

• A.Ctrl+Shift+5
• B.Ctrl+Shift+S
• C.Ctrl+5
• D.Ctrl+~

What is the keyboard shortcut to switch to the next worksheet tab in MS Excel?

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

In MS Excel, what does the shortcut key Ctrl + 4 do?

• A.Applies or removes underline formatting
• B.Applies or removes bold formatting
• C.Applies or removes italic formatting
• D.Applies or removes strikethrough formatting

Which shortcut inserts the current time in Excel?

• A.Ctrl+Shift+:
• B.Ctrl+;
• C.Ctrl+Shift+;
• D.Ctrl+T

Which key combination is used to drag a selected range of data to another worksheet within the same workbook in MS Excel?

• A.Alt key
• B.Shift key
• C.Ctrl key
• D.Ctrl + Shift keys