Independent Challenge $1($continued$)$ if the procedure amount is greater thent, and the Value$\_$ if$\_$false should be amount minus the insurance payment, and $F6$:$F11.$

f$.$ Copy the IF function in cell F$5$ to the rang accounts that are past due. Accounts are past due if a patient is

g$.$ In cell G$5,$ enter an AND function to statement age is over $30$ days. $($Hint: The Logical$1$ condition should cho responsible for a balance due and the $30,$ and the Logical $2$ condition should check if the patient responsibility see if the statement age is more than $3.$ greater than $0.)$

h$.$ Use the fill handle to copy the AND function in cell GS into the of accounts in column A$.$

i$.$ In cell B$13,$ enter a COUNTA function to calculate the amounts in column D$.$

j$.$ Enter a function in cell B$14$ that averages the procedure average in cell B$14$ to zero decimal places.

k$.$ Use Formula AutoComplete to enter a function footer.

Enter your name in the center section of the fompare your screen to FIGURE $3-19.$

m$.$ Preview the worksheet in Backstage view. Compa your instructor as directed.

n$.$ Save your work, then submit the worksheet to your instructor as directed.

o$.$ Close the workbook and Excel.

FIGURE $3-19$

NE Imaging Boston Patient Accounts