Microsoft Excel Functions 2

Question 1

Which function returns the position of a value within a range?

Accepted Answer

MATCH

Answer

MATCH returns the relative position of a value within a range, not the value itself.

Question 2

What does the IFERROR function do?

Accepted Answer

Replaces error values with a specified result

Answer

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?

Accepted Answer

DATEDIF

Answer

DATEDIF calculates the difference between two dates in specified units (days, months, or years).

Question 4

What is the result of =LEFT("Microsoft", 5)?

Accepted Answer

Micro

Answer

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?

Accepted Answer

UPPER

Answer

UPPER converts all characters in a text string to uppercase.

Excel Practice Test