Google Sheets Formula 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 Formula flashcards as text
Which formula looks up "Apple" in column A and returns the matching value from column C?
Answer: =VLOOKUP("Apple",A:C,3,FALSE)
VLOOKUP searches column A and returns column 3 (C) with an exact match.
What does the FALSE argument in VLOOKUP request?
Answer: An exact match
FALSE (or 0) forces VLOOKUP to require an exact match.
Which formula sums B1:B10 only where A1:A10 equals "North"?
Answer: =SUMIF(A1:A10,"North",B1:B10)
SUMIF checks the range, matches the criterion, then sums the sum_range.
What does =INDEX(A1:A10,3) return?
Answer: The 3rd value in A1:A10
INDEX returns the item at the given position within a range.
Which function finds the position of "Blue" within the range A1:A5?
Answer: =MATCH("Blue",A1:A5,0)
MATCH returns the relative position of a value in a range.
What is a key advantage of INDEX/MATCH over VLOOKUP?
Answer: It can look up values to the left of the search column
INDEX/MATCH can return columns to the left, which VLOOKUP cannot.
What does =XLOOKUP("Red",A1:A5,B1:B5) return if "Red" is not found and no default is given?
Answer: #N/A
Without an if_not_found argument, XLOOKUP returns #N/A.
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