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.
      3. Enter formula =Now() in cell D2 and format it in current date and time
      4. Type in the following data

      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.