Hello. I need help with some homework excel formulas please!

1. On the RevenueReport worksheet, add a COUNTIF function in cell E15 to count the number of Loyalty program members (Yes) using the Loyalty named range. In cell E16, create formula to indicate if the loyalty goal (E14) has been met by the quantity (E15). The cell should display Goal Met if the goal has been met or Under Goal if not met.
2. On the RevenueReport worksheet, add a COUNTIFS function in cell F5 to count the number of coupons used by each category in the morning (E3) shift. You need to use the Shift and Coupon_Num ranges. Copy/paste the formula to F6:F7.
3. On the RevenueReport worksheet, add an AVERAGEIF function in cell B9 to determine the average sale for the customer listed in cell B8. You should use the Cust_Cat and Line_Item_Total ranges in the formul
4. On the RevenueReport worksheet,EE add an AVERAGEIFS function in cell B10 to determine the average sale for the customer listed in cell B8 by pay type. Extend the formula in B10 to B11 using the same customer type and the payment type in A11.