Help me understand Task C and Task D!! Thank You!

1 A B C D E G H K Centrai corporation nas six sales peopie. Ine rollowing sales results py quarter 2 for the year are given below: 3 4 5 Quarter 1 Total 6 Salesperson \begin{tabular}{|l|l|l|l|} \hline TRUE & TRUE & & \\ \hline FALSE & TRUE & & \\ \hline FALSE & TRUE & & \\ \hline FALSE & TRUE & & \\ \hline TRUE & TRUE & & \\ \hline FALSE & FALSE & & \\ \hline \end{tabular} Instructions: Perform the following tasks using Excel's logical functions. Task A 19 Identify the sales people who had sales greater than $70,000 in all four quarters of 20 the year. Use the AND function. 21 22 Task B 23 Identify the sales people who had sales greater than $70,000 in at least one quarter 24 during the year. Use the OR function. 25 26 Task C 27 Any sales person who had average quarterly sales greater than $72,000 are entitled to 28 a 10% bonus on their average quarterly sales. Compute the bonus for those sales 29 people entitled to the bonus. The result for those not entitled to the bonus should be 30 a zero. Use the IF function. 31 32 Task D 33 Any sales person who had average quarterly sales of at least $80,000 qualifies for a 12% 34 commission on average quarterly sales. Any sales person who does not have 35 average quarterly sales of at least $80,000 can still qualify for a 5% commission 36 on their average quarterly sales in one of two ways: (1) if the sales person had sales 37 quarterly sales greater than $70,000 and sales in at least one quarter of the year 38 greater than $72,000. Compute the commission for those sales 39 people entitied to the bonus. The result for those not entitled to the bonus should be 40 a zero. Use nested functions of your choice