13 In cell O6, using a Statistical function, determine the average total sales based on the

payment method type in cell N6. Use absolute referencing where necessary and then copy the

formula through cells O9.

14 In cell P6, using a Math & Trig function, determine the total sale per payment method based

on the payment method in cell N6. Use absolute referencing and then copy the formula

through cell P9.

Apply a Gradient Fill Orange Data Bar to P6:P9.

15 Virginia wants to determine if the sales goal for the week was met. The sales goal for the week

is met if the total sales is greater than or equal to $3,000.

In cell L13, enter a logical function to determine if the sales goal for the week was met. Return

a value of Yes if the sales goal was met, or No if the sales goal was not met.

16 When Virginia started gathering client data, she entered her clients' names in all capital letters

and in column A. She has asked you to change the names of each client to proper case.

On the Clients worksheet, in cell B2, use a text function to change the text in cell A2 to proper

case. Copy the formula through cell B26.

17 Virginia is considering taking out a loan to purchase more products to rent to customers. In

order to purchase the products she needs, she has determined that she needs to borrow

$10,000. She would like you to help her determine her monthly payment based on the loan

n the LoanData worksheet, in cell B6, determine the monthly payment.

In cell B6, edit the formula to return an absolute value.

18 Virginia is curious about her handbag line of rentals. She has asked you to create a

combination chart that shows the days rented and the total sales

Using cell ranges A5:A10, E5:E10, and I5:I10 on the RentalData worksheet, create a

combination chart with the Total Sales as the secondary axis. The secondary axis should be

combination chart with the Total Sales as the secondary axis. The secondary axis should be a line chart