trevorq - Trevor.xls Pivot Table Exercise. As you complete...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Trevor.xls Pivot Table Exercise. As you complete the exercise, answer the following questions by filling in the value or checking the box. Name _________________________________ Class time ______________________________ 1. Which mechanic had the most hours and how many hours did they put in? Mechanic __________ Hours ___________ 2. What was the grand total of all hours worked? Total Hours ________________ 3. Which mechanic had the highest average time per repair? Mechanic __________ Time ___________ 4. Highest earning mechanic # _________ Sum of dollars _________ Lowest earning mechanic # _________ Sum of dollars _________ 5. Model of car making the most money? Model ________ Total earnings ____________ Model and mechanic combination making the most money? Model _________
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course EST 325 taught by Professor Wan during the Spring '09 term at SUNY Stony Brook.

Page1 / 2

trevorq - Trevor.xls Pivot Table Exercise. As you complete...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online