Spreadsheet Basics
Formulas
Money Math
Formatting
Real Life Spreadsheets
100

What is a spreadsheet used for?

What is To organize data and do calculations.

100

What symbol must every formula start with?

What is =

100

What is tax?

What is Extra money added to a purchase by the government.

100

What should you do to your headers?

What is Bold and center them.

100

Name one job that uses spreadsheets.

What is Accountant, business owner, teacher, etc.


200

What is a cell?

What is A box where information is entered.

200

What does this formula do? =C2*D2

What is Multiplies cost and quantity.

200

What is a tip?

What is Extra money given for good service.

200

What font do we use in class?

What is Times New Roman.

200

Why would a store use a spreadsheet?

What is To track money and inventory.

300

Rows go which direction?

What is Across

300

What formula adds numbers together?

What is SUM

300

If something costs $10 and you buy 3, what is the total?

What is $30

300

What makes the table easier to see?

What is Borders.

300

What can a restaurant calculate with spreadsheets?

What is Bills, tax, and tip.

400

Columns go which direction?

What is Up and down.

400

What formula finds the middle value?

What is AVERAGE


400

What is 10% of $50?

What is $5

400

Why is formatting important?

What is It makes spreadsheets organized and easy to read.

400

Why is it helpful to use formulas?

What is They calculate automatically.

500

What is A1 called?

What is A cell

500

What does dragging a formula down do?

what is Copies the formula to other cells.

500

If the total is $100 and tax is 7%, how much tax is added?

What is $7

500

How should money be formatted?

What is $

500

What happens if a formula does not start with = ?

What is It will not calculate.