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.