The following exercise has been taken directly from the Excel '97 book to give an indication of what the exercises are like.

  1. Open a new spreadsheet in Excel, and save it calling it holiday.

  2. Enter the worksheet by entering the Heading in A1 and A2, highlight across the D2 and Centre across Selection. (click on the Merge and Center icon)
    • Enter the following data in sequence:
    • Australia: 5000, 550, 650, 300, 200, 100, 2000
    • Singapore: 5000, 950, 780, 450, 350, 150, 1500
    • Hawaii: 5000, 1150, 800, 550, 400, 150, 1100
    • Change the width of Column A so that all the information fits.
    • Using the AutoSum icon, calculate the expenditure in B15, and Fill Right to cells C15 and D15.
    • In B17, calculate the difference between Allowance and Expenditure (=b6-b15).

  3. Ctrl S to do a Fast Save.

  4. Format all numbers to show two decimal places:
    • Highlight the numbers to be formatted
    • Go to Format, Format Cells
    • Choose Format, Cells, Number, 0.00 or click on the Increase Decimal icon twice. (It is the left icon with the zeros in it.)

  5. Change the Page Setup as you did for Spreadsheet 1 (Landscape; Horizontally; Headers and Footers) and print a copy of the spreadsheet.

  6. Save and close the file.