Excel Flashcards
7 cards from real MOS practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Excel flashcards as text
When sorting a table in Excel, what happens if you select 'My data has headers' in the Sort dialog?
Answer: The header row is excluded from sorting and remains at the top
Selecting 'My data has headers' tells Excel to exclude the first row from sorting so it stays as the column label.
Which Excel function returns a value from a table based on a row number and column number you specify?
Answer: INDEX
INDEX returns the value at the intersection of a specified row and column within a given range.
What format does Excel use to store dates internally?
Answer: Sequential serial numbers starting from January 1, 1900
Excel stores dates as sequential serial numbers — January 1, 1900 is 1 — which allows date arithmetic.
Which Excel feature highlights cells that meet conditions you define, using color scales, data bars, or icon sets?
Answer: Conditional Formatting
Conditional Formatting automatically applies formatting such as colors or icons to cells based on rules you define.
In Excel, what is a PivotTable primarily used for?
Answer: Summarizing, analyzing, and exploring large data sets interactively
A PivotTable lets you summarize and analyze large data sets by dragging fields into rows, columns, and value areas.
Which keyboard shortcut inserts the current time into a cell in Excel?
Answer: Ctrl+Shift+;
Ctrl+Shift+; inserts the current time as a static value into the active cell.
What does the IFERROR function do in Excel?
Answer: Returns a specified value if a formula results in an error, otherwise returns the formula's result
IFERROR evaluates a formula and returns a custom value if it produces an error, or the formula result if no error occurs.