Practice Test GeeksMCAS - Microsoft Certified Application Specialist Practice Test
← All MCAS Flashcard Decks

Formulas, Functions & Calculations Flashcards

6 cards from real MCAS practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Formulas, Functions & Calculations flashcards as text

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

    Answer: INT

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

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

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

    #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.

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

    Answer: Mic

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

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

    Answer: PMT

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

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

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

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

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

    Answer: LEN

    The LEN function returns the total number of characters (including spaces) in a text string.