Pizza Spreadsheet Series |

Most of you remember this exercise from the middle school, then again you may not. This exercise requires that we make a simple but effective spread sheet that will assist you in understanding that mastering functions. This spread sheet will require that you:

- Read the
six Microsoft
Excel Modules and write a paragraph on each
module
**Excel Worksheet Basics. They are;** - Basic terminology
- Entering and Editing Data
- Using automatic features
- Using Functions
- Using Equations
- Calculating Percent and Using Ablolute Cell Reference
- Learn the Basic Terminology , such as Cells, Rows and Columns.
- Prepare a simple spreadsheet. See below.

The paragraph(s) are to be put into a Spreadsheet Journal. No more than two paragraphs each- No less than one paragraph. You may use examples within the paragraph, provided that it is not the only thing you have in the paragraphs. Clarify? ask the teacher

Spreadsheet will have:

- 10 different Pizzas listed
- Items identified as listed below
- Prices for each item in each cell
- Items will total to the right for each place
- Items will total right bottom/ Tax indicated
- Grand Total
- If the
price is changed on a product - the change will update the total 1,
total 2, tax amount, and grand total

Pizza

Size | Added
Item Cost @ $1.25 |
Price | Salad Size |
Drink | Total 1 |

$9.57 | 3 |
$13.32 | $6.98 | $4.01 | |

" | |||||

" | |||||

" | |||||

" |

First Sum total | Total 2 |

tax rate * sum total | Tax (Rate 3.746%) |

SUM First + tax rate | Grand Total |

Check your Quia Page for due date!