Excel Shortcuts Quiz

What does the shortcut key Ctrl + C do in Excel?

• Pastes contents from the clipboard.

• Copies the content of a selected cell.

• Cuts and copies the contents of a cell.

• Selects all the cells in a workbook.

Tags

Level 1: Cell Management

Which shortcut key is used to open the 'Find and Replace' dialog box in Excel?

• Ctrl + F

• Ctrl + G

• Ctrl + H

• Ctrl + L

Tags

Level 2: File Management

What function does the shortcut key Ctrl + L perform in Excel?

• Inserts a hyperlink in a selected text.

• Opens the Go To dialog box.

• Opens the Create Table dialog box.

• Closes the current workbook.

If you want to close the current workbook in Excel, which shortcut key would you use?

• Ctrl + P

• Ctrl + W

• Ctrl + K

• Ctrl + A

What is the function of the shortcut key Ctrl + Z in Excel?

• Opens the Format Cells dialog box.

• Reverses the last action.

• Deletes the selected columns or rows.

• Selects an entire column.

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

• Ctrl + Space

• Shift + Space

• Ctrl + Home

• Alt

What does pressing Alt + Enter do in an Excel cell?

• Executes an entry in a cell and moves to the next cell.

• Cancels out an entry.

• Starts a new line in the current cell.

• Opens the Microsoft Excel help.

What is the function of the F1 key in Excel?

• Closes Microsoft Excel.

• Opens the Macro window.

• Opens the Microsoft Excel help.

• Displays the access keys.

Which shortcut key combination is used to create a new Excel Workbook?

• Ctrl + O

• Ctrl + S

• Ctrl + N

• Ctrl + A

What does the shortcut key Ctrl + B do in Excel?

• Copies the contents of a selected cell.

• Saves a workbook.

• Makes the contents bold of a selected cell.

• Selects all the cells in the opened workbook.