Pivot Charts

1. Pivotchart can move to another sheet.

True

False

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.

Explanation

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.

2. Pivot chart can be in 3-D format.

True

False

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.

Explanation

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.

3. Pivotchart can change as you want.

True

False

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.

Explanation

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.

4. Pivot chart shows the filter on Chart according to the value .

True

False

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.

Explanation

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.

5. Filter can not be applicable on pivot Chart.

True

False

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.

Explanation

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.

6. In which Tabs of Ribbon Pivot Chart Formatting options are located ?

Design, layout, Format, Analyze

Data, Design, Layout, Format

View, Developer, Design, layout.

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.

Explanation

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.

7. 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?

Make the emloyee's data points and axis titles invisible.

Click the arrow next to the Sales Rep field and remove the employees name

You can't delete the rep from the chart without first deleting the data.

Hide that rep's row(s) in the underlying list, which automatically removes that rep from the chart

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.

Explanation

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.

8. Which of the following command tabs is unique to an Excel PivotChart?

PivotChart Tools Design tab

PivotChart Tools Layout tab

PivotChart Tools Format tab

PivotChart Tools Analyze tab

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.

Explanation

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.

9. 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 ?

Action

Data

Active field

Tools

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.

Explanation

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.

10. By which Tab of pivot chart tool pivot filter can be removed form pivot chart ?

Design

Layout

Format

Analyze

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.

Explanation

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.