Microsoft Excel Functions 2

Question 1

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

Accepted Answer

MATCH

Answer

INDEX

Answer

VLOOKUP

Answer

OFFSET

Question 2

What does the IFERROR function do?

Accepted Answer

Replaces error values with a specified result

Answer

Returns TRUE if a cell contains an error

Answer

Counts cells that contain errors

Answer

Highlights cells with errors

Question 3

Which function calculates the number of days between two dates?

Accepted Answer

DATEDIF

Answer

DATEIF

Answer

DAYS

Answer

NETDAYS

Question 4

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

Accepted Answer

Micro

Answer

osoft

Answer

soft

Question 5

Which function converts text to all uppercase letters?

Accepted Answer

UPPER

Answer

CAPS

Answer

PROPER

Answer

TEXT

Question 6

What does =ROUND(3.567, 2) return?

Accepted Answer

3.57

Answer

3.5

Answer

3.56

Answer

4.0

Question 7

Which function returns the largest value in a set of values?

Accepted Answer

MAX

Answer

LARGE

Answer

TOP

Answer

HIGHEST