Practice Test GeeksExcel Practice Test
← All Microsoft Excel Flashcard Decks

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

  1. What is XLOOKUP's key advantage over VLOOKUP?

    Answer: Can search left, defaults to exact match, no column index needed

    XLOOKUP uses separate arrays (no column index), searches any direction, defaults exact match, has built-in error handling.

  2. How does the CHOOSE function work?

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

    CHOOSE returns the value at position index_num from up to 254 values.

  3. What does TRIM do and when is it essential?

    Answer: Removes extra spaces, leaving single spaces between words

    TRIM removes leading, trailing, and extra internal spaces.

  4. How does OFFSET create a dynamic reference?

    Answer: Returns a reference shifted from a starting point by rows, columns, and optional size

    OFFSET creates a reference offset from a starting cell with optional height and width.

  5. What is the difference between COUNT, COUNTA, COUNTBLANK, and COUNTIF?

    Answer: COUNT=numbers, COUNTA=non-empty, COUNTBLANK=empty, COUNTIF=by criteria

    Each counts different things based on its suffix.

  6. How does MATCH's match_type affect results?

    Answer: 0=exact, 1=largest=lookup (descending)

    Each match_type requires different data sorting and matching behavior.