MCAS Formulas, Functions & Calculations 3

Question 1

In Excel, which function rounds a number DOWN to the nearest integer regardless of decimal value?

Accepted Answer

INT

Answer

ROUND

Answer

CEILING

Answer

TRUNC

Question 2

In Excel, what does the #NAME? error indicate?

Accepted Answer

Excel does not recognize a text string in the formula, often due to a misspelled function name

Answer

A referenced cell contains text instead of a number

Answer

The formula references a cell that no longer exists

Answer

A circular reference has been detected

Question 3

What does the Excel formula =LEFT(A1, 3) return if cell A1 contains the text 'Microsoft'?

Accepted Answer

Mic

Answer

sof

Answer

oft

Answer

ros

Question 4

In Excel, which function calculates the total payment amount for a loan given the interest rate, number of periods, and present value?

Accepted Answer

PMT

Answer

RATE

Answer

NPER

Answer

FV

Question 5

In Excel, what is the purpose of the IFERROR function?

Accepted Answer

It returns a custom value or message when a formula produces an error instead of showing the error code

Answer

It generates a list of all errors found in the worksheet

Answer

It corrects formula errors automatically

Answer

It highlights cells containing errors in red

Question 6

In Excel, which function returns the number of characters in a text string?

Accepted Answer

LEN

Answer

COUNT

Answer

SIZE

Answer

CHARS