Pizza

Exercise of Absolute Address in Spreadsheet

      1. Create the following worksheet with the title Pizza Sales in A1.
      2. Make the title into the center of the first row by the following steps:
                    a. Highlight cells from A1 to G1.
                    b. Right click on Pizza Sales to get menu.
                    c. Choose Format Cells.
                    d. Choose Alignment.
                    e. Choose Center Across Selection.
      3. Enter formula =Now() in cell D2 and format it in current date and time
      4. Type in the following data

*Pizza Sales*
			=now()
	Plain	Pepperoni
Unit Price	$3.75	$4.75
Unit Cost	$2.50	$3.50
First Name	Last Name	Number of Plain	Price of Plain	Number of Pepperoni	Price of Pepperoni	Total Price
Gregg	Brown	4		10
Carol	Young	7		11
Jan	Rogers	20		5
Mary	Jones	18		10
John	Smith	2		25
	Total Price:
	Total Cost:		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.
                Insert a row between John Smith and Total Price: then type your name.
          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. SHOW ME