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

The INT function rounds a number down to the nearest integer, always removing the decimal portion toward the lesser whole number.

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

#NAME? appears when Excel cannot identify a name in a formula, typically because a function name is misspelled or an unrecognized range name is used.

Question 3

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

Accepted Answer

Mic

Answer

LEFT extracts characters from the left side of a text string; =LEFT('Microsoft', 3) returns the first 3 characters: 'Mic'.

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

The PMT function calculates the periodic payment required for a loan based on constant payments and a constant interest rate.

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

IFERROR traps errors from a formula and returns a specified custom value (like 0 or 'N/A') instead of displaying an error code.

MCAS - Microsoft Certified Application Specialist Practice Test