PLS. Help me understand how to use the formula's for excel!!!! Thank YOU!

Central Corporation has six sales people. The following sales results by quarter for the year are given below: \begin{tabular}{|c|c|c|c|} \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline Task A & Task B & Task C & Task D \\ \hline & & & \\ \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 Identify the sales people who had sales greater than $70,000 in all four quarters of the year. Use the AND function. Task B Identify the sales people who had sales greater than $70,000 in at least one quarter during the year. Use the OR function. Task C Any sales person who had average quarterly sales greater than $72,000 are entitled to a 10% bonus on their average quarterly sales. Compute the bonus for those sales people entitled to the bonus. The result for those not entitled to the bonus should be a zero. Use the If function. Task D Any sales person who had average quarterly sales of at least $80,000 qualifies for a 12% commission on average quarterly sales. Any sales person who does not have average quarterly sales of at least $80,000 can still qualify for a 5% commission on their average quarterly sales in one of two ways: (1) if the sales person had sales quarterly sales greater than $70,000 and sales in at least one quarter of the year greater than $72,000. Compute the commission for those sales people entitied to the bonus. The result for those not entitled to the bonus should be a zero. Use nested functions of your choice