Complete the following tasks on the Rental Report worksheet: 7. In the Rental Totals range, determine the number of rentals for 6-months and 12-months in C5:C6. Determine the total rental revenue for 6-months and 12-months in D5:D6. Determine the average rental revenue for 6-months and 12 months in E5:E6. 8. Determine the total number of rentals, total rental revenue, and overall average rental revenue in C7:E7. 9. In the Furniture Group with Insurance range, use functions to determine the number of rentals of each group code in C11:C15. Determine the total cost of sales for rentals with insurance for each group code in D11:D15. Determine the average insurance charge for each group code in E11:E15. 10. In the Furniture Groups by Purchase Month range, use functions to determine the number of rental purchases of each group code per month in C19:E23. 11. In the Furniture Purchases range, use functions or formulas to determine number of each furniture piece rented in C27:C35. Determine the total sales of each furniture piece type rented in D27:D35. Determine the percentage of total rental sales for each furniture piece type in E27:E35. 12. Determine the total number of rentals and total rental revenue in C36:D36. \begin{tabular}{|l|r|r|r|r|r|} \hline \multicolumn{5}{|c|}{ Rental Totals } \\ \hline Rentals & \#Rentals & Total Rental \$ & Average Rental \$ \\ \hline 6-months & 33 & $ & 13,825 & $ & 215 \\ \hline 12 -months & 7 & $ & 3,275 & $ & 215 \\ \hline Total & 40 & $ & 17,100 & $ & 429 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline \multicolumn{3}{|c|}{ Furniture Purchases } \\ \hline Furniture Piece & \#Sold & Rental \$ & \% of Total Rental S \\ \hline BR-King & & & \\ \hline BR-Queen & & & \\ \hline BR-Twin & & & \\ \hline DR-Table/4 & & & \\ \hline DR-Table/8 & & & \\ \hline GR-Pool/Darts & & & \\ \hline GR-Electronic & & & \\ \hline LR-3pc & & \\ \hline LR-3pct & & & \\ \hline Total & & \\ \hline \end{tabular} Complete the following tasks on the Rental Report worksheet: 7. In the Rental Totals range, determine the number of rentals for 6-months and 12-months in C5:C6. Determine the total rental revenue for 6-months and 12-months in D5:D6. Determine the average rental revenue for 6-months and 12 months in E5:E6. 8. Determine the total number of rentals, total rental revenue, and overall average rental revenue in C7:E7. 9. In the Furniture Group with Insurance range, use functions to determine the number of rentals of each group code in C11:C15. Determine the total cost of sales for rentals with insurance for each group code in D11:D15. Determine the average insurance charge for each group code in E11:E15. 10. In the Furniture Groups by Purchase Month range, use functions to determine the number of rental purchases of each group code per month in C19:E23. 11. In the Furniture Purchases range, use functions or formulas to determine number of each furniture piece rented in C27:C35. Determine the total sales of each furniture piece type rented in D27:D35. Determine the percentage of total rental sales for each furniture piece type in E27:E35. 12. Determine the total number of rentals and total rental revenue in C36:D36. \begin{tabular}{|l|r|r|r|r|r|} \hline \multicolumn{5}{|c|}{ Rental Totals } \\ \hline Rentals & \#Rentals & Total Rental \$ & Average Rental \$ \\ \hline 6-months & 33 & $ & 13,825 & $ & 215 \\ \hline 12 -months & 7 & $ & 3,275 & $ & 215 \\ \hline Total & 40 & $ & 17,100 & $ & 429 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline \multicolumn{3}{|c|}{ Furniture Purchases } \\ \hline Furniture Piece & \#Sold & Rental \$ & \% of Total Rental S \\ \hline BR-King & & & \\ \hline BR-Queen & & & \\ \hline BR-Twin & & & \\ \hline DR-Table/4 & & & \\ \hline DR-Table/8 & & & \\ \hline GR-Pool/Darts & & & \\ \hline GR-Electronic & & & \\ \hline LR-3pc & & \\ \hline LR-3pct & & & \\ \hline Total & & \\ \hline \end{tabular}