Arthur Realty Property Sales for March 2023 \begin{tabular}{|l|l} \hline Author & \\ \hline Report Date & 4/19/23 \\ \hline \end{tabular} Assumptions Commission \% Bonus Days Bonus Amount \begin{tabular}{|r|} \hline 0.09 \\ \hline 20 \\ \hline 7500 \\ \hline \end{tabular} Salesperson List Price Selling Price Commissior Date Listed Date Sold Days on Ma Bonus Total Pay Rating Totals: 10. In cell B35, insert a function that counts the number of houses sold by the agent listed in the adjacent cell in column A. Copy this function down for all the agents listed. NOTE: To receive full credit for this part of the exercise, you must use a function. 11. In cell C35, insert a function that computes the total compensation earned by the agent listed in column A. Copy this function down for all the agents listed. NOTE: To receive full credit for this part of the exercise, you must use a function. CREATE A CHART 12. Create a pie chart depicting each agent's share of total compensation. Each pie segment should contain an agent's name and the percentage of total compensation for that agent. Remove the legend from the chart. Insert Salesperson Compensation Share as the chart title. Reposition and size the chart so that it displays in cell range M4:Q15. 1. If the Commission % was 12%, what would the Total Commissions be? 2. a. If the Bonus days is changed to 60 and the bonus amount is changed to $6,000, what would the Total Bonuses be? b. How many property sales entitled the agent to a bonus? 3. If Rachael Arthur wanted to designate one of her agents as "Agent of the Month," which one would you recommend? Justify your answer based on the sales data in the worksheet. Arthur Realty Property Sales for March 2023 \begin{tabular}{|l|l} \hline Author & \\ \hline Report Date & 4/19/23 \\ \hline \end{tabular} Assumptions Commission \% Bonus Days Bonus Amount \begin{tabular}{|r|} \hline 0.09 \\ \hline 20 \\ \hline 7500 \\ \hline \end{tabular} Salesperson List Price Selling Price Commissior Date Listed Date Sold Days on Ma Bonus Total Pay Rating Totals: 10. In cell B35, insert a function that counts the number of houses sold by the agent listed in the adjacent cell in column A. Copy this function down for all the agents listed. NOTE: To receive full credit for this part of the exercise, you must use a function. 11. In cell C35, insert a function that computes the total compensation earned by the agent listed in column A. Copy this function down for all the agents listed. NOTE: To receive full credit for this part of the exercise, you must use a function. CREATE A CHART 12. Create a pie chart depicting each agent's share of total compensation. Each pie segment should contain an agent's name and the percentage of total compensation for that agent. Remove the legend from the chart. Insert Salesperson Compensation Share as the chart title. Reposition and size the chart so that it displays in cell range M4:Q15. 1. If the Commission % was 12%, what would the Total Commissions be? 2. a. If the Bonus days is changed to 60 and the bonus amount is changed to $6,000, what would the Total Bonuses be? b. How many property sales entitled the agent to a bonus? 3. If Rachael Arthur wanted to designate one of her agents as "Agent of the Month," which one would you recommend? Justify your answer based on the sales data in the worksheet