Vocabulary - Google Sheets

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

a range of cells that go across (horizontal) the spreadsheet/worksheet

• Row
• Filter Views
• Data Validation
• Filter

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

visible only when selected

• Filter Views
• Functions
• Row
• Column