In cell q6, enter a formula to determine the average total cost based on the payment method type in cell p6. use absolute references where necessary to copy the formula through cell q9.