nursing experts help
Internships and Travel Template
Project Description:
In the following project, you will assist Ann Takei, Internship Coordinator, in tracking the number of internships by industry at each job fair. You will insert and format sparklines, a line chart, and SmartArt graphics. You will also create a template to use for travel expenses.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
| Step | Instructions | Points Possible |
| 1 | Start Excel. Download and open the Excel workbook named GO_e06_Grader_h3.xlsx. | 0 |
| 2 | On the Internships by Industry worksheet, in the range G4:G10, insert line Sparklines using the values in the B4:F10. | 10 |
| 3 | Format the Sparklines to show the high point and the last point. Apply the Sparkline Style Accent 4, (no dark or light). | 10 |
| 4 | Create a line with markers chart using the ranges A3:F3 and A7:F7. Position the chart so that the upper left corner of the chart aligns with the upper left corner of cell A13. | 11 |
| 5 | Change the chart title to Internships Available in Technology. | 6 |
| 6 | Edit the Vertical (Value) Axis to set the Minimum to 35 and the Major unit to 5. | 6 |
| 7 | Format the plot area with a Green, Accent 6, Lighter 80% solid fill. Format the chart area with a Green, Accent 6, Lighter 40% solid fill. | 8 |
| 8 | Insert a linear trendline and change the width of the line to 2.5 pt. | 6 |
| 9 | On the List Chart worksheet, insert a SmartArt graphic using the Pyramid List style. Position the SmartArt so that the upper left corner of the graphic aligns with the upper left corner of cell A3. | 7 |
| 10 | In the SmartArt, type Paid in the top text box. Type Work-Study in the second text box, and Unpaid in the last text box. | 1 |
| 11 | Apply the Inset 3-D SmartArt style to the graphic. Change the colors to Colored Fill – Accent 1. | 6 |
| 12 | On the Organization Chart worksheet, insert a SmartArt graphic using the Hierarchy List style. Position the SmartArt so that the upper left corner of the graphic aligns with the upper left corner of cell A3. | 7 |
| 13 | In the SmartArt, on the left, type Ann Takei, Internship Coordinator in the top box and Dennis Maslin, Specialist in the second box. On the right, type Shani Kuhlman, Work-Study Coordinator in the first box and Anand Singh, Specialist in the second box. Leave the bottom boxes as they are. | 2 |
| 14 | Save the workbook as a template with the name GO_e06_Grader_h3_template.xltx. On the Travel Expenses worksheet, in cell H22 enter a formula that will add the contents of the range H15:H21. Apply the Total cell style to cell H22. | 5 |
| 15 | Remove the Locked formatting from the ranges D8:D10 and A15:G21. Protect the worksheet using the default selections and the password goseries. | 15 |
| 16 | Save the template as an Excel workbook with the file name, GO_e06_Grader_h3.xlsx. Ensure the worksheets are in this order: Internships by Industry, List Chart, Organization Chart, Travel Expenses. Close the workbook. Exit Excel. Submit the GO_e06_Grader_h3.xlsx workbook as directed. Do not submit your template file. | 0 |
| Total Points | 100 |
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
Excel Workbook was first posted on July 25, 2019 at 12:50 pm.
©2019 "nursing Writers". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at admin@nursingexpertshelp.com
“Is this question part of your assignment? We will write the assignment for you. click . and get up to 40% Discount”
Excel Workbook was first posted on July 25, 2019 at 12:50 pm.
©2019 "nursing experts help". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at admin@nursingexpertshelp.com
nursing experts help
Source link
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
