PLEASE SHOW ALL FORMULAS USING EXCEL TO SOLVE THIS PROBLEM

J - K L M N O 0 R S 1 A B C D E F G H 1) How many songs were not sung by Mellencamp? (5 Points) 2 2) How many songs were sung before June 15, 2014? (5 Points) 3 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) 4 5) How many songs were sung by singers whose names contain an "o"? (5 Points) 5 6 25 Points Total 7 8 9 Problem USE NAMED RANGES! 10 1 Not by Mellencamp 11 2 Before June 15, 2014 Song Numb. Singer PlayDate Minutes 12 3 Between June 1,2014 and July 4, 2016 1 Imagine Dragons 10/18/2014 4 13 4 Name starts with L 2 Imagine Dragon: 9/10/2014 2 14 5 Name contains the letter o 3 Lady Gaga 6/25/2015 2 15 0 4 Imagine Dragon: 6/25/2015 4 16 5 Kesha 4/2/2015 2 17 6 Lady Gaga 2/13/2015 4 18 ALL PROBLEM ARE "COUNTS- 7 Post Malone 9/10/2014 19 8 Post Malone 8/12/2015 3 20 9 Nikki Minaj 6/13/2015 4 21 10 Imagine Dragon: 95/2015 4 22 11 Logic 7/12/2014 3 23 12 Imagine Dragons 66/2014 4 24 13 Springsteen 95/2015 2 25 14 Post Malone 9/10/2014 4 26 15 Kesha 123/2014 3 27 16 Logic 11212014 4 28 17 Post Malone 10/23/2015 3 29 18 Mellencamp 12/22/2015 5 30 19 Post Malone 2/13/2015 5 31 20 Logic 12/3/2014 4 32 21 Springsteen 272015 3 33 22 Logic 10/28/2014 3 34 23 Logic 7/312015 3 35 24 Lady Gaga 6/6/2014 5 36 25 Lady Gaga 12/22/2015 2 37 26 Lady Gaga 71712015 5 38 27 Imagine Dragons 115/2016 3 39 28 Springsteen 114/2015 3 40 29 Logic 12/10/2015 5 41 30 Nikki Minaj 8/12/2015 4 42 31 Lady Gaga 10/28/2014 5 43 32 Imagine Dragon: 12/10/2015 5 44 33 Springsteen 174/2015 4 45 34 Post Malone 12/10/2015 3 46 35 Nikki Minaj 95/2015 3 47 36 Kesha 1014/2014 5