Pivot Charts
Questions and Answers
- 1.
You have created a PivotChart showwing sales by quarter by sales rep. Before presenting it ti management, you notice the name of a rep who has since been fired. How do you delete this rep from the chart without deleting the data?
- A.
Make the emloyee's data points and axis titles invisible.
- B.
Click the arrow next to the Sales Rep field and remove the employees name
- C.
You can't delete the rep from the chart without first deleting the data.
- D.
Hide that rep's row(s) in the underlying list, which automatically removes that rep from the chart
Correct Answer
B. Click the arrow next to the Sales Rep field and remove the employees nameExplanation
To delete the rep from the chart without deleting the data, you can click the arrow next to the Sales Rep field and remove the employee's name. This action will hide the employee's data points and axis titles, effectively removing them from the chart while keeping the data intact.Rate this question:
-
- 2.
When we create the pivot table and then if we have to make pivot chart in which group of options Tab pivotchart option is located ?
- A.
Action
- B.
Data
- C.
Active field
- D.
Tools
Correct Answer
D. ToolsExplanation
The correct answer is "Tools" because when creating a pivot table, the pivot chart option is typically located in the "Tools" group of options. This group contains various tools and features related to manipulating and analyzing data, including the option to create a pivot chart based on the pivot table data.Rate this question:
-
- 3.
In which Tabs of Ribbon Pivot Chart Formatting options are located ?
- A.
Design, layout, Format, Analyze
- B.
Data, Design, Layout, Format
- C.
View, Developer, Design, layout.
Correct Answer
A. Design, layout, Format, AnalyzeExplanation
The correct answer is Design, layout, Format, Analyze. These tabs are located in the Ribbon, which is the toolbar at the top of the application window in Microsoft Excel. The Design tab provides options to customize the appearance and layout of the pivot chart. The Layout tab allows users to modify the arrangement and organization of the chart elements. The Format tab offers various formatting options such as changing the chart style, color, and font. The Analyze tab provides tools for analyzing and manipulating the data in the pivot chart.Rate this question:
-
- 4.
Filter can not be applicable on pivot Chart.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because filters can be applied to pivot charts. Pivot charts allow users to filter and analyze data based on specific criteria. This feature allows for a more focused and customized view of the data in the pivot chart.Rate this question:
-
- 5.
Pivot chart shows the filter on Chart according to the value .
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The pivot chart is a data visualization tool that allows users to filter and analyze data based on different criteria. When a filter is applied to the pivot chart, it adjusts the chart accordingly, displaying only the data that meets the specified criteria. This helps in gaining insights and understanding trends in the data more effectively. Therefore, the statement "Pivot chart shows the filter on Chart according to the value" is true.Rate this question:
-
- 6.
Pivotchart can change as you want.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A pivot chart is a graphical representation of data that is derived from a pivot table. It allows you to manipulate and customize the chart as per your requirements. You can change the chart type, add or remove fields, apply filters, and modify the layout and formatting. Therefore, the statement "pivotchart can change as you want" is true, as it accurately describes the flexibility and versatility of pivot charts in terms of customization and modification.Rate this question:
-
- 7.
pivotchart can move to another sheet.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A pivot chart is a visual representation of data that is created from a pivot table. It allows users to analyze and summarize large amounts of data in a graphical format. One advantage of using a pivot chart is that it can be easily moved to another sheet within the same workbook. This can be useful when organizing and presenting data in different sections or when sharing the chart with others. Therefore, the statement that a pivot chart can move to another sheet is true.Rate this question:
-
- 8.
Pivot chart can be in 3-D format.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A pivot chart can be in a 3-D format, meaning it can be displayed with three dimensions instead of the usual two dimensions. This allows for a more visually appealing and interactive representation of data, as it can show not only the values of different categories but also their relationships in a three-dimensional space. This feature is particularly useful when analyzing complex data sets or when trying to identify patterns or trends that may not be easily visible in a traditional two-dimensional chart.Rate this question:
-
- 9.
By which Tab of pivot chart tool pivot filter can be removed form pivot chart ?
- A.
Design
- B.
Layout
- C.
Format
- D.
Analyze
Correct Answer
D. AnalyzeExplanation
The correct answer is "Analyze". In the Analyze tab of the pivot chart tool, there is an option to remove the pivot filter from the pivot chart. This tab provides various options and tools for analyzing and manipulating the data in the pivot chart, including the ability to add or remove filters, change the data source, and perform calculations.Rate this question:
-
- 10.
Which of the following command tabs is unique to an Excel PivotChart?
- A.
PivotChart Tools Design tab
- B.
PivotChart Tools Layout tab
- C.
PivotChart Tools Format tab
- D.
PivotChart Tools Analyze tab
Correct Answer
D. PivotChart Tools Analyze tabExplanation
The PivotChart Tools Analyze tab is unique to an Excel PivotChart because it provides options and tools specifically designed for analyzing and manipulating data in a PivotChart. This tab allows users to modify the layout, filter and sort data, add calculated fields, and perform other analytical tasks on the PivotChart. The other three tabs (Design, Layout, and Format) are also available in regular Excel charts, but the Analyze tab is exclusive to PivotCharts.Rate this question:
-
Back to top