Question: 2 . Edit fields in a PivotTable. a . Select the PivotTable sheet tab and change the display name for cell D 3 to Sold.

2. Edit fields in a PivotTable.
a. Select the PivotTable sheet tab and change the display name for cell D3 to Sold.
b. Change the display name for cell A3 to Staff.
3. Copy the PivotTable sheet to the end and keep the default sheet name.
4. Select the PivotTable sheet and remove the Staff field from the PivotTable. Verify that the data is sorted in ascending order by the transaction field.
5. Create named sets in a PivotTable.
a. Create a set based on row items named Odd.
b. Deselect the Replace the fields currently in the row area with the new set box.
c. Select and delete each even-numbered transaction and the row that displays All. Click OK when finished.
d. Create a set based on row items named Even.
e. Deselect the Replace the fields currently in the row area with the new set box.
f. Select and delete each odd-numbered transaction and the All row. Click OK when finished.
g. Display the Odd set in the PivotTable (Figure 10-87).
6. Select the PivotTable(2) sheet tab. Display the Product and Staff fields as rows in that order and the Sold field as a value. Show subtotals at the bottom of each group and AutoFit each column.
7. Insert a timeline for PivotTable(2) and choose Quarters as the time division. Then select the fourth quarter for 2019 in the timeline (Figure 10-88).
8.
Use GETPIVOTDATA in cells H4:H6 on the Sales sheet to display fourth quarter sales for the products.
9. Save and close the workbook (Figure 10-89). When the Compatibility Checker dialog box opens while saving, click Continue, and close the workbook.
I only need help with the formula for question 8 please - thank you
2 . Edit fields in a PivotTable. a . Select the

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 Programming Questions!