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 returns a value from a range based on row and column numbers?
Answer: INDEX
INDEX returns the value at a given row and column position within a range.
What does MATCH return when it finds a value in a range?
Answer: The position of the value
MATCH returns the relative position of a lookup value within a range.
Which function returns the current date and time together?
Answer: NOW
NOW returns both the current date and time.
What does =ARRAYFORMULA(A1:A5*B1:B5) allow you to do?
Answer: Apply a formula across an entire range at once
ARRAYFORMULA processes multiple values in a range with a single formula.
Which function counts cells in A1:A10 that contain the text "Yes"?
Answer: =COUNTIF(A1:A10, "Yes")
COUNTIF with the criterion "Yes" counts only matching cells.
What does the IFERROR function do?
Answer: Returns a specified value if a formula produces an error
IFERROR replaces an error result with a value you define, such as a blank or message.
Which function extracts the leftmost characters from a text string?
Answer: LEFT
LEFT returns a specified number of characters from the start of a string.
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