GMetrix Exam GMetrix Excel: Formulas and 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 lookup value within a range.

Question 2

What does the formula =INDEX(A1:A10, 3) return?

Accepted Answer

The value in cell A3

Answer

INDEX returns the value at the specified row position within the given range, so row 3 of A1:A10 is A3.

Question 3

Which function counts cells that contain numbers?

Accepted Answer

COUNT

Answer

COUNT counts only cells that contain numeric values, while COUNTA counts all non-empty cells.

Question 4

What is the result of =MOD(17, 5)?

Accepted Answer

2

Answer

MOD returns the remainder after division, and 17 divided by 5 is 3 remainder 2.

Question 5

Which function rounds a number DOWN to the nearest integer?

Accepted Answer

INT

Answer

INT always rounds a number down to the nearest integer, even for negative numbers.

GMetrix Exam Practice Test