Ask Question
26 July, 07:48

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.

+1
Answers (1)
  1. 26 July, 09:43
    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 and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers