USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Mary has created a PivotTable for a spreadsheet with sales figures. She has updated several cells in the source data to show the most current numbers. When she returns to the PivotTable, she sees it does not reflect the changes.According to the scenario above, what must Mary do to update the changes?
|
|
Select the PivotTable, go to Analyze, and then Refresh.
|
|
|
Select the cells with the updated data, and start the Update PivotTable Wizard.
|
|
|
Select the PivotTable, and then click Refresh from the PivotTables Field task pane.
|
|
|
Select the cells with the updated data, and chose Refresh from the PivotTables ribbon.
|
|
|
Select the PivotTable, and then select the Update PivotTable Automatically check box on the PivotTables ribbon.
|
Explanation:
Detailed explanation-1: -On the right side of the worksheet, a PivotTable Fields task pane is open. In it are four areas (Filters, Columns, Rows, and Values) where various field names can be placed to create a PivotTable. The task pane also includes a checklist area of the fields from which to choose from the data.
Detailed explanation-2: -A Data Model enables you to use a PivotTable by using the data from multiple, related tables.
Detailed explanation-3: -The Sum function is used by default for numeric value fields you place in your PivotTable, but here’s how to choose a different summary function: In the PivotTable, right-click the value field you want to change, and then click Summarize Values By.
There is 1 question to complete.