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. Which function returns the position of a value within a range?

    Answer: MATCH

    MATCH returns the relative position of a lookup value within a range.

  2. What does the formula =INDEX(A1:A10, 3) return?

    Answer: The value in cell A3

    INDEX returns the value at the specified row position within the given range, so row 3 of A1:A10 is A3.

  3. Which function counts cells that contain numbers?

    Answer: COUNT

    COUNT counts only cells that contain numeric values, while COUNTA counts all non-empty cells.

  4. What is the result of =MOD(17, 5)?

    Answer: 2

    MOD returns the remainder after division, and 17 divided by 5 is 3 remainder 2.

  5. Which function rounds a number DOWN to the nearest integer?

    Answer: INT

    INT always rounds a number down to the nearest integer, even for negative numbers.

  6. What does =CONCATENATE("Hello", " ", "World") return?

    Answer: Hello World

    CONCATENATE joins all text arguments in order, including the space character in the middle.

  7. Which function extracts a substring from the middle of a text string?

    Answer: MID

    MID extracts characters starting at a specified position for a given number of characters.

How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy