Directly referencing cells in a pivot table works fine as long as you know that the pivot table will never be changed. But that is an unrealistic expectation in many cases. Therefore, we need a way to consistently refer to data in the pivot table even if it is changed. Excel provides the ___________ function for exactly this purpose.
a) PIVOT_TABLE
b) GETPIVOTDATA
c) AVERAGEIF
d) DATA_FIELD
e) GETPIVOTABLE
b) GETPIVOTDATA
You might also like to view...
Answer the following statements true (T) or false (F)
1. Waits of certain length feel longer than waits of uncertain length. 2. The actual waiting time is more important to guests than their perception of waiting time. 3. A guest’s emotional state can have great impact on how long the wait feels to that guest. 4. If the people in a line are a more select clientele with identifiable features, variability in treatment of the waiting guests may be necessary to ensure that the quality of the entire experience meets the guest expectations.
_____________ describes the set of rules that nations have agreed to follow.
Fill in the blank(s) with the appropriate word(s).
Why is it important to be visual during a brainstorming session?
a. It helps eliminate weaker ideas. b. Drawing helps get ideas across. c. It allows people to work independently on different ideas. d. It builds on artistic skills.
The status of a third party is determined by
a. the type of contract. b. whether the third party gave consideration. c. the reasonable expectations of the third party. d. the intent of the contracting parties.