Spreadsheets Vocabulary Quiz

What is a spreadsheet?

• A digital sheet made up of rows and columns used to organize, calculate, and analyze data.

• A single box in a spreadsheet where you can enter data.

• A math equation or command you type into a cell.

• A tool that hides data that doesn’t meet certain criteria.

What is a cell in a spreadsheet?

• A single box in a spreadsheet where you can enter data.

• A vertical line of cells in a spreadsheet.

• A tool that automatically fills cells with data.

• A feature that changes the color of a cell based on the value inside it.

What is a row in a spreadsheet?

• A horizontal line of cells in a spreadsheet, labeled with numbers.

• A vertical line of cells in a spreadsheet, labeled with letters.

• A tool that organizes data in a specific order.

• A feature that keeps certain rows or columns visible.

What is a column in a spreadsheet?

• A vertical line of cells in a spreadsheet, labeled with letters.

• A horizontal line of cells in a spreadsheet, labeled with numbers.

• A tool that hides data that doesn’t meet certain criteria.

• A feature that changes the color of a cell based on the value inside it.

What is a cell reference?

• The unique name of a cell based on its column letter and row number.

• A tool that automatically fills cells with data based on a pattern.

• A feature that keeps certain rows or columns visible.

• A row of buttons at the top of Google Sheets.

What is a formula in a spreadsheet?

• A math equation or command you type into a cell to perform calculations.

• A tool that organizes data in a specific order.

• A feature that changes the color of a cell based on the value inside it.

• A visual representation of data, like a graph or pie chart.

What is a function in Google Sheets?

• A built-in tool that performs specific calculations, like adding numbers or finding an average.

• A tool that hides data that doesn’t meet certain criteria.

• A feature that keeps certain rows or columns visible.

• A row of buttons at the top of Google Sheets.

What is a sheet tab in Google Sheets?

• The tabs at the bottom of Google Sheets that let you organize and switch between multiple sheets in one file.

• A tool that automatically fills cells with data based on a pattern.

• A feature that changes the color of a cell based on the value inside it.

• A visual representation of data, like a graph or pie chart.

What is a data range in a spreadsheet?

• A group of selected cells in the spreadsheet.

• A tool that organizes data in a specific order.

• A feature that keeps certain rows or columns visible.

• A row of buttons at the top of Google Sheets.

What is the purpose of the sort function?

• To organize data in a specific order, like alphabetical or numerical.

• To hide data that doesn’t meet certain criteria.

• To automatically fill cells with data based on a pattern.

• To change the color of a cell based on the value inside it.