Ask Question
20 September, 02:33

In a PivotTable, how can a field of data be hidden from the viewer but still be active in calculations made by Excel's formulas?

A. The user can go to the raw data worksheet and delete the data that is in the field.

B. The user can go to the raw data worksheet and cut the data from the field and paste it into a new field.

C. The user can select a cell in that field and click "Collapse Entire Field" in the Options tab.

D. The user can select a cell in that field and click "Hide Entire Field" in the View tab.

+3
Answers (1)
  1. 20 September, 02:39
    0
    C. The user can select a cell in that field and click "collapse entire field" in the options tab. Is probably not right!
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “In a PivotTable, how can a field of data be hidden from the viewer but still be active in calculations made by Excel's formulas? A. The ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers