Google Sheet Expert 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 Sheet Expert flashcards as text
What does the INDEX function return when given a range, row, and column number?
Answer: The value at that position
INDEX returns the value located at the specified row and column within a range.
Which function counts the total number of non-empty cells in a range?
Answer: COUNTA
COUNTA counts all non-empty cells, including text and numbers.
What does the TRIM function do to a text value?
Answer: Removes extra spaces
TRIM removes leading, trailing, and repeated spaces from text.
Which function would you use to pull live data from another Google Sheet?
Answer: IMPORTRANGE
IMPORTRANGE imports a range of cells from a specified external Google Sheet.
What is the result of the formula =CONCATENATE("Go", "ogle")?
Answer: Google
CONCATENATE joins the two strings directly to produce "Google".
Which function returns the current date and time, updating automatically?
Answer: NOW
NOW returns the current date and time and recalculates on each update.
What does a #REF! error typically indicate in a formula?
Answer: An invalid or deleted cell reference
#REF! appears when a formula points to a cell reference that is invalid or has been deleted.
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