Excel_4G_Recreation | Excel 4G Recreation 1 | PEARSON MYLAB

Excel 4G Recreation
Contact us
Whatsapp +92306-7065210
Email; myitlabcourses@gmail.com
#Excel_4G_Recreation#4G_Recreation#Recreation#Excel_4G#4G
#Excel_4G_Recreation_Myitlab_Complete_Solution#4G_Recreation_Mylab_Excel#Pearson MyLabSolution_4G_Recreation
#Excel_4G_Recreation_Step_by_Step#Excel_Recreation
#Recreation_Excel_4G#4G_Excel#4G_Recreation_Complete_Solution
Excel_4G_Recreation
Project Description:
In the following project, you will assist James Davis, the Recreation Director, in creating and modifying a PivotTable report and a PivotChart report.
1 Open the Excel workbook Student_Excel_4G_Recreation.xlsx downloaded with this project. 0
2 Click cell A2, and then insert a Recommended PivotTable by choosing the Blank PivotTable option in the lower left corner of the dialog box. Add the Month field to the Filters area, add the Center field to the Rows area and the Program field to the Columns area. Place the Amount field in the Values area and then Close the PivotTable Fields list.
Note, Mac users, move fields as necessary so that they are placed in the correct areas of the layout section. 10
3 Format the values in the PivotTable using the Number category to display zero decimal places and the 1000 Separator. 6
4 Insert slicers for the Program and Center fields, and then filter by the Bard Hall Senior Center and Ceramics and Water Color revenue. Move the Program slicer so that it’s upper left corner aligns with the upper left corner of E3. Move the Center slicer so that its upper left corner aligns with H3. Make a copy of this worksheet, and then name the copied worksheet Bard Hall. 13
5 Display Sheet1 and clear the filters from the slicers and remove the slicers from the worksheet. Rename the sheet 3Q Revenue 5
6 Insert a PivotChart using the Stacked Column chart type. Move the chart to a new worksheet named 3Q Revenue Chart 7
7 Apply the Layout 2 chart layout. Hide all of the field buttons on the chart. As the Chart Title, type 3rd Quarter Program Revenue and then insert a custom footer with the file name in the left section. 6
8 Add a new worksheet to the workbook. On the Data tab, click Get Data and then from your downloaded files, import the Microsoft Access Database Excel_4G_Rec_Centers.accdb. Load both of the tables in the database.
Note, Mac users, on the Data tab, click From Text. From your downloaded files, click Excel_Rec_Center_Supplies_csv.csv, and then click Get Data. Use Comma delimiters and General column data format. Put the data in the Existing sheet in A1. 3
9 Insert a PivotTable in the Existing Worksheet using the From Data Model option. (Mac users, insert a PivotTable in a New worksheet. Select and delete rows 1 and 2 which are blank.) 3
10 To create the PivotTable, place the Supplier field from the Suppliers table in the Columns area. From the Supply Order Summary table, place the Item field in the Rows area, and the Quantity field in the Values area. Apply the Number format to the values in the PivotTable with zero decimals and the 1000 separator. 6
11 Insert a row above the PivotTable, if necessary, and in cell A1, type Recreation Center Supplies and then apply the Title cell style. Rename the sheet Recreation Supplies 4

Видео Excel_4G_Recreation | Excel 4G Recreation 1 | PEARSON MYLAB канала PEARSON MYLAB