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 does XLOOKUP's 'if_not_found' parameter do?

    Answer: Returns a custom value instead of #N/A when no match is found

    It returns a friendly value instead of #N/A, eliminating the need for IFERROR wrapping.

  2. How does the FILTER function work in Excel 365?

    Answer: Returns an array of values meeting specified criteria

    FILTER returns a dynamic array of rows satisfying Boolean conditions.

  3. What differs between SEARCH and FIND functions?

    Answer: SEARCH is case-insensitive with wildcards, FIND is case-sensitive without

    SEARCH is case-insensitive and supports wildcards (* and ?); FIND is case-sensitive.

  4. What does SEQUENCE generate in Excel 365?

    Answer: Array of sequential numbers with specified rows, columns, start, and step

    SEQUENCE generates a dynamic array of sequential numbers.

  5. How does SORTBY differ from SORT?

    Answer: SORTBY sorts by values in a different range; SORT sorts by columns within the array

    SORTBY sorts based on external arrays, SORT sorts by column index within the array.

  6. What does XMATCH return?

    Answer: The relative position of a value with exact, wildcard, and approximate matching

    XMATCH returns position with flexible matching modes and search directions.