Practice Test GeeksPractice Test Geeks
← All Microsoft Excel Flashcard Decks

Functions Flashcards

7 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 7 Functions flashcards as text

  1. What does the CONCATENATE function (or & operator) do in Excel?

    Answer: Joins multiple text strings into one

    CONCATENATE joins two or more text strings into a single string; the & operator achieves the same result.

  2. Which function counts only the cells in a range that are not empty?

    Answer: COUNTA

    COUNTA counts all non-empty cells, including those with text, numbers, or errors.

  3. What does the NOW() function return?

    Answer: The current date and time

    NOW() returns the current date and time as a serial number formatted as a date and time.

  4. Which Excel function finds a value in the first column of a table and returns a value in the same row from another column?

    Answer: VLOOKUP

    VLOOKUP (Vertical Lookup) searches the first column of a range and returns a value from a specified column in the same row.

  5. What is the purpose of the ABS function?

    Answer: Returns the absolute (positive) value of a number

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

  6. Which function returns the remainder after dividing one number by another?

    Answer: MOD

    MOD returns the remainder when the first argument is divided by the second argument.

  7. What does the TRIM function do?

    Answer: Removes leading and trailing spaces and reduces internal spaces to one

    TRIM removes leading and trailing spaces and reduces multiple consecutive spaces between words to a single space.

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. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

  1. learn.microsoft.com — Retake policy, test delivery, time limit, eligibility · verified Oct 2026
  2. certiport.pearsonvue.com — Exam format, score validity, passing score, score release, exam information · verified Oct 2026