Microsoft Excel Formulas

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 one-dimensional range.

Question 2

What does the formula =IFERROR(A1/B1, "Error") return when B1 is 0?

Accepted Answer

Error

Answer

IFERROR returns the second argument whenever the first argument produces any error, including #DIV/0!.

Question 3

Which of the following is a valid absolute cell reference in a formula?

Accepted Answer

$A$1

Answer

$A$1 locks both the column and row so the reference doesn't change when copied.

Question 4

What result does =MOD(17, 5) return?

Accepted Answer

2

Answer

MOD returns the remainder after division; 17 ÷ 5 = 3 remainder 2.

Question 5

Which function counts only the cells in a range that contain numbers?

Accepted Answer

COUNT

Answer

COUNT tallies only numeric values, ignoring text, blanks, and errors.

Excel Practice Test