Microsoft Excel Formulas 2

Question 1

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

Accepted Answer

MATCH

Answer

FIND

Answer

SEARCH

Answer

INDEX

Question 2

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

Accepted Answer

Error

Answer

0

Answer

#DIV/0!

Answer

FALSE

Question 3

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

Accepted Answer

$A$1

Answer

A1

Answer

$A1

Answer

A$

Question 4

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

Accepted Answer

2

Answer

3

Answer

3.4

Answer

1

Question 5

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

Accepted Answer

COUNT

Answer

COUNTA

Answer

COUNTIF

Answer

COUNTBLANK

Question 6

The formula =LEFT("PracticeTest", 8) returns which string?

Accepted Answer

Practice

Answer

TestGeek

Answer

PracticeT

Answer

racticeT

Question 7

What happens when you enter a formula that creates a circular reference in Excel?

Accepted Answer

Excel displays a warning and may return 0 or an error

Answer

Excel deletes the formula automatically

Answer

Excel returns zero by default

Answer

Excel solves it using Goal Seek