Question 8Which of the following statements is true?1 pointAll pivot charts are comprised of three areas: Row, Column, and DataYou can only modify the legend and title of a chart.A chart can only be used with a pivot table.Updating a pivot table will also immediately affect any associated charts.9.Question 9

Question 6How does a pivot chart differ from a standard chart in Excel? 1 pointA pivot chart contains data series, categories, and chart axes A pivot chart cannot be a line, pie or bar chart A pivot chart uses data from a pivot table A pivot chart always has its data arranged in columns and rows

1.Question 1What is the difference between Bar and Column charts?1 pointThe length of the bars The width of the bars One uses vertical bars, and one uses horizontal bars The number of bars 2.Question 2Which chart uses nested rectangles?1 pointScatter charts Bubble charts Treemaps Sparklines 3.Question 3Which two charts typically have categories arranged on the horizontal axis and values on the vertical axis? 1 pointColumn and pie charts Pie and bar charts Pie and line charts Column and line charts 4.Question 4When you add a filter to a pivot chart, how do you update the data in the original source pivot table?1 pointYou need to manually add the filter to the pivot table in the PivotTable Fields pane You need to click Refresh All in the Data group of the Analyze tab for the pivot table You need to refresh the pivot table worksheet to refresh the data You do not need to do anything, as changes are immediately reflected in the pivot table data too

Which of the following is true about an area chart?1 pointIt cannot be produced using a PivotChart.It cannot contain negative values.It contains a filled area under a series of data points.It is round, similar to a pie chart.

Which of the followings is FALSE?Group of answer choicesPivot Chart uses data from Pivot TableYou can not change the chart type in Pivot ChartChanges in Pivot Table will change Pivot ChartIf you change filter option in Pivot Chart, filter option in Pivot Table will change.

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