Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

GO16_XL_CH03_GRADER_3F_HW - Streets 1.1 Project Description: In the following project, you will edit a worksheet that will be used to prepare a five-year forecast of

GO16_XL_CH03_GRADER_3F_HW - Streets 1.1

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.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel. Download and open the file named go16_xl_ch03_grader_3f_hw.xlsx.

0.000

2

Change the Theme Colors to Paper. In cell A1 type City of Pacifica Bay and then Merge & Center the title across columns A:F. Apply the Title cell style.

4.000

3

In cell A2, type Street Maintenance Costs 2012 to 2016 and then Merge & Center the subtitle across columns A:F. Apply the Heading 1 cell style.

4.000

4

In the range B4:F4, fill the year range with the values 2012 through 2016. Type Annual Street Costs in cell A5 and type Percent Increase in cell A6.

6.000

5

Change the width of column A to 20.00 (145 Pixels), and then change the width of columns B:F to 11.00 (82 Pixels). Type the following values in the indicated cells. B5: 2194374 C5: 2438156 D5: 2497489 E5: 2614252 F5: 2716008

10.000

6

Select B5:F5, display the Cell Styles gallery, and then apply the Currency [0] cell style to the values in B5:F5. Apply the Heading 1 cell style to the years and apply the Heading 4 cell style to the range A5:A6.

6.000

7

In cell C6, construct a formula to calculate the percent of increase in annual street maintenance costs from 2012 to 2013. Format the result with the Percent Style and then fill the formula through cell F6 to calculate the percent of increase in each year.

10.000

8

In cell A8, type Projected Street Maintenance Costs and then use Format Painter to copy the formatting from cell A2 to cell A8. Type Projected Increase in cell A10, and then type Year in cell A12.

4.000

9

In cell A13, type Projected Costs and then in the range B12:F12, use the fill handle to enter the years 2016 through 2020. Apply Bold to the years. Copy cell F5 and paste to cell B13. Type 6% in cell B10. To the range A10:B10, apply Bold and Italic.

10.000

10

In cell C13, construct a formula to calculate the annual projected street maintenance costs for the year 2017 after the projected increase of 6% (stored in cell B10) is applied. Fill the formula through cell F13, and then use Format Painter to copy the formatting from cell B13 to the range C13:F13.

6.000

11

In cell A15, type Projected Estimates 2016 to 2020 and then use Format Painter to copy the format from cell A8 to cell A15. In cells A17:A19, type the following row titles: Year 6% Increase 4% Increase

6.000

12

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 the range B13:F13 and pasting the Values & Number Formatting to B19:F19.

8.000

13

Select rows 8:24, and then insert the same number of blank rows as you selected (17 rows). Clear Formatting from the inserted rows. By using the data in A4:F5, insert a Line with Markers chart in the worksheet. Move the chart so that its upper left corner is positioned in cell A9.

10.000

14

Format the Bounds of the Vertical (Value) Axis so that the Minimum is 2000000 and the Major unit is at 200000.

4.000

15

Format the Fill of the Chart Area with a Texture fill by applying the Parchment texturein the third row, the fifth texture. Format the Border of the Chart Area by applying a Solid line using Olive Green, Accent 1, Darker 50%in the fifth column, the last color. Change the Width of the border to 2. Format the Plot Area with a Solid fill using White, Background 1in the first column, the first color.

6.000

16

Click cell A1 to deselect the chart. From the Page Setup dialog box, center the worksheet Horizontally. Insert a custom footer in the left section with the file name.

4.000

17

Click the File tab, and then click Show All Properties. As the Tags, type street maintenance costs As the Subject type your course name and section number. Be sure your name is indicated as the Author.

2.000

18

Save and close the file, and then submit for grading.

0.000

Total Points

100.000

Please help me with figure out the formula's and data

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Trade Based Money Laundering

Authors: John A. Cassara

1st Edition

1119078954, 9781119078951

More Books

Students also viewed these Accounting questions

Question

What do the terms "animosity" and "ethnocentrism" mean?

Answered: 1 week ago