Which of the following can be created from a PivotTable? 1. PivotFilters 2. PivotCharts 3. PivotFormats 4. PivotFills
Question
Which of the following can be created from a PivotTable?
- PivotFilters
- PivotCharts
- PivotFormats
- PivotFills
Solution
From a PivotTable, you can create:
-
PivotFilters: Yes, you can create PivotFilters. These are used to filter and sort data in a PivotTable.
-
PivotCharts: Yes, you can create PivotCharts. These are graphical representations of the data in a PivotTable.
-
PivotFormats: No, there is no such thing as PivotFormats in Excel. You can, however, format a PivotTable using the standard formatting options in Excel.
-
PivotFills: No, there is no such thing as PivotFills in Excel. You can, however, fill cells with color in a PivotTable using the standard fill options in Excel.
Similar Questions
Question 1When you create a Pivot Table, your data must be in a Table beforehand.
True or False: A PivotChart can only be created from data located in a PivotTable.Group of answer choicesTrueFalse
Pivot tables are the same as regular tables and therefore use the square brackets to refer to them True False
Which of the following tools in Excel can be used for data validation?Pivot tableData validation toolConditional formattingFilter tool
Pivot tables must show the pivot table on the same sheet as the data, otherwise Excel cannot do pivot charts automatically True False
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.