Excel Keyboard Shortcuts Quiz

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!