General Knowledge Flashcards
7 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 7 General Knowledge flashcards as text
What is the purpose of the Excel 'Flash Fill' feature?
Answer: Automatically fills data based on a detected pattern in adjacent cells
Flash Fill (Ctrl+E) recognizes patterns from examples you type and automatically fills the remaining cells accordingly.
Which function would you use to find the position of a value in a list?
Answer: MATCH
MATCH returns the relative position (row or column number) of a value within a range.
What does 'Wrap Text' formatting do to a cell?
Answer: Displays the cell content on multiple lines within the same cell
Wrap Text increases the row height and displays long text on multiple lines within the cell rather than overflowing into adjacent cells.
Which Excel function returns the current date and time, updating every time the worksheet recalculates?
Answer: NOW()
NOW() returns the current date and time as a serial number and recalculates dynamically; TODAY() returns only the date.
What does a green triangle in the top-left corner of a cell typically indicate?
Answer: A potential error detected by Excel's error checking
The green triangle is Excel's error indicator, alerting you to a potential issue like a number stored as text or an inconsistent formula.
Which Excel feature allows you to set rules that automatically change cell background color based on the cell's value?
Answer: Conditional Formatting
Conditional Formatting applies formatting rules — such as color scales, data bars, or custom rules — based on cell values.
What is a PivotTable used for in Excel?
Answer: Summarizing, analyzing, and exploring large datasets interactively
A PivotTable lets you quickly summarize and analyze large datasets by dragging fields into rows, columns, values, and filter areas.