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
The keyboard preferences pane includes a list of keyboard shortcuts.
Answers (1)
Can someone fix this so that it only says "its a payday" on 15 and 30 and on all other days "sorry, it's not payday" tod=int (input ("Enter today's day numerically:")) if (tod! = 30 or tod! = 15): print ("Sorry, not a payday.
Answers (1)
How did technology influence space exploration?
Answers (1)
When you see the = C7*$B$3 formula, what will happen when it is copied to the cell directly below the active cell using the fill handle?
Answers (1)
What invention was key to computers being moved into homes and personal use? A. microprocessor B. scanner C. flash drive D. keyboard
Answers (2)
New Questions in Computers & Technology
Write the definition of a function reverse, whose first parameter is an array of integers and whose second parameter is the number of elements in the array. The function reverses the elements of the array. The function does not return a value.
Answers (1)
Which is a real-world example of a procedure?
Answers (1)
When compared to traditional desktop customers, why are mobile phone users much more likely to book a room or airline reservation for the same day?
Answers (1)
What does OMR mean in information technology
Answers (1)
What is the synonym for term port?
Answers (1)