In cell F2, calculate the average sales revenue in the dataset B12:D23

In cell F2, calculate the average sales revenue in the dataset B12:D23.
In cell F3, calculate the average revenue in February, for Zurnba classes.
In cell F4, find the number of times revenue is above average.
In cell F5, find the minimum revenue in January, for Aerobics classes.
In cell F6, find the maximum revenue in March, for Pilates classes.
In cell F7, calculate total revenue in January and March, for Sports Conditioning Classes.

Need Help with your homework/Assignment? Don’t Be Shy To Ask for help by Clicking this Link.

Apply the following conditional formatting in the dataset range B12:D23: 

a- Format any revenue value below average, in red font. 
b- Format any revenue value above average in green font. 
c- Highlight any revenue between 370 and E 600 in light yellow.

 Format, where applicable, the numbers in cells F2 through F7 to show E (currency format)

Contact us now to get custom essays written for you in less than 12 hours