USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
GETPIVOTDATA
|
|
|
INDEX
|
|
|
SLICER
|
|
|
VLOOKUP
|
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: -FAQ: GetPivotData Function On the Excel Ribbon, click the PivotTable Analyze tab. Click the drop-down arrow on the PivotTable command. Next, click the drop-down arrow for Options. In the list of options, click the Generate GetPivotData command, to toggle that feature off or on.
Detailed explanation-3: -The GETPIVOTDATA function is generated automatically when you reference a value cell in a pivot table by pointing and clicking. To avoid this, you can simply type the address of the cell you want (instead of clicking).