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

SEARCH

Answer

INDEX

Answer

FIND

Question 2

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

Accepted Answer

The value in cell A3

Answer

The value at row 3 column 3

Answer

The 3rd match in A1:A10

Answer

An error

Question 3

Which function counts cells that contain numbers?

Accepted Answer

COUNT

Answer

COUNTA

Answer

COUNTIF

Answer

COUNTBLANK

Question 4

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

Accepted Answer

2

Answer

3

Answer

4

Answer

5

Question 5

Which function rounds a number DOWN to the nearest integer?

Accepted Answer

INT

Answer

ROUND

Answer

FLOOR

Answer

TRUNC

Question 6

What does =CONCATENATE("Hello", " ", "World") return?

Accepted Answer

Hello World

Answer

HelloWorld

Answer

Hello  World

Answer

HELLO WORLD

Question 7

Which function extracts a substring from the middle of a text string?

Accepted Answer

MID

Answer

LEFT

Answer

RIGHT

Answer

TRIM