Unit 4: Spreadsheets

What is a cell in a spreadsheet?

• A single box where you can enter data

• A row of data

• A column of data

• A formula in the sheet

What does the SUM function do?

• Multiplies two numbers

• Adds up a range of numbers

• Finds the average of a range

• Creates a chart

Which symbol is used to start a formula in Google Sheets?

• %

• $

• =

• #

What is a chart used for in a spreadsheet?

• To delete data

• To visually represent data

• To protect data

• To format data

Which feature is used to arrange data in alphabetical or numerical order?

• Filter

• Sort

• Freeze

• Format

What is a formula in a spreadsheet?

• A visual representation of data

• A single box where data is entered

• An equation that performs calculations on values

• A predefined formula that performs a specific calculation

What is the purpose of a function in a spreadsheet?

• To create a chart

• To enter data into a cell

• To perform a specific calculation using a predefined formula

• To sort data

Which of the following is considered data in a spreadsheet?

• A formula

• A chart

• Information that is organized and processed

• A function

What is the primary use of the filter feature in spreadsheets?

• To delete data

• To visually represent data

• To display only the data that meets certain criteria

• To perform calculations