Functions 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 Functions flashcards as text
Which function returns the position of a value within a range?
Answer: MATCH
MATCH returns the relative position of a value within a range, not the value itself.
What does the IFERROR function do?
Answer: Replaces error values with a specified result
IFERROR evaluates an expression and returns a custom value if it produces an error, otherwise returns the expression result.
Which function calculates the number of days between two dates?
Answer: DATEDIF
DATEDIF calculates the difference between two dates in specified units (days, months, or years).
What is the result of =LEFT("Microsoft", 5)?
Answer: Micro
LEFT extracts the specified number of characters from the start of a text string, so LEFT("Microsoft", 5) returns "Micro".
Which function converts text to all uppercase letters?
Answer: UPPER
UPPER converts all characters in a text string to uppercase.
What does =ROUND(3.567, 2) return?
Answer: 3.57
ROUND rounds 3.567 to 2 decimal places, which gives 3.57 because the third decimal (7) is ≥ 5.
Which function returns the largest value in a set of values?
Answer: MAX
MAX returns the largest numeric value in a range or list of values.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. 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
- learn.microsoft.com — Retake policy, test delivery, time limit, eligibility · verified Oct 2026
- certiport.pearsonvue.com — Exam format, score validity, passing score, score release, exam information · verified Oct 2026