USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The statement that best describes the GETPIVOTDATA function is that it:
|
|
deletes unused data from a PivotTable.
|
|
|
inputs data from a location outside of the PivotTable to a PivotTable.
|
|
|
extracts data stored in a PivotTable.
|
|
|
pulls data from a PivotTable and creates a new chart.
|
Explanation:
Detailed explanation-1: -The GETPIVOTDATA function returns visible data from a PivotTable.
Detailed explanation-2: -The GetPivotData function is a highly efficient way to get specific data from a pivot table. Here are a few advantages of using this function to get pivot data. Excel builds formula automatically, based on pivot table cell that was clicked.
Detailed explanation-3: -Q: What is the main advantage of referencing cells in a Pivot Table with the GetPivotData() function rather than by regular cell reference? A: It returns the same values even if the layout of the data changes.
There is 1 question to complete.