LinkBack URL
About LinkBacks
I have an exercise which is due today, I need help. Please.... Whoever helps me, I will flash to you....desperate lol
1. Based on the cost of a month for each contract and including the monthly rental, create a flexible way of isolating the total income for 2010 for each of the following “Lesson Types”. Piano, Percussion and Violin. Take a copy of the worksheet for each one and paste that copy onto a new worksheet, renaming the worksheet tab to reflect the content. Three new worksheets in all.
I got this one as =SUMIFS(H:H,F:F,F2,D:D,">="&DATE(2010,1,1),E:E,"<="&DATE(2010,12,31)) but i still miss add rental cost....
2. Find out which Instructor gathered the most revenue for us and take a copy to place on a new worksheet with named tab.
3. Create a pivot table on its own worksheet, with the Instructor Names as the Row labels and the Lesson Type as the column labels. Set up a filter on Student Name. With no filter applied, create a Pie Chart for the Piano Lesson Type and place it on the sheet with the Pivot table underneath the table. Make sure there are sufficient labels and legend to make the resulting chart very clear.
Exercise2.xlsxExercise2.xlsx
4. Use the filter on the pivot table to determine which student spends the most money on lessons with us in the year 2010. When you find that student copy the pivot table and place on its own named sheet.
5. There is a quicker way to find the student that spends most money on lessons, rather than first having to create the Pivot Table then go through the filters. See if you can figure it out and then create a new named sheet, place a complete copy of all the data onto that sheet and then write up the instructions about how to determine the student spending the most on lessons.
Register To Reply
Bookmarks