This assigment have to be done in Excel. I have uploaded two documents. The first one are the instructions and the second one is the format with Excel that I have to complete with the instructions mentioned.
Grader – Instructions Excel 2016 Project
GO16_XL_CH06_GRADER_6E_HW – Hires 1.2
In the following project, you will assist Linda Wong, Employer Relations Manager, in tracking the number of people who get hired by an employer at each fair. You will create and modify a chart to display the number of people hired at the fairs in the past five years, create a diagram of the communities served, and create an organizational chart for staff at the Job Fair.
Steps to Perform:
Start Excel. Download and open the Excel workbook named go16_xl_ch06_grader_6e_hw.xlsx.
Using the data in the range B4:F10, insert Sparklines using the Line format. Place the sparklines in the range adjacent to the 2016 column, show the High Point and Last Point, and then apply Sparkline Style Accent 4, Darker 25%. Note, depending on the version of Office you are using, the style name may be Dark Purple, Sparkline Style Accent 4, Darker 25%.
Type Trend in the cell above the sparklines.
Using the data for the years and for each location (not the totals) and the Recommended Charts command, create a Clustered Column chart on a separate chart sheet named Hires by Location Chart.
From the Change Chart Type dialog box, on the All Charts tab, if necessary, on the left click Column, and then on the right, at the top of the dialog box, click the fourth chart icon—3-D Clustered Column, and then click OK.
Apply Chart Style 5 to the chart, and add a chart title above the chart with the text Job Hires by Location. Set the title’s font size to 28.
Format the Chart Area with a solid fill using Olive Green, Accent 3, Lighter 80%. Format the Plot Area with a solid fill two shades darker—Olive Green, Accent 3, Lighter 40%.
Format the floor and the side wall with a solid color using Aqua, Accent 5, Darker 50% and 60% transparency. Add the chart element Axis Title to the vertical axis with the text Number of Attendees Hired and change the font size to 16.
On the Job Hires by Location worksheet, using the data for Dallas, insert a Line with Markers line chart. Resize the chart to position the upper left corner within cell A13 and the lower right corner within cell G26.
Change the chart title to Successful Job Hires in Dallas and set the title’s font size to 16. Format the Vertical (Value) Axis so that the Minimum value is 400 and the Major unit is 25.
Add a Linear Trendline. Format the Line Color of the trendline with Orange, Accent 6 and set the Width of the line to 2 pt.
Insert a new sheet and name it List Chart. In cell A1, type Three Largest Communities We Serve
Merge and center this title across the range A1:G1 and apply the Title cell style.
Insert a SmartArt graphic using the Vertical Box List. In the three boxes, type, in order, Dallas, Fort Worth, and Carrollto
Job Hires by Location
Dallas-Fort Worth Job Fair
Successful Job Hires by Location
2012 2013 2014 2015 2016
Dallas 560 527 660 539 666
Fort Worth 288 282 311 293 307
Arlington 131 130 138 152 150
Plano 108 125 133 146 142
Irving 86 108 83 90 96
Carrollton 71 74 76 73 84
Denton 83 86 96 84 94
Total Attendance 1,327 1,332 1,497 1,377 1,539
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.