Find the following using countif, countifs, sumif, sumifs, averageif, and averageifs. Create all formulas and calculations directing in Excel.

Which singer has Disco Boy played most often?

Out of the songs that Nancy has played, which performers songs have the highest average rating?

How many songs that are not LPs have been played more than 4,000 times?

Of the songs that have been played more than 4,000 times, what is the average rating of a Springsteen CD last longer than 3 minutes?

How many songs have a length of over 4 minutes and are sung by a performer whose name starts with an s?

What is the average song length of CDs with a rating of 3 or higher between 4/1/04 and 9/30/04 (exclusive).

A B C D E K M N 0 Exercise 3 A B C D E K M N 0 Exercise 3