Express HelpLine

ExpressHelpLine is the largest online question and Expert answer site.
Thousands of Verified Experts/Tutors are online round the clock.

Question (Category: Computer-Science General-CS )
Excel project Instructions For the purpose of grading the project you are required to perform the following tasks Step Instructions Points Possible 1 Start Excel. Open the downloaded Excel workbook named GO_e03_Grader_EOC.xlsx . 0 2 On the Public Works worksheet, in cell G5, insert a formula that will calculate what percentage of the total cost (in F10) was used by the Administration department (in F5). Ensure that the reference to the total cost is an absolute cell reference, and then copy the formula into the range G6 G9. 7 3 On the Public Works worksheet, create a 3-D Pie chart using the ranges A5 A9 and F5 F9. 8 4 Move the pie chart to a new worksheet. Name the worksheet Public Works Summary Chart , add a title above the chart using the text 2016 Public Works Cost of Operations and change the font size of the title to 28. 6 5 Remove the legend from the pie chart, and then add data labels positioned in the center of the slices. Format the data labels so that only the category names and percentages are displayed. Bold and italicize the data labels, and then change the font size to 12. 11 6 Apply a Circle Bevel shape effect to the pie chart. Modify the shape effect, so that top bevel has a height and width of 256pt , the bottom bevel has a height and width of 50 pt , and the surface material of the chart is Metal (under Standard). 10 7 Change the angle of the first slice to 50 . 2 8 Change the fill color of the chart area to Aqua, Accent 2 (under Theme Colors). 2 9 Insert a text box positioned outside the upper corner of the Administration pie slice that is 0.5 inches tall and 1.68 inches wide. In the text box, type Administration expense to increase by 3% and then change the font size to 10.5. 5 10 On the Public Works worksheet, create a line with markers chart using the ranges B4 E4 and B10 E10. 8 11 Move the chart so that its upper left corner is positioned in cell A12, aligned approximately under the t in the word Collections in cell A8. Remove the legend and then add the text 2016 Public Works Cost Summary as a chart title above the chart. 7 12 Edit the primary vertical axis so that the minimum is fixed at 8.3E6 and the major unit is fixed at 200000.0 and then change the fill color of the chart area to Aqua, Accent 2, Lighter 40% (under Theme Colors). 6 13 On the Public Works worksheet, in cell C32, insert a formula that will calculate the projected operations cost after the forecasted increase in cell B30 is added to the 2016 total (in B32). Ensure that the reference to cell B30 is an absolute cell reference, and then copy the formula into the range D32 F32. 9 14 Use Format Painter to copy the format of cell B32 to the range C32 F32. 2 15 Insert the text Public Works Department as WordArt using the Fill - Brown, Accent 1, Metal Bevel, Reflection style. Change the font size of the WordArt to 32 and then position the WordArt so that the top-left corner is centered in cell A34. 6 16 On the Projected Decrease worksheet, copy the contents of cell B5, and then paste the values and number formats (not the formula) into cell B13. 4 17 Copy cell C5 and paste the contents into cell C13. In cell C13, use Goal Seek to determine the goal amount of administration expenses in cell B13 if the value in C13 is set to 7% . 5 18 Center the Projected Decrease worksheet horizontally on the page. 2 19 Ensure that the worksheets are correctly named and placed in the following order in the workbook Public Works Summary Chart, Public Works, Projected Decrease. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points 100


Answer by Matt D. (Purchased 3 times and rated )