Basic Spreadsheets EX 4


	Basic Spreadsheets EX 4

Basic Spreadsheet Concepts Exercise 4

Type in the following spreadsheet, and format it to look like the sample below.

Instructions

1) Type in all text and numbers shown in the spreadsheet below.

2) Format all numbers with appropriate format's).

3) Center the spreadsheet heading 'Travel Expenses For The Month Of May' across the spreadsheet.

4) Format all text as displayed in the sample below, including the rotated text labels.

5) Create formula's to display a total for each Sales Rep.

6) Create formula's to calculate the amount due to each sales rep, on the basis that each rep is reimbursed 0.63 cents per kilometer traveled.

7) Apply all borders and shading (colour) shown in the sample below, feel free to experiment with your own colour schemes.