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 does VLOOKUP's fourth argument (range_lookup) control?

    Answer: Exact match (FALSE) or approximate match (TRUE)

    FALSE requires exact match; TRUE allows approximate match from sorted data.

  2. How does the IF function handle nested conditions?

    Answer: Value_if_false can contain another IF for multiple conditions

    You can nest IF functions by placing another IF as the value_if_false argument.

  3. What is the difference between SUMIF and SUMIFS?

    Answer: SUMIF applies one criterion, SUMIFS applies multiple with AND logic

    SUMIF handles one condition; SUMIFS evaluates multiple criteria, summing where ALL are met.

  4. What replaced CONCATENATE and why?

    Answer: CONCAT and TEXTJOIN; they accept ranges and add delimiters

    CONCAT accepts ranges; TEXTJOIN adds delimiters and can skip empty cells.

  5. How does INDEX work with a single range?

    Answer: Returns the value at a specified row position

    INDEX returns the value at a given row and optional column position within a range.

  6. What are the three common VLOOKUP errors?

    Answer: #N/A (not found), #REF! (column exceeds range), #VALUE! (invalid arguments)

    Each error indicates a different setup problem with the lookup.