${?}^1$ Listed score may not reflect your final grade.

NOTICE The image below is NOT the file you submitted. This is a representation of the solution file.

$4$ The dates are missing from the timesheet. Enter the date $\frac{8}{1}\frac{?}{2022}$ in cell B$18.$

$5$ Use AutoFill to complete the dates in cells $C18$:$H18.$

$6$ Change the date format for $B18$:$H18$ to the date format similar to $14-$Mar.

$8$ Use the Quick Analysis tool to enter total hours for each day. Use the cell range B$19$:H$22.$

The daily totals should be inserted into the range $823$:$H23.$

$9$ Format the hours billed section $($cells B$19$:H$23)$ to use the Comma Style number format.

Be sure to include the total row.

$10$ Enter a formula in cell B$25$ to calculate the daily bill for Monday, August $1.$ The formula

should calculate the total billable hours for the day $($cell B$23)$ times the billable rate $($B$4).$

Be sure to use an absolute cell reference for the billable rate.

$11$ Use AutoFill to copy the formula to the remaining days in the timesheet $($cells $C25$:$H25).$

$12$ Calculate the bill total for the week by summing the daily bill amounts. In cell B$26,$ enter a

$\frac{0}{1}$

formula using the SUM function. The function argument should be the range of cells

representing the daily bill totals $(B25$:$H25.$

$13$ Apply the Currency number format to cells B$25$:H$25$ and cell B$26.$

$14$ Use the Recommended Charts feature to insert a line chart representing hours works for

each day for the week of August $1.$ Select cells A$18$:H$22$ for the chart data.

${?}^1$ Listed score may not reflect your final grade.

$70F$

Mostly sunny