Explain the purpose of applying a filter to a PivotTable and what types of filters you can apply.
What will be an ideal response?
The PivotTable might contain too much detail. You can apply a filter to include only the values that meet a particular condition. You can set a main filter by dragging a field to the Filters area of the Field List and then click the filter arrow in column B to specify the condition(s) you want. You can also apply filters to control data displayed in rows and columns.
You might also like to view...
Give one example of a task for which you would not write a program, and give another example of a task for which you would write a program.
What will be an ideal response?
According to the International Telecommunications Union ____ of people living in developing countries have cell phones.
A. 7.4% B. 14.6% C. 52.1% D. 67.6%
A _____ indicates the cell's column and row location.
A. ?cell range B. ?cell tab C. ?cell reference D. ?cell report
If you include a watermark, it will only be displayed in Read Mode or when the document is printed
Indicate whether the statement is true or false