Practice Test GeeksPractice Test Geeks
← All Microsoft Excel Flashcard Decks

Functions Flashcards

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

Read the first 7 Functions flashcards as text

  1. What does the CHOOSE function do?

    Answer: Returns a value from a list based on an index number

    CHOOSE uses an index number to return a value from a list of up to 254 values.

  2. Which function calculates the straight-line depreciation of an asset for one period?

    Answer: SLN

    SLN calculates the straight-line depreciation of an asset by subtracting salvage value from cost and dividing by the asset's useful life.

  3. What is the correct syntax for a nested IF that returns "High" if A1>90, "Mid" if A1>50, else "Low"?

    Answer: =IF(A1>90,"High",IF(A1>50,"Mid","Low"))

    Nested IFs place a second IF as the false-result of the first, allowing multiple conditions to be checked in sequence.

  4. What does the NETWORKDAYS function calculate?

    Answer: The number of working days between two dates, excluding weekends

    NETWORKDAYS calculates the number of working days between a start and end date, automatically excluding Saturdays and Sundays.

  5. Which function returns the logical AND of multiple conditions?

    Answer: AND

    AND returns TRUE only if all its arguments evaluate to TRUE, otherwise it returns FALSE.

  6. What does =TEXT(1234.5, "$#,##0.00") return?

    Answer: $1,234.50

    TEXT formats a number as text using the specified format code, so 1234.5 becomes "$1,234.50" with thousands separator and two decimal places.

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

    Answer: LEN

    LEN returns the length of a text string, counting every character including spaces.