Rock Concert Example

1. Write a formula in cell G2, which can be copied down the column, to determine the Total Revenue for this group. 

      Revenue = Revenue from concert + Revenue from CD sales.

=C2*D2+E2*F2

2. Write a formula in cell G9 to calculate the total revenues from all groups.

=SUM(G2:G8)

3. Write a formula in cell G10 to calculate the average revenue from all groups.

=AVERAGE(G2:G8)

4. Write a formula in cell G12 to determine the number of people who attended the concert with the highest attendance.
   
   

=MAX(C2:C8)

5. Write a formula in cell G13 to determine the total revenue rounded to the nearest $100.

=ROUND(G9,-2)

6. Write a formula in cell G14 to determine the number of people attending a concert rounded to the nearest whole number.
   
   

=ROUND(AVERAGE(C2:C8),0)

7. Write a formula in cell G15 to determine the cost per CD of the cheapest CD sold.
   
   

=MIN(F2:F8)

8. Write a formula in cell G16 to determine how many groups sold less than 20,000 CDs that year.
   
   

=COUNTIF(E2:E8, "< 20000")

9. Write a formula in cell G17 to determine how many groups charged $40 for their concert tickets.
   
   

=COUNTIF(D2:D8, 40)

10. Write a formula in cell G18 to determine the total revenue for all groups with a Type A contract.
    
    

=SUMIF(B2:B8, "A",G2:G8)

11. Write a formula in cell H2, which can be copied down the column, to determine this group’s revenue as a percent of the total revenue for all groups.
    
    

=G2/G$9