$$ Insert an IF function in cell K$5$ to calculate the amount billed. If the hours logged is less than or equal to $10($cell O$12),$ multiply the rate by the hours worked. Otherwise multiply the rate by the hours worked and add a $$100$ premium $($cell O$13)$ to the bill. Copy the function from cell K$5$ to the range K$6$:K$36.$

$$ Insert a function in cell O$5$ to calculate the total hours logged in column J$.$

$$ Insert a function in cell O$6$ to calculate the total amount billed in column K$.$

$$ Insert a function in cell O$7$ to calculate the average days required to complete a service request $($column I$).$

$$ Insert a function in cell O$8$ to calculate the fewest days open in column I.

$$ Insert a function in cell O$9$ to calculate the most days open in column I.

$$ Insert a function in cell E$2$ to add the current date and time to the worksheet.

$$ Insert a footer with your name on the left side, the sheet name in the center, and the file name code on the right side of the worksheet. Return to Normal view.

$$ Save and close the workbook. Based on your instructor$$s directions, submit e$02$r$1$NCCTS$\_$LastFir