USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What does Emma need to do before she can group the data in her PivotTable?
|
|
aggregate
|
|
|
filter
|
|
|
sort
|
|
|
subtotal
|
Explanation:
Detailed explanation-1: -d. Right-click on the PivotChart and select Refresh.
Detailed explanation-2: -On the Data tab, in the Outline group, click Group. Then in the Group dialog box, click Rows, and then click OK. Tip: If you select entire rows instead of just the cells, Excel automatically groups by row-the Group dialog box doesn’t even open. The outline symbols appear beside the group on the screen.
Detailed explanation-3: -Delete any blank rows Or coloums.
There is 1 question to complete.