What is the difference between PivotChart and regular chart?Group of answer choicesThe PivotChart is based on the categories and structure of the PivotTable.The regular chart is arbitrary based on any data.There is no difference.The PivotChart is based on the categories and structure of the PivotTable.The regular chart is based on Microsft Excel metadata.The PivotChart is based on Microsoft Excel metadata.The regular chart is arbitrary based on any data.

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

True or False: A PivotChart can only be created from data located in a PivotTable.Group of answer choicesTrueFalse

Pivot tables that have been created can easily be turned into graphs or charts by simply highlighting the whole pivot table and choosing a graph or chart that you want to create.Group of answer choicesTrue.False, pivot tables do not contain enough information for graphs or chartsFalse, only regular tables may be used to create graphs or chartsTrue but only if you first hide all but the two columns you want to appear in your chart.