{"id":16359,"date":"2021-11-17T02:39:29","date_gmt":"2021-11-17T02:39:29","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/excel-workbook-computer-science-homework-help\/"},"modified":"2021-11-17T02:39:29","modified_gmt":"2021-11-17T02:39:29","slug":"excel-workbook-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/excel-workbook-computer-science-homework-help\/","title":{"rendered":"excel workbook | Computer Science homework help"},"content":{"rendered":"
\n\n\n

1<\/span><\/strong><\/p>\n<\/td>\n\n

Start Excel. Download and open the Excel workbook named GO_e06_Grader_h3.xlsx<\/em>.<\/span><\/p>\n<\/td>\n\n

0<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

2<\/span><\/strong><\/p>\n<\/td>\n\n

On the Internships by Industry worksheet, in the range G4:G10, insert line Sparklines using the values in the B4:F10.<\/span><\/p>\n<\/td>\n\n

10<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

3<\/span><\/strong><\/p>\n<\/td>\n\n

Format the Sparklines to show the high point and the last point. Apply the Sparkline Style Accent 4, (no dark or light).<\/span><\/p>\n<\/td>\n\n

10<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

4<\/span><\/strong><\/p>\n<\/td>\n\n

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.<\/span><\/p>\n<\/td>\n\n

11<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

5<\/span><\/strong><\/p>\n<\/td>\n\n

Change the chart title to Internships Available in Technology<\/span><\/strong>.<\/span><\/p>\n<\/td>\n\n

6<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

6<\/span><\/strong><\/p>\n<\/td>\n\n

Edit the Vertical (Value) Axis to set the Minimum to 35<\/span><\/strong> and the Major unit to 5<\/span><\/strong>.<\/span><\/p>\n<\/td>\n\n

6<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

7<\/span><\/strong><\/p>\n<\/td>\n\n

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.<\/span><\/p>\n<\/td>\n\n

8<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

8<\/span><\/strong><\/p>\n<\/td>\n\n

Insert a linear trendline and change the width of the line to 2.5 pt.<\/span><\/p>\n<\/td>\n\n

6<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

9<\/span><\/strong><\/p>\n<\/td>\n\n

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.<\/span><\/p>\n<\/td>\n\n

7<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

10<\/span><\/strong><\/p>\n<\/td>\n\n

In the SmartArt, type Paid<\/span><\/strong> in the top text box. Type Work-Study<\/span><\/strong> in the second text box, and Unpaid<\/span><\/strong> in the last text box.<\/span><\/p>\n<\/td>\n\n

1<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

11<\/span><\/strong><\/p>\n<\/td>\n\n

Apply the Inset 3-D SmartArt style to the graphic. Change the colors to Colored Fill <\/span>\u2013<\/span> Accent 1.<\/span><\/p>\n<\/td>\n\n

6<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

12<\/span><\/strong><\/p>\n<\/td>\n\n

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.<\/span><\/p>\n<\/td>\n\n

7<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

13<\/span><\/strong><\/p>\n<\/td>\n\n

In the SmartArt, on the left, type Ann Takei, Internship Coordinator<\/span><\/strong> in the top box and Dennis Maslin, Specialist<\/span><\/strong> in the second box. On the right, type Shani Kuhlman, Work-Study Coordinator<\/span><\/strong> in the first box and Anand Singh, Specialist <\/span><\/strong>in the second box. Leave the bottom boxes as they are.<\/span><\/p>\n<\/td>\n\n

2<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

14<\/span><\/strong><\/p>\n<\/td>\n\n

Save the workbook as a template with the name GO_e06_Grader_h3_template.xltx<\/span><\/strong>. 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.<\/span><\/p>\n<\/td>\n\n

5<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

15<\/span><\/strong><\/p>\n<\/td>\n\n

Remove the Locked formatting from the ranges D8:D10 and A15:G21. Protect the worksheet using the default selections and the password goseries<\/span><\/strong>.<\/span><\/p>\n<\/td>\n\n

15<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

16<\/span><\/strong><\/p>\n<\/td>\n\n

Save the template as an Excel workbook with the file name, GO_e06_Grader_h3.xlsx<\/em>. 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<\/em> workbook as directed. Do not submit your template file.<\/span><\/p>\n<\/td>\n\n

0<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

\u00a0<\/span><\/p>\n<\/td>\n\n

Total Points<\/span><\/strong><\/p>\n<\/td>\n\n

100<\/span><\/span><\/strong><\/p>\n<\/td>\n<\/tr>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-16359","post","type-post","status-publish","format-standard","hentry","category-homework-help"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/16359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=16359"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/16359\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=16359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=16359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=16359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}