Excel_3f_streets | Computer Science

FIND A SOLUTION AT Academic Writers Bay

  Excel_3F_Streets
  
Project Description:
In 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.
     
Open   the Excel workbook Student_Excel_3F_Streets.xlsx downloaded with this project.
 
Change the Theme Colors to Blue   Green. On the Housing Revenue sheet, in the range B4:F4, fill the year range   with the values 2016 through 2020. 
 
In cell C6, construct a formula   to calculate the percent of increase in annual street maintenance costs from   2016 to 2017. Format the result with the Percent Style and then fill the   formula through cell F6 to calculate the percent of increase in each year.
 
In the range B12:F12, use the   fill handle to enter the years 2020 through 2024. Use Format Painter to apply the format from cell B4 to the   range B12:F12. 
 
Copy the value in cell F5 to   cell B13. In cell B10, type 6% which is the projected increase estimated by the City financial   analysts. To the range A10:B10, apply Bold and Italic.
 
In cell C13, construct a formula   to calculate the annual projected street maintenance costs for the year 2021   after the projected increase of 6% is applied. Use absolute cell references   as necessary. Fill the formula through cell F13, and then use Format Painter   to copy the formatting from cell B13 to the range C13:F13.
 
Use Format Painter to copy the   format from cell A8 to cell A15. Copy the range B12:F12, and then Paste the   selection to B17:F17.
 
Copy the range B13:F13 and then   paste the Values & Number Formatting to the range B18:F18. Complete the   Projected Estimates section of the worksheet by changing the Projected   Increase in B10 to 4% and then copying and pasting the Values & Number   Formatting to the appropriate range in the worksheet. Save your workbook.
 
Select rows 8:24, and then   insert the same number of blank rows as you selected. Clear Formatting from   the inserted rows. By using the data in A5:F5, insert a Line with Markers   chart in the worksheet. Move the chart so that its upper left corner is positioned   in cell A9 and visually centered under the data above.
 
Display the Select Data Source   dialog box, and then edit the Horizontal (Category) Axis Labels using the   range that contains the years in B4:F4. Format the Bounds of the Vertical   (Value) Axis so that the Minimum is 2000000 and the Major unit is at 200000.
 
Format the Chart Area with a   Border by applying a Solid line. In the fifth column, click the last color.   Change the Width of the border to 2 pt.

• WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
• Assignment status: Already Solved By Our Experts
• (USA, AUS, UK & CA PhD. Writers)
• CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER

Why Choose Us?

How It Works

• Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
• Fill in your paper’s requirements in the “PAPER DETAILS” section.
• Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
• Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
• From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.

About AcademicWritersBay.com

AcademicWritersBay.com is an easy-to-use and reliable service that is ready to assist you with your papers 24/7/ 365days a year. 99% of our customers are happy with their papers. Our team is efficient and will always tackle your essay needs comprehensively assuring you of excellent results. Feel free to ask them anything concerning your essay demands or Order.

AcademicWritersBay.com is a private company that offers academic support and assistance to students at all levels. Our mission is to provide proficient and high quality academic services to our highly esteemed clients. AcademicWritersBay.com is equipped with competent and proficient writers to tackle all types of your academic needs, and provide you with excellent results. Most of our writers are holders of master’s degrees or PhDs, which is an surety of excellent results to our clients. We provide assistance to students all over the world.
We provide high quality term papers, research papers, essays, proposals, theses and many others. At AcademicWritersBay.com, you can be sure of excellent grades in your assignments and final exams.