Graduate Essay Writers
Only the finest writers are selected to be a part of our team, with each possessing specialized knowledge in specific subjects and a background in academic writing..
Order for this Paper or similar Assignment Help Service
Fill the order form in 3 easy steps - Less than 5 mins.
Posted: December 5th, 2022
Microsoft Excel Capstone Exercise
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
Why Seek Our Custom Writing Services
Every Student Wants Quality and That’s What We Deliver
Affordable Prices
We balance affordability with exceptional writing standards by offering student-friendly prices that are competitive and reasonable compared to other writing services.
100% Plagiarism-Free
We write all our papers from scratch thus 0% similarity index. We scan every final draft before submitting it to a customer.
How it works
When you opt to place an order with Nursing StudyBay, here is what happens:
Expert paper writers are just a few clicks away
Place an order in 3 easy steps. Takes less than 5 mins.