Smart Retail Rental Rental Initiated in Week Starting 7/11/2022 Rental Payment Analysis Average Analysis Analysis Total Tata t of count Fatal Sales Criteria Method Criteria Sales Sales 10 Rewards Rewards 0 Check Check 0 Credit Card Credit Card Cash Cash Sales God 0 Goal Met 341 7/12/2022 Produt Designer handbag Designer handbac Designer handbag Designer handbag Designer handbag Product 10 Date Rented Date Returned/or Expected Return My Rented Payment Method Daly Rate A 743 7/11/2022 744 7/12/2022 745 7/13/2022 746 7/11/2023 Sewards 7/15/2022 7/13/2002 2 Credit Card Cash 7/10/2012 Check 7/19/2022 Credit Card 7/13/2022 2 550 3/13/2022 7/19/2022 Rewards 2 Accesories 551 7/11/2002 7/22/2022 10 Credit Card 3Accessories 552 3/12/2022 7/13/2023 Cald 4 Accessories 553 7/11/2002 7/17/2032 Credit Card 5 Accessories 354 7/12/2022 7/13/2012 2 Cash ms Accessories 55% 7/13/2022 7/13/2012 2 Credit Card 17 Accessories 356 1/15/2022 1/19/2022 Credit Card a 1 Accessories 357 7/11/2022 7/18/2022 Rewards 19 Accessories 558 1/13/2022 7/17/2003 Check 20 Accessories 7/12/2022 7/13/2022 Cash 21 Dresses 7/12/2022 7/15/2012 Credit Card 22 Dresses 929 7/13/2003 7/16/2022 4 23 Desses 990 1/13/2002 7/25/2022 Credit Card 24 Dresses 7/11/2003 7/13/2022 Rewards 25 Dresses 982 1/13/2022 7/15/2022 Check a 26 Dresses 990 7/13/2022 7/15/2022 4 Check 27 Dresses 994 1/15/2022 1/16/2022 1 Card 0 0 28 Gow 356 7/11/2023 Gowns 30 Gowns 276 7/11/2022 7/14/2023 277 7/12/2023 3/18/2003 514 7/25/2022 CreditCard Credit Card Cash 0 11 Gowns 33 Designer Handha $22.00 35 $15.00 $55.00 That for Rewards 20% 22 12 13 Virginia is considering offering specials to clients based on their payment method. Therefore, she wants you to help her analyze the week's payment information so she can determine her clients' preferred method of payment. In cell L6, using a Statistical function, count the number of times the criteria in cell K6 is used. Use absolute referencing where necessary and then copy the formula through cell L9. In cell 06, 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 09. 16 17 18 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. 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 amount, an interest rate of 5.5% with a repayment of the loan after 5 years. On the LoanData worksheet, in cell B6, determine the monthly payment. In cell B6, edit the formula to return an absolute value. 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 15:110 on the RentalData worksheet, create a combination chart with the Total Sales as the secondary axis. The secondary axis should be a line chart. Move the chart to a new chart sheet named HandbagsChart Move the Chart Sheet to the last position (far right). Enter the chart title Handbag Rental Apply Chart Style 5. Add a primary vertical axis label Days Rented Add a secondary vertical axis label Total Sales