Practice Test GeeksGMetrix Exam Practice Test
← All GMetrix Exam Flashcard Decks

GMetrix Excel: Formulas and Functions Flashcards

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

Read the first 7 GMetrix Excel: Formulas and Functions flashcards as text

  1. What is the purpose of the XLOOKUP function compared to VLOOKUP?

    Answer: XLOOKUP can search in any direction and returns a range instead of a column index

    XLOOKUP searches in any direction, returns an array, and doesn't require a col_index_num like VLOOKUP.

  2. Which function converts a text string to all uppercase letters?

    Answer: UPPER

    UPPER converts every letter in a text string to uppercase.

  3. What does =CHOOSE(2, "Apple", "Banana", "Cherry") return?

    Answer: Banana

    CHOOSE returns the value from the list that corresponds to the index number; index 2 returns the second value.

  4. Which statistical function returns the most frequently occurring value in a range?

    Answer: MODE

    MODE returns the value that appears most often in a data set.

  5. What does the formula =A1&" "&B1 do?

    Answer: Joins the text values of A1, a space, and B1

    The ampersand & operator concatenates text values, combining A1, a space, and B1 into one string.

  6. Which function returns the absolute (positive) value of a number?

    Answer: ABS

    ABS returns the absolute value of a number, removing any negative sign.

  7. What does =COUNTIFS(A1:A10,">5",B1:B10,"<10") do?

    Answer: Counts rows where A is greater than 5 AND B is less than 10

    COUNTIFS counts rows where all specified conditions are true simultaneously, using AND logic across multiple criteria.