Google Sheets Formulas and Basic Functions Flashcards
7 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Google Sheets Formulas and Basic Functions flashcards as text
Which function looks up a value in the first column of a range and returns a value from another column?
Answer: VLOOKUP
VLOOKUP searches vertically down the first column and returns a value from a specified column.
In =VLOOKUP(D2, A2:B10, 2, FALSE), what does FALSE specify?
Answer: An exact match is required
FALSE tells VLOOKUP to find an exact match rather than an approximate one.
What does the CONCATENATE function do?
Answer: Joins multiple text strings into one
CONCATENATE combines several strings into a single text value.
Which function removes extra spaces from text, leaving single spaces between words?
Answer: TRIM
TRIM strips leading, trailing, and duplicate internal spaces.
What does =TODAY() return?
Answer: The current date
TODAY returns the current date and updates automatically.
Which function converts text to all uppercase letters?
Answer: UPPER
UPPER converts every letter in a string to uppercase.
What does the #REF! error usually indicate?
Answer: A formula refers to a cell that no longer exists
#REF! appears when a referenced cell has been deleted or is invalid.
How this page was made: written with AI tools. 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