Microsoft Excel Functions 2 — Questions and Answers
Question 1: Which function returns the position of a value within a range?
- INDEX
- MATCH (Correct answer)
- VLOOKUP
- OFFSET
Correct answer: MATCH
MATCH returns the relative position of a value within a range, not the value itself.
Question 2: What does the IFERROR function do?
- Returns TRUE if a cell contains an error
- Replaces error values with a specified result (Correct answer)
- Counts cells that contain errors
- Highlights cells with errors
Correct 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.
Question 3: Which function calculates the number of days between two dates?
- DATEIF
- DATEDIF (Correct answer)
- DAYS
- NETDAYS
Correct answer: DATEDIF
DATEDIF calculates the difference between two dates in specified units (days, months, or years).
Question 4: What is the result of =LEFT("Microsoft", 5)?
- Micro (Correct answer)
- osoft
- Micro
- soft
Correct answer: Micro
LEFT extracts the specified number of characters from the start of a text string, so LEFT("Microsoft", 5) returns "Micro".
Question 5: Which function converts text to all uppercase letters?
- UPPER (Correct answer)
- CAPS
- PROPER
- TEXT
Correct answer: UPPER
UPPER converts all characters in a text string to uppercase.
Question 6: What does =ROUND(3.567, 2) return?
- 3.5
- 3.57 (Correct answer)
- 3.56
- 4.0
Correct answer: 3.57
ROUND rounds 3.567 to 2 decimal places, which gives 3.57 because the third decimal (7) is ≥ 5.
Question 7: Which function returns the largest value in a set of values?
- LARGE
- MAX (Correct answer)
- TOP
- HIGHEST
Correct answer: MAX
MAX returns the largest numeric value in a range or list of values.
Microsoft Excel Functions 2
Which function returns the position of a value within a range?