OnlineNursingOwl
← All nursing posts

Engineering · Studypool

Excel Pivot

Overview

Please find attached a data set for borrowing programming books from LSC libraries in town. You need to create a Pivot table & chart to find out the answers for below questions:

  1. From which library, students checked out the most/highest number of books?
  2. There is one book that has been checked out the most from all different LSC libraries. What is the title that book?
  3. Which student checked out the maximum number of books? How many books and in which month?
  4. There is one month when students check out books equally. What is that month? 
  5. Write down the name of student(s) who borrowed the maximum number of books for the months of Jan, May and Oct?