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 does the IFERROR function do?

    Answer: Returns a custom value when a formula produces an error

    IFERROR evaluates a formula and returns a specified value instead of an error message if the formula produces an error.

  2. Which formula calculates the average of cells B1:B10 only where A1:A10 equals "Sales"?

    Answer: =AVERAGEIF(A1:A10,"Sales",B1:B10)

    AVERAGEIF calculates the average of a range based on a single condition in another range.

  3. What is the keyboard shortcut to enter an array formula in Excel?

    Answer: Ctrl+Shift+Enter

    Ctrl+Shift+Enter enters an array formula and wraps it in curly braces {}.

  4. Which function returns the largest value in a set of values?

    Answer: MAX

    MAX returns the maximum (largest) numeric value from a range or list of values.

  5. What does =TEXT(1234.5, "$#,##0.00") return?

    Answer: $1,234.50

    The TEXT function formats a number as text using the specified format code, adding a dollar sign and comma separator.

  6. Which function finds the second largest value in a range?

    Answer: LARGE(range,2)

    LARGE(range, k) returns the k-th largest value, so LARGE(range, 2) returns the second largest.

  7. What symbol is used to make a cell reference absolute in Excel?

    Answer: $

    The dollar sign $ locks a row or column reference so it does not change when the formula is copied.