Calc 2.0 In Pictures

Practice: Manipulating Data

  1. Right-click this link (Mac users, press the CTRL key while pressing the mouse button.):

    StationeryShop.xls

    When the menu appears, click Save Link Target As.
  2. Save StationeryShop.xls in the Practice Calc Files folder on your computer.
  3. Open StationeryShop.xls.
  4. In the Per Ream Revenue worksheet, insert new blank rows above:

    Cost of Goods Sold
    Gross Revenue
    Commissions/Fees
    Net Revenue
  5. Change the name of Sheet2 to Ream Sales.
  6. In the Ream Sales sheet, insert a new column for April between the March and May columns.
  7. Copy the Reams shipped and Reams sold in store sales figures for March and paste them in for April.