mulas: Write the formula once and copy it down remaining rows as needed making proper use of

relative versus absolute cell addresses. Do not use literal values for rates in formulas but refer to hourly

rates stored in B$10$:B$11.$

a$.$ In cell D$4$ write the formula to compute the daytime charges as the daytime hourly rate stored in B$10$

times the number of daytime hours. Be sure to use an absolute address for $B$$10$ so it stays fixed.

b$.$ In cell F$4$ write the formula to compute the evening charges as evening hourly rate stored in B$11$

times the number of evening hours. Be sure to use an absolute address for $B$$11$ so it stays fixed.

c$.$ In cell G$4$ compute total charge for the customer by adding the daytime and evening charges.

d$.$ Compute the grand total of all customer charges in cell G$9.$

Formats:

a$.$ Merge and center the title in A$1$ across columns A $$ G$.$ Enlarge the font size to $22$pt and add a

background fill color. Enlarge the row height and vertically center the text.

b$.$ Apply boldfacing, horizontal centering and a bottom border to range A$3$:G$3.$

c$.$ Add boldfacing, font color change and an outside border to cell F$9.$

d$.$ Use the Increase Decimal option on range C$4$:C$8$ and E$4$:E$8$ so hours appear with one

decimal point.

e$.$ Apply Accounting or Currency format to all monetary values.

f$.$ Insert a new blank row in row $3.$ The column headings should now appear in row $4.$

g$.$ Right$-$click the sheet tab and rename the sheet Part$-$time Job.