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.