WorksheetsVocabulary - Google Sheets
Total questions: 18
Worksheet time: 9mins
a collection of worksheets which are stored together in a single file and given a single name.
Workbook
Cells
Row
Column
a single sheet (page) of rows and columns in a workbook
Cells
Worksheets
Row
Column
intersection of a column and a row on a worksheet
Column
Row
Cells
Freeze Row/Column
a range of cells that go down (vertical) in a spreadsheet/worksheet
Column
Data Validation
Row
Sort
keeps a row/column from moving when scrolling on a sheet making it easier to align data with its correct heading
Column
Filter
Row
Freeze Row/Column
a method of limiting the entries and responses used in a spreadsheet
Sort
Row
Data Validation
Filter Views
puts date from a specific range, such as a column, in numerical or alphabetical order
Filter
Sort
Column
SUM function
temporarily hide data in a spreadsheet so you see only a selection of specific rows or values
Data Validation
Formulas
SUM function
Filter
expressions which return values
Rows
Filter Views
Formulas
Columns
pre-set formulas used to make calculations in Google Sheets
Formulas
Functions
Column
Average
adds a range of values in spreadsheet cells
Column
Sort
Charts
SUM function
change when a formula is copied to another cell
Row
Filter Views
Relative Cell Reference
Absolute Cell Reference
remain constant when you copy them to another cell
Relative Cell Reference
Absolute Cell Reference
Charts
Functions
changes the background color of cells that contain specific information
Sort
Formulas
Average
Conditional Formatting
