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, what error value appears when a formula attempts to divide a number by zero?

    Answer: #DIV/0!

    #DIV/0! is the error Excel displays whenever a formula tries to divide by zero or an empty cell.

  2. Which Excel function is used to look up a value in the first column of a table and return a value in the same row from another column?

    Answer: VLOOKUP

    VLOOKUP searches the first column of a range vertically and returns a value from a specified column in the same row.

  3. In Excel, what is the correct syntax to calculate 15% of the value in cell B2?

    Answer: =B2*15%

    Multiplying the cell value by 15% (which Excel treats as 0.15) calculates the percentage of that value.

  4. What does the Excel function =TODAY() return?

    Answer: The current date, updated automatically each time the workbook is opened or recalculated

    =TODAY() is a volatile function that returns the current system date and updates every time the workbook recalculates.

  5. In Excel, what does the CONCATENATE function (or the & operator) do?

    Answer: Joins two or more text strings into one string

    CONCATENATE and the & operator both join (combine) multiple text strings into a single combined text string.

  6. In Excel, what is the difference between COUNT and COUNTA?

    Answer: COUNT counts only numeric cells; COUNTA counts all non-empty cells regardless of type

    COUNT only tallies cells containing numbers, while COUNTA counts any non-empty cell including text, dates, and numbers.