Music Worksheet Sorting and Filtering Assignment
Directions:
- Open this worksheet: Music.xlsx
- Open a blank MS Word and save this a "Last First B5 Music Sort Answers"
- You will record your answers in the MS Word file.
- Make sure all your spelling, capitalization, and spacing are exactly correct.
- Copy and paste your answers to make sure they are exactly right.
- All number answers will be numeric ( 2 is right ... NOT TWO)
- When you have ALL your answers, copy and paste them into THIS Google document.
- Make sure your spelling is exactly perfect.
- Mistakes are ..... not going to help your grade, so don't make them.
Your questions:
- How many rows are in b05_music.xlsx?
- How many columns are in b05_music.xlsx?
- Who composed the Slowly Going The Way Of The Buffalo album?
- According to the database table, how many artists is Billy Corgan associated with?
- Who sings She's Got It?
- Which artist is at the top of the list descending order?
- Yan composed for what band?
- What is the time on the song Been It?
- What is the highest bit rate?
- Who is the only "Jazz/Soul" artist in the Music Table?
- Which song has a size of 7752131?
- What is the year for the shortest song?
- What is the name of the longest song?
- Cornflake Girl is what genre of music?
- What band has the most 320 bit rate songs?
- How rows have the phrase “Greatest Hits” in the album?
- How many Beatle songs are in the database?
- How many 1961 songs have a 192 bit rate?
- How many records have no year data?
- How many albums do the The Groovie Ghoulies have?
- What song has the largest time of all the Ska songs?
- Which artist has the Classic Rock song with the largest size?
- What is the 3rd longest Beatles song?
- Which artist has the longest Rap/Hip-Hop song?
- How many bands share the same year and genre as The La’s?
- What is the shortest 2005 rock song?
- What 1970 Motown song is not funny?
- The song with the largest size shares the same genre as what 1995 album?
- Long Tall Sally is a song that shares the same genre as what Tina Turner song?
- The New Order Best of album is composed by?
- Kriss Smith is a friend of mine. What is his longest song?
- Enrique Iglesias and Chad Kroeger individual songs with the same name. What's the song's name?