Formulas and Functions Application 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 Application flashcards as text
What does XLOOKUP's 'if_not_found' parameter do?
Answer: Returns a custom value instead of #N/A when no match is found
It returns a friendly value instead of #N/A, eliminating the need for IFERROR wrapping.
How does the FILTER function work in Excel 365?
Answer: Returns an array of values meeting specified criteria
FILTER returns a dynamic array of rows satisfying Boolean conditions.
What differs between SEARCH and FIND functions?
Answer: SEARCH is case-insensitive with wildcards, FIND is case-sensitive without
SEARCH is case-insensitive and supports wildcards (* and ?); FIND is case-sensitive.
What does SEQUENCE generate in Excel 365?
Answer: Array of sequential numbers with specified rows, columns, start, and step
SEQUENCE generates a dynamic array of sequential numbers.
How does SORTBY differ from SORT?
Answer: SORTBY sorts by values in a different range; SORT sorts by columns within the array
SORTBY sorts based on external arrays, SORT sorts by column index within the array.
What does XMATCH return?
Answer: The relative position of a value with exact, wildcard, and approximate matching
XMATCH returns position with flexible matching modes and search directions.
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