Vocabulary - Google Sheets

Front

A collection of worksheets which are stored together in a single file and given a single name.

Back

Workbook

Front

A single sheet (page) of rows and columns in a workbook.

Back

Worksheets

Front

Intersection of a column and a row on a worksheet

Back

Cells

Front

a range of cells that go down (vertical) in a spreadsheet/worksheet

Back

Column

Front

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

Back

Row

Front

What keeps a row/column from moving when scrolling on a sheet, making it easier to align data with its correct heading?

Back

Freeze Row/Column

Front

A method of limiting the entries and responses used in a spreadsheet

Back

Data Validation

Front

Puts data from a specific range, such as a column, in numerical or alphabetical order.

Back

Sort

Front

Temporarily hide data in a spreadsheet so you see only a selection of specific rows or values

Back

Filter

Front

What feature in spreadsheet software allows you to save different filter settings for later use? Options: Filter Views, Functions, Row, Column

Back

Filter Views