Formulas and Functions 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 Formulas and Functions flashcards as text
What does VLOOKUP's fourth argument (range_lookup) control?
Answer: Exact match (FALSE) or approximate match (TRUE)
FALSE requires exact match; TRUE allows approximate match from sorted data.
How does the IF function handle nested conditions?
Answer: Value_if_false can contain another IF for multiple conditions
You can nest IF functions by placing another IF as the value_if_false argument.
What is the difference between SUMIF and SUMIFS?
Answer: SUMIF applies one criterion, SUMIFS applies multiple with AND logic
SUMIF handles one condition; SUMIFS evaluates multiple criteria, summing where ALL are met.
What replaced CONCATENATE and why?
Answer: CONCAT and TEXTJOIN; they accept ranges and add delimiters
CONCAT accepts ranges; TEXTJOIN adds delimiters and can skip empty cells.
How does INDEX work with a single range?
Answer: Returns the value at a specified row position
INDEX returns the value at a given row and optional column position within a range.
What are the three common VLOOKUP errors?
Answer: #N/A (not found), #REF! (column exceeds range), #VALUE! (invalid arguments)
Each error indicates a different setup problem with the lookup.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- store.certiport.com — Fees, retake fee · verified Nov 2026
- certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
- learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026