Microsoft Excel Test
Instructions:
• In order to complete this test, you will need the file called "Excel Advanced Test" .
• The file has 2 sheets in it called ‘data video rentals' and ‘rental costs'
• Bring the cost for each rental and length of movie from the rental costs sheet into the data video rentals sheet using a formula (leave the formula in the spreadsheet)
• Using a pivot table create a summarized report showing the $ amount made per rental category and the number of videos rented per category
• Format the report for presentation
• Do not include the comedy numbers in your totals but do not delete any rows from any of your spreadsheets.
Attachment:- AdvancedTest.rar