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 symbol must every formula in Google Sheets begin with?
Answer: =
All Google Sheets formulas start with an equals sign.
What does =SUM(A1:A5) return?
Answer: The total of cells A1 through A5
SUM adds all numeric values in the specified range.
Which function returns the number of cells in a range that contain numbers?
Answer: COUNT
COUNT counts only cells containing numeric values.
What will =AVERAGE(2, 4, 6) return?
Answer: 4
The average of 2, 4, and 6 is 12 divided by 3, which equals 4.
Which function finds the highest value in a range?
Answer: MAX
MAX returns the largest number in the given range.
What does the & operator do in a formula?
Answer: Joins (concatenates) text values
The ampersand concatenates strings, such as =A1&" "&B1.
Which function counts the number of non-empty cells in a range regardless of type?
Answer: COUNTA
COUNTA counts every cell that is not empty, including text.
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