cpt_109_lesson_7_solution

cpt_109_lesson_7_solution - POLE STAR GARAGE List of...

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

View Full Document Right Arrow Icon
POLE STAR GARAGE List of employees SURNAME FIRST NAME DEPARTMENT SALARY AGE 100 DURAND Paul Bodyshop 14,012.00 33 110 SANTOS Luis Workshop 20,156.00 30 120 PARADISO Lorenzo Sales 13,562.00 24 130 AUBERSON Pascal Workshop 12,408.00 23 140 PIZZAGALI Luigi Workshop 31,749.00 23 150 FERNANDEZ José Bodyshop 22,691.00 27 160 BOLOMEY Edouard Administration 32,824.00 33 170 BLANC Jacques Bodyshop 21,555.00 32 Number of employees Number of employees in workshop Total salaries for employees over 30 Number of employees in: Administration Bodyshop Sales Workshop
Background image of page 1

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

View Full DocumentRight Arrow Icon
POLE STAR GARAGE List of employees SURNAME FIRST NAME DEPARTMENT SALARY AGE 100 DURAND Paul Bodyshop 14,012.00 33 110 SANTOS Luis Workshop 20,156.00 30 120 PARADISO Lorenzo Sales 13,562.00 24 130 AUBERSON Pascal Workshop 12,408.00 23 140 PIZZAGALI Luigi Workshop 31,749.00 23 150 FERNANDEZ José Bodyshop 22,691.00 27 160 BOLOMEY Edouard Administration 32,824.00 33 170 BLANC Jacques Bodyshop 21,555.00 32 Number of employees =COUNTA(B6:B13) Number of employees in workshop =COUNTIF(D5:D13;"Workshop") Total salaries for employees over 30 =SUMIF(F6:F13;">=30";E6:E13) Number of employees in: Administration =COUNTIF(D$6:D$13;B19) Bodyshop =COUNTIF(D$6:D$13;B20) Sales =COUNTIF(D$6:D$13;B21) Workshop =COUNTIF(D$6:D$13;B22) SURNAME FIRST NAME DEPARTMENT SALARY AGE 160 BOLOMEY Edouard Administration 32,824.00 33 170 BLANC Jacques Bodyshop 21,555.00 32 100 DURAND Paul Bodyshop 14,012.00 33 150 FERNANDEZ José Bodyshop 22,691.00 27 120 PARADISO Lorenzo Sales 13,562.00 24 130 AUBERSON Pascal Workshop 12,408.00 23 140 PIZZAGALI Luigi Workshop 31,749.00 23 110 SANTOS Luis Workshop 20,156.00 30 Starting from the original list displayed above, follow the procedure shown next page to obtain the result below (the list is sorted alphabetically on department and then on employee surname). A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
Background image of page 2
Autumn 2006 BOS1-E Week 12 Course Excel 2003 SORT PREPARATION
Background image of page 3

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

View Full DocumentRight Arrow Icon
RAMASTOU S.A. MATERIAL RECYCLING Arrivals in tons HOUR DATE MUNICIPALITYMATERIAL TRANSPORTER QTY / T 07:00 3/1/2006 LAUSANNE Plastic OECHSNER 4 07:30 3/1/2006 EPALINGES Plastic FREDERICI 1 08:00 3/1/2006 PULLY Glass OECHSNER 12 08:30 3/1/2006 LAUSANNE Aluminium FREDERICI 4 09:00 3/1/2006 LAUSANNE Glass OECHSNER 18 09:30 3/1/2006 PULLY Plastic OECHSNER 3 10:00 3/1/2006 EPALINGES Aluminium FREDERICI 4 10:30 3/1/2006 EPALINGES Glass OECHSNER 15 11:00 3/1/2006 PULLY Aluminium FREDERICI 1 07:00 3/15/2006 LAUSANNE Aluminium FREDERICI 8 07:30 3/15/2006 LAUSANNE Glass OECHSNER 16 07:00 3/30/2006 EPALINGES Glass OECHSNER 6 07:30 3/30/2006 PULLY Plastic OECHSNER 2 08:00 3/30/2006 LAUSANNE Plastic FREDERICI 3 08:30 3/30/2006 LAUSANNE Aluminium FREDERICI 4 09:00 3/30/2006 PULLY Aluminium FREDERICI 2 09:30 3/30/2006 EPALINGES Aluminium FREDERICI 1 10:00 3/30/2006 PULLY Glass OECHSNER 5 10:30 3/30/2006 LAUSANNE Glass OECHSNER 14
Background image of page 4
Sales for the week of 20 to 24 march Product Salesman Customer
Background image of page 5

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

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

This homework help was uploaded on 04/19/2008 for the course CPT CPT 109 taught by Professor A.sisini during the Fall '08 term at Franklin CH.

Page1 / 14

cpt_109_lesson_7_solution - POLE STAR GARAGE List of...

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

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