Basic and Advance 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 Basic and Advance flashcards as text
What does the MATCH function return?
Answer: The relative position of a value within a range
MATCH returns the relative position (1-based number) of a lookup value within a one-dimensional range.
Which Excel data tool removes duplicate rows from a selected range or table?
Answer: Remove Duplicates
The Remove Duplicates command on the Data tab deletes rows where every selected column's value is identical to another row.
What is the function of Data Validation in Excel?
Answer: It restricts the type or range of data a user can enter in a cell
Data Validation sets rules (whole numbers, dates, list choices, etc.) that limit what values can be entered into a cell.
In Excel, what is a named range?
Answer: A descriptive name assigned to a cell or range for use in formulas
A named range assigns a meaningful label to a cell or range so formulas can reference it by name instead of cell address.
Which function calculates the payment for a loan based on constant payments and a constant interest rate?
Answer: PMT
PMT(rate, nper, pv) calculates the fixed periodic payment required to pay off a loan over a set number of periods at a given interest rate.
What happens to a PivotTable when the underlying source data changes?
Answer: It must be manually refreshed to reflect the new data
PivotTables do not update automatically; you must right-click and choose Refresh (or use Data → Refresh All) to pull in changed source data.
Which Excel feature records a sequence of actions so they can be replayed automatically on demand?
Answer: Macro
A macro records a series of Excel commands and keystrokes that can be run again with a single click or keyboard shortcut, automating repetitive tasks.