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

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

A bar chart can consist of __________a.Only vertical barsb.Only horizontal barsc.Either vertical or horizontal barsd.Both vertical and horizontal bars

What is the main difference between Area and Column charts? 1 pointAn area chart makes sense of complicated data and a column chart shows chart axis like basic charts An area chart uses horizontal bars, and a column chart uses rows A column chart uses vertical bars, and an area chart uses data points A column chart uses data points, and an area chart uses vertical bars

Although histograms and bar charts use a column-based display, they serve different purposes. A bar graph is used to compare discrete or categorical variables in a graphical format whereas a histogram depicts the frequency distribution of variables in a dataset.

Histograms can look like a bar chart, what’s the key difference? 1 pointHistograms use Axis Options to display different bin sizes.Bar charts use horizontal bars.Histograms use bins.Bar charts compare data and histograms display the distribution of data.