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 solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |