Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help me with this question please 2 Click cell A2. Insert the Recommended PivotTable, Sum of Amount by Location . Rearrange the fields so that

help me with this question please

2

Click cell A2. Insert the Recommended PivotTable, Sum of Amount by Location. Rearrange the fields so that Location is the first field in the Rows area, and Month is the second field. Place the Program field in the Columns area. Close the PivotTable Fields pane.

3

Insert two slicers, one for the Location field and one for the Program field.

4

Using the Location and Program slicers, filter the data to show the total revenue for pre-school in Grove Beach Recreation Center. Move the Program slicer so that the top left corner is positioned in cell E3. Move the Location slicer so that it is positioned below the Program slicer in column E.

5

Modify the value field settings in the PivotTable so that values are formatted as numbers with zero decimal places and a 1000 separator.

6

Make a copy of the Sheet1 worksheet. Rename the copied worksheetGrove 1Q Pre-School. Rename the Sheet1 worksheet1Q Revenue.

7

On the 1Q Revenue worksheet, clear all filters and remove the slicers. In cell A1, typeFirst Quarter Youth Program Revenue.

8

Display the Field List, and then remove the Month field from the Rows area to display only the Grand Totals for each item. Close the PivotTable Fields pane.

9

From the 1Q Revenue worksheet, insert a PivotChart using the stacked bar chart type. Verify that the Programs display in the legend, and if they do not, use the Switch Row/Column command to place the Programs in the legend. Move the chart to a new sheet and rename the sheet to1Q Youth Programs Chart.

10

Change the layout of the PivotChart to Layout 3 and change the chart style to Style 2. Change the chart title to1st Quarter Youth Programs Revenue.

11

Hide the Youth Programs worksheet.

12

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Grove 1Q Pre-School, 1Q Youth Programs Chart, 1Q Revenue. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

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

Financial Statement Fraud Prevention And Detection

Authors: Zabihollah Rezaee, Richard Riley

2nd Edition

0470543205, 9780470543207

More Books

Students also viewed these Accounting questions