Question

You have been asked by the Director of the Employment Development Department for the city of Seattle, to analyze the employment sectors in the city. Employment data for the previous two years is listed below:

Job Sector	2016 Employment	2017 Employment
Government	1,795	1,524
Healthcare	2,832	2,952
Retail	2,525	2,480
Food Service	3,961	3,753
Industrial	1,477	1,595
Professional	2,515	2,802

Create a workbook to provide the employment information for each sector and the total employment for each year. Insert a column to calculate the percent change from 2016 to 2017. Note that some of the results will be negative numbers. Format the percentages with two decimal places. Insert a chart (your choice) in its own sheet that illustrates the 2017 employment figures and format the chart attractively. Format both the chart and the worksheet so that they are professional and easy to read and understand. Insert a footer with the file name and add appropriate document properties. Save the file as LastName_FirstName_Seattle. Submit the spreadsheet through Canvas Module 6 Excel Capstone.

Answer 1

S Spreadsheets HomeInsert Page Layout Formulas Data Review View Sign in Calibri General Paste"飞Copy Format Painter B 1 u田-A··A-多· Merge and Wrap [1:96 , 0:郊 conditional Format as Format. Rows an Columns AutoSum. AutoFilter, Sort, Center Text Formatting Table Share Q Q fxSUM(B2:B7) 1 Job Sector 2 Government 3 Healthcare 4 Retail 5 Food Service 6 Industrial 7 Professional 2016 Employment 2017 Employment 1795 2832 3961 1477 2515 15105 3753 2802 10 12 13 14 15 16 17 18 19 21 23 24 25

S Spreadsheets HomeInsert Page Layout Formulas Data Review View Cloud Sign in Calibri Paste. [ Copy Format B 1 u田 么▼ Merge and Wrap [:2-96 , 000 Conditional Format as AutoSum. AutoFilter" Sort. Format. Rows and Works Center Text FormattingTable Columns Share Click to f C8 Q fx SUM(C2:c7 1 Job Sector 2 Government 3 Healthcare 4 Retail 5 Food Service 2016 Employment 2017 Employment 152 2832 25 2480 3753 Industrial 7 Professional 251 15105 1510 10 12 13 16 17 18 19 21 23 25 100 %

S Spreadsheets Home Insert Page Layout FormulasData Review View Cloud Sign in Cut Paste" G Copy Format B 1 U田 Calibr General +-Д·4·ミーーーーMerge and Wrap % 9 .00 Conditional Format as Autosum. AutoFilter. Sort. Format, Rows and workshe FormattingTable Painter Text Columns Share Q Click to finc SUMIF 1 Job Sector 2 Government 3 Healthcare 4 Retail 5 Food Service 6 Industrial 7 Professional 2016 Employment 2017 Employment Difference mod 271-ABS( D2) 120 1795 1524 umber 1477 2515 15105 3753 1595 2802 15106 118 118 287 287 10 12 13 14 16 17 18 19 21 25 Sheet+

S spreadsheets ▼ Insert Page Layout Formulas Data Sign in Paste" Copy Format B 1 u田 Painter 산▼ Merge and Wrap Text % , 000 conditional Format as AutoSum. AutoFilter. Sort, Format. Rows and worksheet FormattingTable Columns share a click to find 1 Job Sector 2 Government 3 Healthcare 4 Retail 5 Food Service 6 Industrial 7 Professional 2016 Employment 2017 Employment Differencemodi 1795 2832 2525 1524 120 1477 2515 15105 3753 1595 2802 15106 208 118 287 E2:E7) SUM 12 13 14. 16 17 18 19 20 21 25 Sheet

S Spreadsheets HomeInsert Page Layout Formulas Data Review ViewCloud Sign in Cut Calibri General Paste" Copy Format B 1旦田-B. *. . 4. -Ξミーー Merge and Wrap 呒. % ’ Conditional Format as Formattingable Autosum. AutoFilter" Sort. Format. Rows and Works Center Text Columns Share Click to B. 1 Job Sector 2 Government 3 Healthcare 4 Retail 5 Food Service 6 Industrial 7 Professional 2016 Employment 2017 Employment Difference mod) Percent change 1795 2832 2525 3961 1477 2515 15105 2.71 1.2 0.45 2.08 1.18 1524 2952 120 120 3753 208 118 287 118 2802 15106 287 E7/100 1049 10 12 13 15 16 17 19 23 24 25 Sheet1 +

S Spreadsheets Page LayoutFormulasData Sign in Review View Cloud General Paste" G Copy Format B 1旦田 圛· A. 4▼ ニーーー Merge and Wrap [ 96 , 00 Conditional Format as Autosum" AutoFilter" sort. Format. Rows and works FormattingTable Center Ψ Text Columns ▼ r- Share Click to f 0 2016 Employment 2017 EmploymentDifference od Percent chan 1 Job Sector 2 Government 3 Healthcare 4 Retail 5 Food Service 6 Industrial 7 Professional 1795 271 2.71 1.2 0.45 2.08 1.18 2.87 2832 2952 3961 1477 2515 15105 3753 1595 2802 15106 208 118 287 118 1049 SUM( F2:F7) SUM Numberl 10 12 13 14 15 16 17 18 19 20 21 h+

S Spreadsheets Home nsert Page Layout FormulasData Reiew View Cloud Sign in A QHeader/Footer Objedt A O control Prop PivotTable PivotChart Table PictureScreenShapesChart S Insert Chart Edit Code Grab Share Q Click to find 81 Q fx 2016 Employment 2016 Employment 2017 Employmene 1524 Bar 1 Job Sector 2 Government 3 Healthcare 4 Retail 5 Food Service 6 Industrial 7 Professional 1795 2832 Clustered Column Chart Title 3961 1477 2515 15105 BXY (Scatter) 2802 Stock 15106Rada 10 Templates 12 13 14 15 16 17 18 19 21 23 24 Sheet Sum-60422 Average-4315.857143 Count-16