Music Worksheet Sorting and Filtering Assignment

Directions:

  1. Open this worksheet: Music.xlsx
  2. Open a blank MS Word and save this a "Last First B5 Music Sort Answers"
  3. 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)
  4. 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:

  1. How many rows are in b05_music.xlsx?
  2. How many columns are in b05_music.xlsx?
  3. Who composed the Slowly Going The Way Of The Buffalo album?
  4. According to the database table, how many artists is Billy Corgan associated with?
  5. Who sings She's Got It?
  6. Which artist is at the top of the list descending order?
  7. Yan composed for what band?
  8. What is the time on the song Been It?
  9. What is the highest bit rate?
  10. Who is the only "Jazz/Soul" artist in the Music Table?
  11. Which song has a size of 7752131?
  12. What is the year for the shortest song?
  13. What is the name of the longest song?
  14. Cornflake Girl is what genre of music?
  15. What band has the most 320 bit rate songs?
  16. How rows have the phrase “Greatest Hits” in the album?
  17. How many Beatle songs are in the database?
  18. How many 1961 songs have a 192 bit rate?
  19. How many records have no year data?
  20. How many albums do the The Groovie Ghoulies have?
  21. What song has the largest time of all the Ska songs?
  22. Which artist has the Classic Rock song with the largest size?
  23. What is the 3rd longest Beatles song?
  24. Which artist has the longest Rap/Hip-Hop song?
  25. How many bands share the same year and genre as The La’s?
  26. What is the shortest 2005 rock song?
  27. What 1970 Motown song is not funny?
  28. The song with the largest size shares the same genre as what 1995 album?
  29. Long Tall Sally is a song that shares the same genre as what Tina Turner song?
  30. The New Order Best of album is composed by?
  31. Kriss Smith is a friend of mine. What is his longest song?
  32. Enrique Iglesias and Chad Kroeger individual songs with the same name. What's the song's name?