Graduate Essay Writers
Only the most qualified writers are selected to be a part of our research and editorial team, with each possessing specialized knowledge in specific subjects and a background in academic writing.
To hire a writer, fill the order form in a few guided steps - with details from your paper's instructions.
Posted: December 5th, 2022
Microsoft Excel Capstone Exercise
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 2019
Employment
2020 Employment
Government 1,997 2,588
Healthcare 2,532 2,951
Retail 2,501 2,310
Food Service 3,960 3,757
Industrial 1,310 1,585
Professional 2,305 2,848
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 2019 to
2020. 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
2020 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.
Please see the Rubric to ensure you have completed all components of this
assignment.
Excel Capstone Rubric
Criteria Ratings Pts
This criterion is linked to a Learning
Outcome
Data entered into Worksheet
20 to >0.0 pts
Full Marks
0 pts
No Marks
20
pts
This criterion is linked to a Learning
Outcome
Percent Change column
15 to >0.0
pts
Full Marks
0 pts
No
Marks
15
pts
This criterion is linked to a Learning
Outcome
Format Percentages 2 decimal places
5 to >0.0
pts
Full
Marks
0 pts
No
Marks
5
pts
This criterion is linked to a Learning
Outcome
Chart (inserted, depicts correct data)
25 to
>0.0
pts
Full
Marks
0
pts
No
Mar
ks
25
pts
This criterion is linked to a Learning
Outcome
Chart & Worksheet have been formatted
20 to
>0.0
pts
Full
Mark
s
0
pts
No
Ma
rks
20
pts
This criterion is linked to a Learning
Outcome
File name in footer
5 to
>0.
0
pts
0
pt
s
N
o
5
pts
Full
Mar
ks
M
ar
ks
This criterion is linked to a Learning
Outcome
Document Properties
5
to
>0
.0
pt
s
Fu
ll
M
ar
ks
0
p
t
s
N
o
M
a
r
k
s
5
pts
This criterion is linked to a Learning
Outcome
Spelling and Grammar
5
t
o
>
0
.
0
p
t
s
F
u
ll
M
a
r
k
s
0
p
t
s
N
o
M
a
r
k
s
5
pts
Total Points: 100
Every Student Wants Quality and That’s What We Deliver
Only the most qualified writers are selected to be a part of our research and editorial team, with each possessing specialized knowledge in specific subjects and a background in academic writing.
Our prices strike the perfect balance between affordability and quality. We offer student-friendly rates that are competitive within the industry, without compromising on our high writing service standards.
No AI/chatgpt use. We write all our papers from scratch thus 0% similarity index. We scan every final draft before submitting it to a customer.
When you decide to place an order with Nursing Study Bay, here is what happens:
Find an expert with a few clicks and guided steps, fill an order form for your nursing paper. We write AI-plagiarism free essays and research papers. Anytime!.