cpt109_lesson_18_solution

cpt109_lesson_18_solution - POLE STAR GARAGE List of...

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

View Full Document Right Arrow Icon
POLE STAR GARAGE List of employees SURNAME FIRST NAME DEPARTMENT SALARY 100 Durand Paul Bodyshop 14,012 110 Santos Luis Workshop 20,156 120 Paradiso Lorenzo Sales 13,562 130 Auberson Pascal Workshop 12,408 140 Pizzagali Luigi Workshop 31,749 150 Fernandez José Bodyshop 22,691 160 Blanc Edouard Administration 32,824 170 Bolomey Jacques Bodyshop 21,555 Conclusions: Bodyshop salary costs: Salary costs for over 30s: Average age in the workshop: Youngest in the bodyshop: Average salary for employees over 30: No. of mechanics: No. of employees in bodyshop and workshop: No. of mechanics over 30: No. of employees in sales or over 30:
Background image of page 1

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

View Full DocumentRight Arrow Icon
AGE 33 30 24 32 23 27 33 32
Background image of page 2
B C D E F 2 POLE STAR GARAGE 3 4 List of employees 5 6 SURNAME FIRST NAME DEPARTMENT SALARY AGE 7 Durand Paul Bodyshop 14,012 33 8 Santos Luis Workshop 20,156 30 9 Paradiso Lorenzo Sales 13,562 24 10 Auberson Pascal Workshop 12,408 32 11 Pizzagali Luigi Workshop 31,749 23 12 Fernandez José Bodyshop 22,691 27 13 Blanc Edouard Administration 32,824 33 14 Bolomey Jacques Bodyshop 21,555 32 15 16 Criteria range: 17 DEPARTMENT AGE DEPARTMENT DEPARTMENT AGE 18 Bodyshop >30 Workshop Sales 19 Bodyshop >30 20 21 Conclusions: 22 Bodyshop salary costs: SFr. 58,258.00 23 Salary costs for over 30s: SFr. 80,799.00 =DSUM(B6:F14;E6;C17:C18) 24 Average age in the workshop: 28.33 25 Youngest in the bodyshop: 27 =DMIN(B6:F14;F6;B17:B18)
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

cpt109_lesson_18_solution - POLE STAR GARAGE List of...

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

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