1. Create the following worksheet with the title Pizza Sales in
A1.
2. Make the title into the center of the first row.
3. Enter formula =Now()
in cell D2 and format it in current date and time
4. Type in the following data
|
|
||||||
|
=now() |
||||||
| Plain | Pepperoni | |||||
| Unit Sale Price |
$3.75
|
$4.75
|
||||
| Unit Material Cost |
$2.50
|
$3.50
|
||||
|
|
|
|
|
|
|
|
| Gregg | Brown |
|
|
|||
| Carol | Young |
|
|
|||
| Jan | Rogers |
|
|
|||
| Mary | Jones |
|
|
|||
| John | Smith |
|
|
|||
|
Total
|
=sum of each column |
|
||||
|
Total Cost
|
=total units * unit cost for plain |
=total units * unit cost for pepperoni |
|
|||
|
Total
Profit
|
|
|||||
5. Calculate the price of plain pizza, price of pepperoni
and total price for Gregg Brown.
(Note: Design it in general. That is,
use the concept of the
absolute
address and the relative address to have a formula).
6. Fill down your formulas for other people.
7. Calculate total price, cost, and profit.
8. Add your name on the left section of footer by the following steps.
Choose View, Header/Footer, Custom Footer, then type your name on left
section.
9. Set up your printing sheet in landscape
form. (Choose File, Page
Setup, Page, Landscape, OK.
10.
Name this sheet as RESULT sheet.
11.
Copy it to the sheet 2, name the sheet as FORMULA and use Ctrl + ~ to show
your formulas.
12.
Save the file as pizza.
13.
Print both sheets.