Excel Keyboard Shortcuts Quiz

Questions and Answers

What does CTRL+PgUp do?

Displays the Format Cells dialog box.

Applies or removes bold formatting.

Copies the selected cells.

Switches between worksheet tabs, from left-to-right. (correct)

What does CTRL+PgDn do?

Switches between worksheet tabs, from right-to-left. (correct)

Switches between worksheet tabs, from left-to-right.

Hides the selected rows.

Copies a formula from above.

What is the function of CTRL+SHIFT+(

Applies the Currency format.

Displays the Delete dialog box.

Applies or removes strikethrough.

Unhides any hidden rows within the selection. (correct)

What does CTRL+SHIFT+) do?

Unhides any hidden columns within the selection. Signup and view all the answers

What is the result of using CTRL+SHIFT+&?

Applies the outline border to the selected cells. Signup and view all the answers

What does CTRL+SHIFT+_ do?

Removes the outline border from the selected cells. Signup and view all the answers

What format does CTRL+SHIFT+$ apply?

Applies the Currency format with two decimal places. Signup and view all the answers

What does CTRL+SHIFT+% do?

Applies the Percentage format with no decimal places. Signup and view all the answers

What number format does CTRL+SHIFT+! apply?

Applies the Number format with two decimal places. Signup and view all the answers

What does CTRL+SHIFT+: do?

Enters the current time. Signup and view all the answers

What function does CTRL+1 serve?

Displays the Format Cells dialog box. Signup and view all the answers

What does CTRL+C do?

Copies the selected cells. Signup and view all the answers

What is the action of CTRL+D?

Uses the Fill Down command to copy contents. Signup and view all the answers

Study Notes

Excel Keyboard Shortcuts

CTRL+PgUp: Navigate between worksheet tabs from left to right.
CTRL+PgDn: Navigate between worksheet tabs from right to left.
CTRL+SHIFT+(: Unhide any hidden rows in the selected area.
CTRL+SHIFT+): Unhide any hidden columns in the selected area.
CTRL+SHIFT+&: Apply an outline border to selected cells.
CTRL+SHIFT+_: Remove the outline border from selected cells.
CTRL+SHIFT+~: Apply the General number format to selected cells.
CTRL+SHIFT+$: Apply Currency format to selected cells (two decimal places; negative values in parentheses).
CTRL+SHIFT+%: Apply Percentage format to selected cells (no decimal places).
CTRL+SHIFT+^: Apply Exponential number format to selected cells (two decimal places).
CTRL+SHIFT+#: Apply Date format to selected cells (day, month, year).
CTRL+SHIFT+@: Apply Time format to selected cells (hour, minute, AM/PM).
CTRL+SHIFT+!: Apply Number format (two decimal places; thousands separator for negatives).
CTRL+SHIFT+*: Select the current region around the active cell (data area enclosed by blank rows/columns).
CTRL+SHIFT+:: Enter the current time in the active cell.
CTRL+SHIFT+": Copy the value from the cell above into the active cell.
CTRL+SHIFT+Plus (+): Open the Insert dialog box for adding blank cells.
CTRL+Minus (-): Open the Delete dialog box for deleting selected cells.
CTRL+;: Enter the current date in the active cell.
CTRL+`: Toggle between showing cell values and formulas in the worksheet.
CTRL+': Copy a formula from the cell above into the active cell.
CTRL+1: Display the Format Cells dialog box.
CTRL+2: Toggle bold formatting on selected cells.
CTRL+3: Toggle italic formatting on selected cells.
CTRL+4: Toggle underlining on selected cells.
CTRL+5: Toggle strikethrough formatting on selected cells.
CTRL+6: Switch between hiding objects, displaying objects, and showing placeholders for objects.
CTRL+8: Toggle display of outline symbols.
CTRL+9: Hide selected rows in the worksheet.
CTRL+0: Hide selected columns in the worksheet.
CTRL+A: Select the entire worksheet or the current data region, depending on context.
CTRL+SHIFT+A: Insert argument names and parentheses in formulas when the cursor is at a function name.
CTRL+B: Toggle bold formatting on selected cells.
CTRL+C: Copy selected cells; pressing again opens the Clipboard.
CTRL+D: Fill down command to copy contents and format from the top cell into selected cells below.
CTRL+E: Function is currently available.
CTRL+F: Open the Find and Replace dialog box (Find tab).
SHIFT+F5: Same function as CTRL+F; opens Find and Replace dialog.
SHIFT+F4: Repeat the last Find action.
CTRL+SHIFT+F: Open Format Cells dialog box (Font tab).
CTRL+G: Open the Go To dialog box; same as pressing F5.

Description

Test your knowledge of essential Excel keyboard shortcuts with this quiz. Learn how to efficiently navigate and format data in your spreadsheets using these time-saving commands. From unhiding rows to applying number formats, see how well you know your Excel skills!