PLEASE TYPE FORMULA FOR EXCEL only need 6-10

1. How many songs were not sung by Mellencamp (do not do a subtraction formula)?
2. How many songs were played before June 15, 2020?
3. How many songs were played between May 1, 2020 and July 4, 2021?
4. How many songs were sung by singers whose last names begin with E?
5. How many songs were sung by singers whose names contain an s?
6. Create a formula that always yields the number of songs played today (use a function where the date changes daily).
7. For the cell range A2:D100, count the cells containing a numeric value. Count the number of blank cells. Count the number of nonblank cells.
8. How many songs sung by Eminem were played in 2021?
9. How many songs at least four minutes long and sung by Bruce Springsteen were played in 2020 or earlier?
10. How many songs that are exactly three minutes long and sung by Madonna were played later than (after) 2020?

A F G H | J K L M N 0 R S 1 2 3 B 1) How many songs were not sung by Mellencamp? (5 Points) 2) How many songs were sung before June 15, 2014? (5 Points) 3) How many songs were sung between June 1, 2014 and July 4, 2016? (5 Points) 4) How many songs were sung by singers whose last name begins with L? (5 Points) 5) How many songs were sung by singers whose names contain an "o"? (5 Points) 25 Points Total 5 9 Problem USE NAMED RANGES! 10 10 1 Not by Mellencamp 11 11 2 Before June 15, 2014 12 12 3 Between June 1.2014 and July 4, 2016 12 13 4 Name starts with L 14 14 5 Name contains the letter o 15 15 16 17 1 18 ALL PROBLEM ARE "COUNTS 19 20 21 8122015 4 11 Logic 12 Imagine Dragons 20 10423/2015 Song Numb. Singer PlayDate Minutes 1 Imagine Dragons 10/16/2014 4 2 Imagine Dragon: 9/10/2014 2 3 Lady Gaga 6/25/2015 0 4 Imagine Dragon: 6/25/2015 4 5 Kesha 4/2/2015 2 4 6 Lady Gaga 2/13/2015 4 4 7 Post Malone 910/2014 3 3 8 Post Malone 3 oros 9 Nikki Minaj 6/13/2015 4 2015 10 Imagine Dragons 95/2015 CON 7/12/2014 3 GO! 6/8/2014 GCA 13 Springsteen 95/2015 2 OSO 14 Post Malone 9/10/2014 4 15 Kesha 123/2014 3 16 Logic 11212014 4 17 Post Malone 3 os 18 Mellencamp 12/22/2015 5 10 LALO 19 Post Malone 2013/2015 5 1912010 20 123/2014 4 SO 21 Springsteen 272015 3 601 22 Logic 10/28/2014 3 20450 23 Logic 71312015 3 24 Lady Gaga CCS 618/2014 5 25 Lady Gaga 12/22/2015 2 26 Lady Gaga 71712015 5 27 Imagine Dragons 115/2016 3 28 Springsteen 174/2015 3 2 5 12/10/2015 29 Logic 5 30 Nikki i Minaj 8/12/2015 9 31 Lady 10/28/2014 5 3 32 Imagine Dragons 12/10/2015 5 33 Springsteen 174/2015 4 34 Post Malone 12/10/2015 3 35 Nikki Minaj 95/2015 3 36 Kecha 1014/2014 31 54 Logic 35 36 37 38 29 39 an 40 41 41 42 44 43 Gaga 44 45 46 47