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
Which function returns the number of cells in a range that meet a single condition?
Answer: COUNTIF
COUNTIF counts cells in a range that satisfy one specified criterion.
What does the VLOOKUP function search by default in its lookup range?
Answer: The first column
VLOOKUP always searches for the key in the first column of the specified range.
To keep both a row and a column fixed when copying a formula, which reference is correct?
Answer: $A$1
Placing a dollar sign before both the column letter and row number creates a fully absolute reference.
Which function joins text from multiple cells into one string with a chosen separator?
Answer: TEXTJOIN
TEXTJOIN combines text with a specified delimiter and can ignore empty cells.
What does the IFERROR function do when its first argument evaluates to an error?
Answer: Returns the alternative value you provide
IFERROR returns your specified fallback value instead of showing the error.
Which keyboard shortcut inserts the current date into a cell in Google Sheets?
Answer: Ctrl+;
Ctrl+; (semicolon) inserts today's static date into the selected cell.
What is the result of the formula =AVERAGE(2, 4, 6)?
Answer: 4
The average of 2, 4, and 6 is 12 divided by 3, which equals 4.
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