MOS Excel: Formulas and Functions 2

Question 1

Which function returns the number of characters in a text string?

Accepted Answer

LEN

Answer

LEN returns the number of characters in a text string, including spaces.

Question 2

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

Accepted Answer

Error

Answer

IFERROR catches the division-by-zero error and returns the specified value "Error" instead.

Question 3

Which function finds the position of a substring within a text string, case-insensitively?

Accepted Answer

SEARCH

Answer

SEARCH is case-insensitive and returns the position of a substring, while FIND is case-sensitive.

Question 4

What result does =ROUND(2.567, 2) produce?

Accepted Answer

2.57

Answer

ROUND(2.567, 2) rounds to 2 decimal places, and the third decimal (7) rounds up the second decimal from 6 to 7.

Question 5

A formula uses the range name 'SalesData'. What type of reference is this?

Accepted Answer

Named range reference

Answer

Named ranges provide a descriptive label for a cell or range that acts like an absolute reference and is easier to read.

MOS - Microsoft Office Specialist Certification Practice Test