Please show formulas and/or functions. Thank you.

A B C D E F G H 1 K L M N o 1 15 pts. 2 3 4 Build a model that determines the counts based on the song list below. Assume that no songs will be added or deleted from the list but the data about the songs may change and the counts should update in response to these changes. 5 0 6 7 No need to add anything - can be done with one conditional function No need to add anything - can be done with one conditional function 8 Count of songs not by Spears or Madonna: Count of songs between 5 and 6 minutes: Count of songs played on Tuesdays: Count of rows with singer names that contain letter "m": How many times was Spears played in Aug. 2017? How many times was Moore played in between Feb. 2018 and Aug. 2019? Use special characters 9 10 11 12 13 14 15 16 Song Number Singer 1 Eminem 2 Eminem 3 Cher 17 18 4 Eminem 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 5 Moore 6 Cher 7 Spears 8 Spears 9 Manilow 10 Eminem 11 Madonna 12 Eminem 13 Springsteen 14 Spears 15 Moore 16 Madonna 17 Spears 18 Mellencamp 19 Spears 20 Madonna Date Minutes 6/21/2018) 2 5/15/2018 2 2/28/2019 2 2/28/2019 3 12/5/2018 6 10/18/2018 2 5/15/2018 5 4/17/2019 4 2/16/2019 4 5/10/2019 6 3/15/2018 2 2/10/2018 6 5/10/2019 3 5/15/2018 5 8/8/2018 4 7/26/2018 6 6/28/2019 5 8/27/2019 3 10/18/2018 4 8/8/2018 2 2