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
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.
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.
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.
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.
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.
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.
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.