Basic and Advance Questions and Answers Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Basic and Advance Questions and Answers flashcards as text
Which Excel feature allows you to apply consistent formatting across multiple cells based on their values?
Answer: Conditional Formatting
Conditional Formatting automatically applies formatting rules based on cell values, such as highlighting cells above a certain threshold.
What is the maximum number of rows in an Excel worksheet (Excel 2007 and later)?
Answer: 1,048,576
Starting with Excel 2007, worksheets support up to 1,048,576 rows (2^20), a significant increase from the 65,536 row limit in earlier versions.
Which keyboard shortcut opens the Find and Replace dialog in Excel?
Answer: Ctrl+H
Ctrl+H opens the Find and Replace dialog directly on the Replace tab, while Ctrl+F opens it on the Find tab.
What does the $ symbol do when used in a cell reference like $A$1?
Answer: Makes the reference absolute so it does not change when copied
The $ symbol creates an absolute reference, preventing the column and/or row from adjusting when the formula is copied to other cells.
Which Excel tool allows you to see the impact of changing input values on formula results?
Answer: What-If Analysis (Data Tables)
What-If Analysis with Data Tables lets you substitute different input values into formulas to see how results change, making it ideal for sensitivity analysis.
What happens when you press Ctrl+Shift+L in Excel?
Answer: Toggles AutoFilter on the selected data range
Ctrl+Shift+L toggles the AutoFilter dropdowns on or off for the selected data range, enabling quick data filtering.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- store.certiport.com — Fees, retake fee · verified Nov 2026
- certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
- learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026