Question: https://www.dropbox.com/s/v965kdcfjj19cek/Chegg%20help.xlsx?dl=0 I need help in doing these steps please show your working out of how to complete step 11 to 15 11 Display the Expenses

https://www.dropbox.com/s/v965kdcfjj19cek/Chegg%20help.xlsx?dl=0

I need help in doing these steps please show your working out of how to complete step 11 to 15

11

Display the Expenses worksheet, and then by using the Quarter names and the Totals by Quarter, insert a Line with Markers chart in the worksheet. Move the chart so that its upper left corner is positioned slightly inside the upper left corner of cell A12. Drag the center-right sizing handle so that the chart extends to slightly inside the right border of column G. As the Chart Title type City of Pacifica Bay Annual Expense Summary.

10.000

12

Format the Bounds of the Vertical (Value) Axis so that the Minimum is 2100000 and the Major unit is at 50000. Format the Fill of the Chart Area with a Gradient fill by applying the Preset, Light Gradient - Accent 3 (third column, first row). Format the Plot Area with a Solid fill using White, Background 1.

10.000

13

Copy the Annual Total in cell F10 and then use Paste Special to paste Values & Number Formatting in cell B35. In cell C35, construct a formula to calculate the Projected Expenses after the forecasted increase in cell B31 is applied. Fill the formula through cell F35, and then use Format Painter to copy the formatting from cell B35 to the range C35:F35.

10.000

14

Change the Orientation of this worksheet to Landscape, and then use the Scale to Fit options to fit the Height to 1 page. From the Page Setup dialog box, center the worksheet Horizontally, and insert a custom footer in the left section with the file name.

10.000

15

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Annual Expenses Chart, Expenses. Save the workbook and exit Excel. Submit the file as directed.

0.000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!