ASSIGNMENT N° 4

CASE 4 E1.34 – Krier Marine Services

Follow instructions on the book (Text 2), except for:

Step 2 – Save the report using the number e134. Your name is no longer needed.

Step 3e – Calculate the average of hours worked and the average pay.

Step 3f – Change the font of the whole worksheet. You can choose any font you like, as long as it is not Arial 10.

Step 3g – Format the columns the following way (starting on row 5):

A.    Centered – width: at least 17pts.
B.    Centered – width: at least 12pts - numbers: no decimals.
C.    General – width: at least 12pts - numbers: accounting format, with $ sign and 2 decimals.
D.    General – width: at least 12pts - numbers: accounting format, with $ sign and 2 decimals.

Step 3i – Center rows 1 & 2 accross active columns (i.e., A through

Step 5 – Do not submit a print copy.

Step 6 – Do not remove the hours for the four employees. Instead, make a duplicate of the worksheet, which you will name "Second Payroll". (Hint: the menu that appears when you right click on a worksheet name).

Step 8 – Do not sumbit a print copy.

Step 9 – Format the pages so that:

a)    The contents of the page appear horizontally centered.
b)    The header or footer contain at least:

• the name of this course;
• the date (any format);
• the page number (any format);
• the number of this assignment.

Step 11 – Email the URL of your assignment (see Assignment Drop Box).