I have already done the other parts only do these questions in excel please : 6.With the
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66626bd394ebf_16366626bd365393.jpg)
I have already done the other parts only do these questions in excel please : 6.With the range E5K16 selected, use Quick Analysis tools to calculate the total regular pay, overtime pay, gross pay, taxable pay, withholding tax, FICA,and net pay on row 17.7.Apply Accounting Number Format to the range C5:C16. Apply Accounting Number Format to the first row of monetary data and to the total row.Apply the Comma style to the monetary values for the other employees. Apply the Total cell styles format to the range E17:K17.8. Insert appropriate functions to calculate the average, highest, and lowest values in the Summary Statistics area (the range 121:K23) of 8 the worksheet. Format the # of hours calculations as Number format with one decimal and the remaining calculations with Accounting number format.9.Insert a footer with your name on the g left side, the sheet name code in the center, and the file name code on the right side of the worksheet.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66626bd4177a2_16366626bd3d3de0.jpg)