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.
Answers (1)
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
You Might be Interested in
Users of an extranet can access a company or organization's entire intranet
Answers (1)
Information Security: There is no current information security standard at Swagger Distribution. You know that one needs to be implemented. Summarize two key information security practices you recommend the company implement.
Answers (1)
What step can Miguel take to solve his dilemma? Miguel is working on a project that requires him to switch back and forth frequently between the desktop and his open windows.
Answers (2)
When entering new data into your table, which key should you press to move from one field or cell to the next?
Answers (1)
A filter is limited to extracting data from a single table. a. True b. False
Answers (1)
New Questions in Computers & Technology
Which of the following is step 5 of the mail merge process? A. Finish the merge B. Insert merge fields and complete your document C. Preview the mail merge document D. Select recipients
Answers (1)
Which of the following were input devices for early portable computers? Browsers Notebooks Tablets Trackballs
Answers (1)
What laptop is the best for programming and hacking
Answers (1)
When you save a drawing using paint, it's automatically stored as a?
Answers (1)
How many columns can you insert in word document in maximum? a. 40 b. 45 c. 50 d. 55
Answers (1)