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
Get step-by-step solutions from verified subject matter experts
