In cell Q$6,$ enter a formula to determine the average total cost based on the payment method type in cell P$6.$ Use absolute references where necessary to copy the formula through cell Q$9.$

In cell R$6,$ enter a formula to calculate the total cost per payment method based on the payment method in cell P$6.$ Use absolute references where necessary so that you can copy the formula through cell R$9.$

On the ClientData worksheet, in cell $B2,$ enter a formula to change the client's name to proper case. Copy the formula through cell B$26.$

Insert the File Name code in the left footer section of all worksheets in the workbook.

Save and close Excel$\_$Ch$03\_$Assessment$\_$CarRental.xIsx. Exit Excel. Submit the file as