Spreadsheet for a Purpose

What is a spreadsheet used for?

• Drawing pictures

• Organizing data and performing calculations

• Writing letters

• Browsing the internet

Which symbol is used to start a formula in most spreadsheet software?

• #

• !

• =

• \

In a spreadsheet, what does a formula do?

• Adds color to the cells

• Adds graphics to the sheet

• Performs calculations based on cell values

• Arranges text

What function would you use to add up values in a range of cells?

• SUM

• AVG

• MAX

• MIN

Which of the following best describes the term "cell reference"?

• The name of a spreadsheet file

• A function in the spreadsheet

• The address of a cell, like B3 or C5

• A tool used to format cells

Which tool in a spreadsheet allows you to create visual representations of your data?

• Formula tool

• Chart tool

• Sort tool

• Print tool

Imagine you are asked to create a budget for a school event using a spreadsheet. List at least three types of information you would include in your spreadsheet and explain how you would use formulas or functions to calculate total costs.

Evaluate responses using AI:

OFF

If cell A1 contains the value 5 and cell B1 contains the value 3, the formula =A1 * B1 + 2 will result in _______.

Differentiate between rows and columns in a spreadsheet.

Evaluate responses using AI:

OFF

Why would you use conditional formatting in a spreadsheet?

Evaluate responses using AI:

OFF