Andre has set a revenue goal of $20,000 for January, February, and April, when the organization has no fundraisers, and a revenue goal of $200,000 for March and May, when the organization does have fundraisers. 13. In cell B10, enter a formula using the IF and AND functions to indicate whether the revenue goal has been met that month: a. Enter the logical test using the AND function to determine if the Fundraisers amount in cell B7 equals 0 and the Total in cell B8 is greater than 20000. b. If the logical test is true, display Yes (using "Yes" for the value if_ true argument). c. Ifthe logical test is false, insert a nested IF function. d. Enter the logical test of the nested IF function using the AND function to determine if the Fundraisers amount in cell B7 is greater than 0 and the Total in cell B8 is greater than 200000 e. If the logical test for the nested IF function is true, display Yes (using f. If the logical test is false, display No (using "No" for the value_if_false Copy the formula in cell B10 to the range Ci0:F10 "Yes" for the value_if_true argument). argument). Andre has set a revenue goal of $20,000 for January, February, and April, when the organization has no fundraisers, and a revenue goal of $200,000 for March and May, when the organization does have fundraisers. 13. In cell B10, enter a formula using the IF and AND functions to indicate whether the revenue goal has been met that month: a. Enter the logical test using the AND function to determine if the Fundraisers amount in cell B7 equals 0 and the Total in cell B8 is greater than 20000. b. If the logical test is true, display Yes (using "Yes" for the value if_ true argument). c. Ifthe logical test is false, insert a nested IF function. d. Enter the logical test of the nested IF function using the AND function to determine if the Fundraisers amount in cell B7 is greater than 0 and the Total in cell B8 is greater than 200000 e. If the logical test for the nested IF function is true, display Yes (using f. If the logical test is false, display No (using "No" for the value_if_false Copy the formula in cell B10 to the range Ci0:F10 "Yes" for the value_if_true argument). argument)