Excel workbook

E_CH06_GOV2_H3_Instructions.docx

Office 2013 – myitlab:grader – Instructions GO! - Excel Chapter 6: Homework Project 3

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

Updated: 06/17/2013 1 E_CH06_GOV2_H3_Instructions.docx