typing

1. Type the workbook below, set font to Trebuchet MS, 12 pt and save as HAIR.

2. Rename Sheet1 to HAIR1. Make a copy of HAIR1 and rename as HAIR2.

Perform the following in HAIR2.

3. Use a function and insert the date in an appropriate cell.

4. Use functions to calculate the following:

· TOTAL (Hair Cut; Shampoo; Style; Colour; Perm; Treatment);

· AVERAGE (Hair Cut; Shampoo; Style; Colour; Perm; Treatment);

· HIGHEST (Hair Cut; Shampoo; Style; Colour; Perm; Treatment);

· LOWEST (Hair Cut; Shampoo; Style; Colour; Perm; Treatment);

· TOTAL number of stylists;

· TOTAL for each stylist;

· THE OVERALL TOTAL; and

· The PERCENTAGE of the TOTAL for each stylist in relation to the OVERALL TOTAL (Answer should be to one decimal place)

5. Complete the following formatting operations:

· Format all necessary numbers to currency and two decimal places;

· Center the headings across the columns and apply the appropriate cell styles.

6. Save HAIR again.

Exercise: WAGES

1. Create the workbook below, set font to Bookman Old Style, 12 pt and save as WAGES.

2. Rename Sheet1 to WAGES1. Make a copy of WAGES1 and rename as WAGES2.

Perform the following in WAGES2.

3. Use a function and insert the date in cell A3.

4. Use Formula to calculate the following (for each employee):

· Gross Pay {the product of Hours Worked and Rate per Hour}

· Total Deductions {the sum of S.S.T and F.W.T}

· Net Pay (the difference between Gross Pay and Total Deductions}

5. Use functions to calculate the following:

· TOTAL (Gross Pay; S.S.T; F.W.T; Total Deductions);

· AVERAGE (Gross Pay; S.S.T; F.W.T; Total Deductions);

· HIGHEST (Gross Pay; S.S.T; F.W.T; Total Deductions);

· LOWEST (Gross Pay; S.S.T; F.W.T; Total Deductions);

· TOTAL number of Employees;

· THE OVERALL NET PAY; and

· The PERCENTAGE of the NET PAYfor each employee in relation to the OVERALL TOTAL NET PAY(Answer should be to zero decimal places)

6. Complete the following formatting operations:

· Format all necessary numbers to currency and two decimal places;

· Center the headings across the columns and apply the appropriate cell styles.

7. Save WAGES again.