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? 1. PivotFilters 2. PivotCharts 3. PivotFormats 4. 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
A pivot chart differs from a regular chart insofar that:a pivot chart can filter the data directly within the chart,a pivot chart contains more data than a regular chart cana pivot chart must categorize the information from largest to smallesta regular chart is easier to build
Question 4Which of the following statements accurately describe pivot tables? Select all that apply.1 pointThe values in a pivot table are used to calculate and count data. A pivot table is a data summarization tool.The rows of a pivot table organize and group data horizontally. The calculated field in a pivot table is used to apply filters based on specific criteria.
A pivot table is a data-summarization tool used in data processing. Which of the following tasks can pivot tables perform? Select all that apply.1 pointClean dataReorganize dataGroup dataCalculate totals from data
Question 3What combination of settings was used to create this Pivot Table?
Question 1When you create a Pivot Table, your data must be in a Table beforehand.
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.