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 =DAYS("2026-12-31", "2026-01-01") calculate?

    Answer: The number of calendar days between the dates

    DAYS returns the total number of calendar days between two dates.

  2. Which function removes all spaces from a text string except single spaces between words?

    Answer: TRIM

    TRIM removes leading, trailing, and extra internal spaces, leaving only single spaces between words.

  3. What does the formula =SUMPRODUCT(A1:A5, B1:B5) do?

    Answer: Multiplies corresponding values then sums the results

    SUMPRODUCT multiplies corresponding elements in arrays and returns the sum of those products.

  4. Which function returns the current date and time that updates automatically?

    Answer: NOW()

    NOW() returns the current date and time and recalculates every time the worksheet is recalculated.

  5. What does =PROPER("hello world") return?

    Answer: Hello World

    PROPER capitalizes the first letter of each word and lowercases the remaining letters.

  6. Which function returns the number of characters in a text string?

    Answer: LEN

    LEN returns the length of a text string, counting every character including spaces.

  7. What does =NETWORKDAYS(start_date, end_date) calculate?

    Answer: Number of working days excluding weekends

    NETWORKDAYS returns the number of workdays between two dates, automatically excluding Saturdays and Sundays.