Spreadsheet Basics
Every formula in Google Sheets must begin with this character.
What is the equals sign (=)
This simple function adds up all numeric values within a designated cell range.
What is SUM?
Located to the left of the Formula Bar, this box displays active cell coordinates and allows rapid navigation.
What is the Name Box?
To lock Row 1 in place while scrolling down a massive sheet, navigate to this menu path.
What is View > Freeze > 1 row?
This feature temporarily hides rows that don't meet designated criteria without deleting any underlying data.
What are Filters (or Filter Views)?
This is the term for a highlightable collection or group of adjacent cells (e.g., A1:C10).
What is a cell range?
This statistical function returns the mathematical mean of a selected set of numbers.
What is AVERAGE?
To jump instantly to cell Z100 using the Name Box, you perform this step.
What is typing Z100 into the Name Box and pressing Enter?
This primary visual advantage explains why users freeze header rows on large spreadsheets.
What is keeping column headers visible while scrolling through data rows?
This feature restricts cell inputs to specific choices, such as drop-down menus or valid dates/emails.
What is Data Validation?
This keyboard symbol is used to perform multiplication in formulas.
What is the asterisk (*)?
In the formula =SORT(A2:B10, 2, FALSE), this argument tells Sheets to order column 2 in descending order.
What is FALSE?
The top-level menu path used to manage and create custom named ranges.
What is Data > Named ranges?
You can apply currency formatting to selected cells by clicking this symbol on the top toolbar.
What is the dollar sign ($) button or Format > Number > Currency?
This analytical tool aggregates and cross-tabulates massive datasets into summary tables without writing complex math formulas.
What is a Pivot Table?
True or False: Google Sheets automatically saves your document edits to Google Drive in real-time.
What is True?
This lookup function searches vertically down the first column of a dataset to find a value and return data from the same row.
What is VLOOKUP?
Between 2026_Sales, Sales 2026, and Sales_2026, this is the only valid Named Range format.
What is Sales_2026? (Cannot start with numbers or contain spaces)
The dollar signs in absolute reference =$A$2 perform this crucial task when copying formulas to new cells.
What is locking column and row references so they don't shift position?
If a user accidentally deletes critical data in a shared sheet, navigate here under the File menu to recover past edits.
What is File > Version history > See version history?
The recommended standard location/method for placing your name on submitted work files.
What is in the document header/title or designated student name cell?
The output type generated when using =FILTER(A2:B10, B2:B10 > 50).
What is a dynamic output array showing only rows where column B exceeds 50?
This primary benefit explains why professionals use named ranges like =SUM(Q1_Revenue) instead of raw cell references.
What is improving formula readability, clarity, and formula maintenance across tabs?
This formatting feature automatically alters a cell's background color (e.g., turning green) when values exceed $1,000.
What is Conditional Formatting?
This special function allows you to import live data ranges from an entirely separate Google Sheets file into your active sheet.
What is =IMPORTRANGE()?