FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You can use the ____ function to pull data from a PivotTable so that you can reference the data in a location outside of the PivotTable-either on the same worksheet or in another worksheet.
A
NOPIVOTDATA
B
USEPIVOTDATA
C
PULLPIVOTDATA
D
GETPIVOTDATA
Explanation: 

Detailed explanation-1: -You can quickly enter a simple GETPIVOTDATA formula by typing = (the equal sign) in the cell you want to return the value to and then clicking the cell in the PivotTable that contains the data you want to return.

Detailed explanation-2: -Go to the sheet with the PivotTable, and then find a blank cell. Type =, just like normal, and then type in the cell reference, like A1. Copy it, and then go to the cell in the other sheet where you want the reference to appear.

Detailed explanation-3: -What is the GETPIVOTDATA Function? The GETPIVOTDATA Function[1] is categorized under Excel Lookup and Reference functions. The function helps to extract data from specified fields in an Excel Pivot Table.

Detailed explanation-4: -In the PivotTable, make sure the cell that you want to use in each formula is visible. In a worksheet cell outside the PivotTable, type the formula that you want up to the point where you want to include data from the report. Click the cell in the PivotTable that you want to use in your formula in the PivotTable.

There is 1 question to complete.
Previous
Next