Excel_6G_Internships_Travel_Instructions

.docx

School

California Polytechnic State University, Pomona *

*We aren’t endorsed by this school

Course

1010

Subject

Business

Date

Apr 3, 2024

Type

docx

Pages

3

Uploaded by MasterElementWren43

Report
Grader - Instructions Excel 2022 Project Excel_6G_Internships_Travel Project Description: In this 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, SmartArt graphics, and a funnel chart. You will also create a template to use for travel expenses. Steps to Perform: Step Instructions Points Possible 1 Open the Excel workbook Student_Excel_6G_Internships_Travel.xlsx downloaded with this project. 0 2 On the Internships by Industry worksheet, select the range B4:F10, and then use the Quick Analysis tool to insert Line Sparklines in the range G4:G10. (Mac users: Use the Insert Line Sparkline command on the Insert tab.) 10 3 Format the Sparklines to show the High Point and the Last Point. From the sparkline Style gallery, in the first row, apply the second style. 10 4 By using the data in the ranges A3:F3 and A7:F7, insert a Line with Markers chart for the internships available in the Technology industry. Position the chart so that the upper left corner of the chart aligns with the upper left corner of cell A13 and the bottom corner aligns with the lower right corner of cell G27. 11 5 Change the chart title to Internships Available in Technology 3 6 Edit the Vertical (Value) Axis to set the Minimum to 35 and the Major unit to 5 if necessary. 6 7 Format the Plot Area with a Solid fill—in the last column, select the second color. Format the Chart Area with a Solid fill—in the last column, select the fourth color. 10 8 Insert a Linear Trendline and change the width of the line to 2.5 pt. Navigate to cell A1 to deselect the chart. Close any displayed Format panes. 10 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 just inside 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 type Unpaid in the last text box. 6 Created On: 08/10/2022 1 GO22_XL_CH06_GRADER_6G_HW - Internships Travel 1.1
Grader - Instructions Excel 2022 Project Step Instructions Points Possible Apply the Inset 3-D SmartArt style to the graphic. Change the colors to Colored Fill – Accent 1. Navigate to cell A1 to deselect the graphic. 11 On the Funnel Chart worksheet, by using the data in the range A3:B5, insert a Funnel chart. As the Chart Style, apply Style 3. Change the Chart Title to Internship Types Awarded Position the upper left corner of the chart in the center corner of cell A7. 5 12 Change the Shape Width of the chart to 5” Format the border of the Chart Area with a Solid line 3 pt border —as the color, in the color gallery, in the fifth column, select the first color, Blue Accent 1. Select the data labels in the chart and format the Font by applying Bold Italic, a font size of 20, and a Font Color of Black, Text 1. Format the text in the Vertical Axis by apply Bold and changing the font Size to 12. 8 13 Navigate to cell A1 to deselect the chart. Display the Save As dialog box. In the Save as type box, click or press the arrow, and then change the file type to Excel Template. Navigate to your Excel Chapter 6 folder. Using your own name, as the File name type Lastname_Firstname_6G_Internships_Travel_Template and click or press Save. Display the Travel Expenses worksheet. In cell F22, enter a formula that will add the contents of the range F15:F21. Apply the Total cell style to cell F22. 4 14 Select the ranges E8:E10 and A15:E21, and then remove the Locked formatting from the selected ranges. Protect the worksheet using the default selections and the password goseries Navigate to cell A1. 6 15 Display the Save As dialog box, navigate to your Excel Chapter 6 folder, change the file type to Excel Workbook, and then using your own name as the File name type, Lastname_Firstname_6G_Internships_Travel . This is the file you will submit for grading. Display the first worksheet—Internships by Industry, and then select all of the sheets, display the Page Setup dialog box, and then inert a Custom Footer with the file name in the left section. Be sure the sheets 4 Created On: 08/10/2022 2 GO22_XL_CH06_GRADER_6G_HW - Internships Travel 1.1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help