Uing a pivot table create a summarized report showing the


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

Solution Preview :

Prepared by a verified Expert
Operation Management: Uing a pivot table create a summarized report showing the
Reference No:- TGS02485121

Now Priced at $20 (50% Discount)

Recommended (99%)

Rated (4.3/5)