Microsoft Excel Functions 4

Question 1

Which function returns a value from a specific row and column within a given range?

Accepted Answer

INDEX

Answer

INDEX returns the value at the intersection of a specified row and column within a range.

Question 2

What does =SUMIF(A1:A10, ">100", B1:B10) calculate?

Accepted Answer

Sum of B1:B10 where corresponding A values are greater than 100

Answer

SUMIF sums values in B1:B10 only for rows where the corresponding value in A1:A10 is greater than 100.

Question 3

Which function converts a number into text formatted as currency?

Accepted Answer

DOLLAR

Answer

DOLLAR converts a number to text in currency format, with optional decimal places, using the $ symbol.

Question 4

What does the EXACT function do?

Accepted Answer

Compares two text strings and returns TRUE if they are identical (case-sensitive)

Answer

EXACT performs a case-sensitive comparison of two text strings, returning TRUE only if they match exactly.

Question 5

Which function returns the nth largest value in a data set?

Accepted Answer

LARGE

Answer

LARGE returns the k-th largest value in a data set, where k is the second argument.

Excel Practice Test