The following exercise has been taken directly from the Excel '97 book to give an indication of what the exercises are like.
- Open a new spreadsheet in Excel, and save it calling it holiday.
- 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).
- Ctrl S to do a Fast Save.
- 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.)
- Change the Page Setup as you did for Spreadsheet 1 (Landscape; Horizontally; Headers and Footers) and print a copy of the spreadsheet.
- Save and close the file.
|