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.

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

Differentiate between rows and columns in a spreadsheet.

Why would you use conditional formatting in a spreadsheet?