Microsoft Excel General Knowledge 4 — Questions and Answers
Question 1: What is the purpose of the Excel 'Flash Fill' feature?
- Automatically fills data based on a detected pattern in adjacent cells (Correct answer)
- Fills a range with a gradient color
- Copies a formula down an entire column instantly
- Highlights cells that match a pattern
Correct 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.
Question 2: Which function would you use to find the position of a value in a list?
- MATCH (Correct answer)
- INDEX
- VLOOKUP
- FIND
Correct answer: MATCH
MATCH returns the relative position (row or column number) of a value within a range.
Question 3: What does 'Wrap Text' formatting do to a cell?
- Displays the cell content on multiple lines within the same cell (Correct answer)
- Merges the cell with adjacent cells
- Shrinks the font to fit the cell width
- Applies a border around the cell
Correct 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.
Question 4: Which Excel function returns the current date and time, updating every time the worksheet recalculates?
- NOW() (Correct answer)
- TODAY()
- DATE()
- TIME()
Correct answer: NOW()
NOW() returns the current date and time as a serial number and recalculates dynamically; TODAY() returns only the date.
Question 5: What does a green triangle in the top-left corner of a cell typically indicate?
- A potential error detected by Excel's error checking (Correct answer)
- The cell is selected
- The cell contains a comment
- A conditional formatting rule is applied
Correct 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.
Question 6: Which Excel feature allows you to set rules that automatically change cell background color based on the cell's value?
- Conditional Formatting (Correct answer)
- Cell Styles
- Format as Table
- Data Validation
Correct answer: Conditional Formatting
Conditional Formatting applies formatting rules — such as color scales, data bars, or custom rules — based on cell values.
Question 7: What is a PivotTable used for in Excel?
- Summarizing, analyzing, and exploring large datasets interactively (Correct answer)
- Creating pivot-style animations in charts
- Rotating a table 90 degrees for printing
- Converting rows to columns automatically
Correct 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.
Microsoft Excel General Knowledge 4
What is the purpose of the Excel 'Flash Fill' feature?