\u00a0\u00a0Excel_3F_Streets
\n\u00a0\u00a0
\nProject Description:
\nIn the following project, you will edit a worksheet that will be used to prepare a five-year forecast of the costs associated with street maintenance.
\n\u00a0\u00a0\u00a0\u00a0\u00a0
\nOpen \u00a0\u00a0the Excel workbook Student_Excel_3F_Streets.xlsx downloaded with this project.
\n\u00a0
\nChange the Theme Colors to Blue \u00a0\u00a0Green. On the Housing Revenue sheet, in the range B4:F4, fill the year range \u00a0\u00a0with the values 2016 through 2020.\u00a0
\n\u00a0
\nIn cell C6, construct a formula \u00a0\u00a0to calculate the percent of increase in annual street maintenance costs from \u00a0\u00a02016 to 2017. Format the result with the Percent Style and then fill the \u00a0\u00a0formula through cell F6 to calculate the percent of increase in each year.
\n\u00a0
\nIn the range B12:F12, use the \u00a0\u00a0fill handle to enter the years 2020 through 2024. Use Format Painter to apply the format from cell B4 to the \u00a0\u00a0range B12:F12.\u00a0
\n\u00a0
\nCopy the value in cell F5 to \u00a0\u00a0cell B13. In cell B10, type 6% which is the projected increase estimated by the City financial \u00a0\u00a0analysts. To the range A10:B10, apply Bold and Italic.
\n\u00a0
\nIn cell C13, construct a formula \u00a0\u00a0to calculate the annual projected street maintenance costs for the year 2021 \u00a0\u00a0after the projected increase of 6% is applied. Use absolute cell references \u00a0\u00a0as necessary. Fill the formula through cell F13, and then use Format Painter \u00a0\u00a0to copy the formatting from cell B13 to the range C13:F13.
\n\u00a0
\nUse Format Painter to copy the \u00a0\u00a0format from cell A8 to cell A15. Copy the range B12:F12, and then Paste the \u00a0\u00a0selection to B17:F17.
\n\u00a0
\nCopy the range B13:F13 and then \u00a0\u00a0paste the Values & Number Formatting to the range B18:F18. Complete the \u00a0\u00a0Projected Estimates section of the worksheet by changing the Projected \u00a0\u00a0Increase in B10 to 4% and then copying and pasting the Values & Number \u00a0\u00a0Formatting to the appropriate range in the worksheet. Save your workbook.
\n\u00a0
\nSelect rows 8:24, and then \u00a0\u00a0insert the same number of blank rows as you selected. Clear Formatting from \u00a0\u00a0the inserted rows. By using the data in A5:F5, insert a Line with Markers \u00a0\u00a0chart in the worksheet. Move the chart so that its upper left corner is positioned \u00a0\u00a0in cell A9 and visually centered under the data above.
\n\u00a0
\nDisplay the Select Data Source \u00a0\u00a0dialog box, and then edit the Horizontal (Category) Axis Labels using the \u00a0\u00a0range that contains the years in B4:F4. Format the Bounds of the Vertical \u00a0\u00a0(Value) Axis so that the Minimum is 2000000 and the Major unit is at 200000.
\n\u00a0
\nFormat the Chart Area with a \u00a0\u00a0Border by applying a Solid line. In the fifth column, click the last color. \u00a0\u00a0Change the Width of the border to 2 pt.<\/p>\n","protected":false},"excerpt":{"rendered":"
\u00a0\u00a0Excel_3F_Streets \u00a0\u00a0 Project Description: In the following project, you will edit a worksheet that will be used to prepare a five-year forecast of the costs…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-101917","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/posts\/101917","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/comments?post=101917"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/posts\/101917\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/media?parent=101917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/categories?post=101917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/tags?post=101917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}