Part 9: Excel Shortcuts & Productivity Tips Quiz (20 MCQ)

Correct answer: A. Saves the current workbook

★ Key Takeaway: Save early and save often—Ctrl+S prevents painful data loss.

Explanation: Ctrl+S saves your latest changes to the same file. If the workbook is new and has no filename yet, Excel will ask you to choose a name and location.

Why other options are incorrect:

• B. Selects the entire worksheet – Selecting everything is usually Ctrl+A, not Ctrl+S.
• C. Sorts the selected data – Sorting is done from the Data tab or Sort commands, not Ctrl+S.
• D. Opens Save As every time – Save As is typically F12 (or menu options), while Ctrl+S is normal Save.

Tip: Want to become fast with the most useful Excel shortcuts (the ones real jobs use)? A 1-on-1 tutor can guide you with real examples. Explore 1-on-1 Excel tutoring on Fiverr →

Correct answer: B. Copies the selected cells

★ Key Takeaway: Copy keeps the original data and lets you reuse it elsewhere.

Explanation: After Ctrl+C, Excel shows a moving border around the copied range. You can paste it into another location using Ctrl+V.

Why other options are incorrect:

• A. Cuts the selected cells – Cutting is Ctrl+X, not Ctrl+C.
• C. Clears the selected cells – Clearing is usually Delete or Clear commands, not Ctrl+C.
• D. Creates a new chart – Charts are created from the Insert tab, not Ctrl+C.

Correct answer: D. Ctrl+1

★ Key Takeaway: Ctrl+1 is the fastest path to number formats, borders, alignment, and font settings.

Explanation: Format Cells is where you control things like Currency, Date formats, decimals, text alignment, and borders—without hunting through multiple Ribbon buttons.

Why other options are incorrect:

• A. Ctrl+T – This creates an Excel Table, not the Format Cells dialog.
• B. Ctrl+K – This inserts a hyperlink.
• C. Ctrl+Shift+L – This toggles filters on/off.

Correct answer: B. Undoes the last action

★ Key Takeaway: Ctrl+Z saves you when you paste, delete, or format something by mistake.

Explanation: Ctrl+Z reverses your most recent change. You can press it multiple times to step backward through recent actions.

Why other options are incorrect:

• A. Zooms in on the sheet – Zoom is controlled from the View tab or zoom slider.
• C. Creates a new workbook – New workbook is Ctrl+N.
• D. Protects the worksheet – Protection is on the Review tab.

Correct answer: A. Ctrl+G (Go To)

★ Key Takeaway: Go To is a fast navigation tool for big spreadsheets.

Explanation: Ctrl+G opens the Go To box where you can type a cell reference (like H2500) and jump there instantly—great for huge reports.

Why other options are incorrect:

• B. Ctrl+F (Find) – Find searches for text/values, but it’s not the fastest way to jump to a known cell address.
• C. Ctrl+H (Replace) – Replace is for swapping text/values, not jumping to a cell.
• D. Ctrl+P (Print) – Print opens printing options.

Correct answer: A. Ctrl+Shift+L

★ Key Takeaway: Filters help you focus on only the rows that matter—without deleting data.

Explanation: Ctrl+Shift+L quickly adds (or removes) filter dropdowns. It’s perfect for tasks like showing only “Overdue” invoices or only one region’s sales.

Why other options are incorrect:

• B. Ctrl+Shift+$ – This applies a Currency number format.
• C. Ctrl+Shift+# – This applies a Date format.
• D. Ctrl+Shift+@ – This applies a Time format.

Correct answer: B. Automatically inserts a SUM formula

★ Key Takeaway: Alt+= is the fastest way to total numbers in a column or row.

Explanation: Excel tries to guess the range above (or left) and inserts SUM. It’s a quick move for totals in invoices, budgets, and sales reports.

Why other options are incorrect:

• A. Opens the Save As window – Save As is typically F12, not Alt+=.
• C. Turns on AutoFilter – Filters are commonly Ctrl+Shift+L.
• D. Creates a PivotTable – PivotTables are inserted from the Insert tab.

Correct answer: D. Freeze Top Row (Freeze Panes)

★ Key Takeaway: Freeze Panes keeps important headings visible and reduces mistakes.

Explanation: Freezing the top row is ideal for tables like “Name / Date / Amount” because you can scroll down while still seeing what each column means.

Why other options are incorrect:

• A. Protect Sheet – This prevents edits but does not keep headers visible while scrolling.
• B. Wrap Text – Wrap Text changes text display inside a cell, not scrolling behavior.
• C. Page Layout View – This changes how the sheet looks for printing, not header visibility during scrolling.

Correct answer: B. Ctrl+Shift+$

★ Key Takeaway: Number-format shortcuts save time and keep reports consistent.

Explanation: Ctrl+Shift+$ applies a currency format, making values look like money (useful for budgets, costs, and revenue). It’s faster than opening menus every time.

Why other options are incorrect:

• A. Ctrl+Shift+% – This applies Percent format, not currency.
• C. Ctrl+Shift+# – This applies a Date format.
• D. Ctrl+Shift+@ – This applies a Time format.

Tip: If you want to work faster in Excel, practice the top 20 shortcuts on real tasks (budgets, reports, lists). A tutor can guide you step by step. Learn Excel faster with a 1-on-1 tutor on Fiverr →

Correct answer: C. Paste Special → Values

★ Key Takeaway: Paste Values is a core “pro move” for turning formulas into final results.

Explanation: Paste Special → Values keeps only the displayed numbers/text, removing the formulas behind them. This is common when sharing a final report or preventing formula changes.

Why other options are incorrect:

• A. Press Esc and paste again – Esc cancels actions; it does not convert formulas to values.
• B. Use Ctrl+V twice – Pasting again does not remove formulas.
• D. Turn on Freeze Panes – Freeze Panes is for viewing headers, not pasting values.

Correct answer: D. Shift+F11

★ Key Takeaway: Shift+F11 adds a new worksheet instantly, keeping you in flow.

Explanation: This is useful when you need separate tabs for each month, region, or department—without using the mouse to click the plus icon.

Why other options are incorrect:

• A. Ctrl+Shift+N – Common Windows shortcut for a new folder, not a new Excel sheet.
• B. Ctrl+P – Opens Print.
• C. Alt+Enter – Inserts a line break inside a cell, not a new sheet.

Correct answer: A. Ctrl+Space

★ Key Takeaway: Ctrl+Space selects a full column; it’s great for formatting or cleaning a field.

Explanation: If you’re cleaning a “Phone Number” column or applying a format to an entire field, selecting the whole column is faster than dragging with the mouse.

Why other options are incorrect:

• B. Shift+Space – Selects the entire row, not the column.
• C. Alt+Space – Opens the Windows window/system menu, not a column selection.
• D. Ctrl+Shift+Space – Not the standard shortcut for “entire column.”

Correct answer: C. F4

★ Key Takeaway: F4 is a time-saver when doing the same formatting or action repeatedly.

Explanation: If you bold one header, adjust a border, or apply a fill color, F4 can repeat that action on the next cell(s). It reduces repetitive clicking.

Why other options are incorrect:

• A. F2 – Edits the active cell.
• B. F9 – Recalculates formulas.
• D. F12 – Opens Save As in many Excel versions.

Correct answer: B. F2

★ Key Takeaway: F2 edits the cell content directly—perfect for quick corrections.

Explanation: F2 puts you into edit mode so you can change a value or fix part of a formula without retyping everything from scratch.

Why other options are incorrect:

• A. F4 – Repeats last action, or toggles $ references inside formulas.
• C. F7 – Spelling check.
• D. F11 – Creates a chart on a new chart sheet in many versions, not cell edit.

Correct answer: A. Shift+Space

★ Key Takeaway: Shift+Space = row, Ctrl+Space = column. Remember this pair.

Explanation: Selecting a full row is useful when you need to format a whole record, delete a row, or insert space for new data.

Why other options are incorrect:

• B. Ctrl+Space – Selects the entire column, not the row.
• C. Alt+Space – Opens the Windows window/system menu.
• D. Ctrl+Shift+Space – Not the standard row selection shortcut.

Correct answer: D. Ctrl+T

★ Key Takeaway: Tables make data management easier—filters, consistent formatting, and auto-expanding ranges.

Explanation: Ctrl+T creates an Excel Table so your data behaves like a structured dataset. It’s great for reports that grow over time.

Why other options are incorrect:

• A. Ctrl+1 – Opens Format Cells, not Table creation.
• B. Ctrl+L – Not the standard Table shortcut in modern Excel (Ctrl+T is the common one).
• C. Ctrl+Shift+L – Toggles filters, but does not convert a range into a Table.

Correct answer: B. Ctrl+F

★ Key Takeaway: Ctrl+F helps you find values fast—especially in big lists.

Explanation: Ctrl+F is useful when you need to find a customer name, invoice ID, or a specific number inside a large worksheet.

Why other options are incorrect:

• A. Ctrl+G – Opens Go To (jump to a cell), not Find.
• C. Ctrl+Y – Redo.
• D. Ctrl+W – Closes the workbook window.

Correct answer: C. Double-click the fill handle

★ Key Takeaway: Double-clicking the fill handle is a huge speed trick for long lists.

Explanation: When there’s data in the adjacent column, double-clicking the fill handle auto-fills down to the last row of that data. This is perfect for calculated columns in reports.

Why other options are incorrect:

• A. Ctrl+Shift+L – Toggles filters, not filling formulas.
• B. Ctrl+D – Fill Down works, but it requires selecting the target range first (it’s not the “match the column length automatically” trick).
• D. Ctrl+H – Opens Replace, not fill.

Correct answer: C. Ctrl+Alt+V

★ Key Takeaway: Paste Special is how you paste values, formats, formulas, or transpose—on purpose.

Explanation: Ctrl+Alt+V opens Paste Special so you can choose exactly what to paste (like Values only). This is a common “Excel professional” habit.

Why other options are incorrect:

• A. Ctrl+Shift+V – Not a dependable Paste Special shortcut across Excel versions.
• B. Alt+Enter – Inserts a new line inside a cell.
• D. Ctrl+Shift+L – Toggles filters, not Paste Special.

Correct answer: D. They reduce repeated mouse work and speed up common actions

★ Key Takeaway: Shortcuts are not “magic”—they simply make you faster and more consistent.

Explanation: When you use shortcuts for saving, navigating, formatting, filtering, and pasting, you reduce interruptions and finish tasks sooner—especially with repetitive reporting work.

Why other options are incorrect:

• A. They automatically fix wrong formulas – Shortcuts speed up actions but do not correct logic mistakes.
• B. They increase file size for better speed – Shortcuts do not change file size, and larger files are not automatically faster.
• C. They prevent all data entry errors without checks – You still need validation, review, and good spreadsheet habits.