NEW
Font size
WorksheetsExcel Shortcuts Quiz
Total questions: 23
Worksheet time: 12mins
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.
Which shortcut key is used to open the 'Find and Replace' dialog box in Excel?
Ctrl + F
Ctrl + G
Ctrl + H
Ctrl + L
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.
What is the function of the shortcut key Ctrl + C in Excel?
Opens an existing workbook.
Selects all the cells in the opened workbook.
Copies the contents of a selected cell.
Creates a new Excel Workbook.
What is the function of the shortcut key Ctrl + D in Excel?
Opens up the Find dialog box
Fills up a selected cell with the contents of its upper cell
Inserts the current date into a cell
Italicizes your text
Which shortcut key is used to open the Go To dialog box in Excel?
Ctrl + G
Ctrl + F
Ctrl + L
Ctrl + P
What does the shortcut key combination Ctrl + Shift + ` do in Excel?
Inserts extra columns or rows
Displays the formula used in a cell
Inserts the current time into a cell
Closes down a running workbook
Which of the following shortcut keys is used to insert a hyperlink within a text in Excel?
Ctrl + K
Ctrl + H
Ctrl + U
Ctrl + I
What function does the shortcut key Ctrl + W perform in Excel?
Deletes a selected row or column
Opens up the Format Cells dialog box
Closes down a running workbook
Reverses the last action
Which shortcut key combination is used to insert the current date into a cell in Excel?
Ctrl + Shift + :
Ctrl + ;
Ctrl + `
Ctrl + Shift + =
What is the purpose of the shortcut key Ctrl + 1 in Excel?
Opens up the Create Table dialog box
Opens up the Format Cells dialog box
Fills up the selected cells with the contents of the left cell
Adds up an underline to the selected text
What is the function of the shortcut Ctrl + Shift + ~ in Microsoft Excel?
Applies time formatting.
Switches between displaying formulas used in a cell and the cell value.
Highlights an entire column.
Navigates to the last cell in a workbook.
Which shortcut key applies date formatting in Microsoft Excel?
Ctrl + Shift + @
Ctrl + Shift + #
Ctrl + Shift + %
Ctrl + Shift + &
What does the shortcut Ctrl + Spacebar do in Microsoft Excel?
Selects an entire workbook.
Navigates to the top-most cell in a selected column.
Highlights an entire column.
Removes the border from the selected cell.
Which shortcut allows you to navigate to the first cell in a selected row in Microsoft Excel?
Ctrl + Left arrow
Ctrl + Right arrow
Ctrl + Up arrow
Ctrl + Down arrow
How can you select an entire row using a keyboard shortcut in Microsoft Excel?
Ctrl + Shift + Spacebar
Shift + Space
Ctrl + Spacebar
Ctrl + Shift + Tab
