Practice Test GeeksExcel Practice Test
← All Microsoft Excel Flashcard Decks

Formulas and Functions Application Flashcards

6 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 6 Formulas and Functions Application flashcards as text

  1. What is the difference between relative and absolute cell references?

    Answer: Relative adjust when copied, absolute (with $) stay fixed

    Relative references adjust when copied; absolute references ($A$1) remain fixed.

  2. What does COUNTIFS do that COUNTIF cannot?

    Answer: Apply multiple criteria across different ranges simultaneously

    COUNTIFS evaluates multiple criteria across multiple ranges, counting only when ALL are met.

  3. How does ROUND differ from TRUNC?

    Answer: ROUND applies mathematical rounding, TRUNC removes decimals without rounding

    ROUND follows rounding rules (5 rounds up); TRUNC simply cuts off digits.

  4. What does the TEXT function do?

    Answer: Formats a number as text using a format code

    TEXT converts a numeric value to text with a specific format.

  5. How does AVERAGEIFS calculate its result?

    Answer: Averages values where all corresponding criteria are met

    AVERAGEIFS averages values in a range only where ALL corresponding criteria are satisfied.

  6. What does the UNIQUE function do in Excel 365?

    Answer: Extracts distinct values from a range as a dynamic array

    UNIQUE returns a dynamic array of distinct values, removing duplicates.