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

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

Which two charts typically have categories arranged on the horizontal axis and values on the vertical axis? 1 pointColumn and line charts Pie and line charts Column and pie charts Pie and bar charts

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

Question 1What is a capability of line charts?1 pointCompare different, unrelated data sets Compare different, but related data sets Compare the frequency of data sets Compare similar, unrelated data sets 2.Question 2Each portion of a pie chart represents static values or categories. What is the sum of the categories equal to? 1 point50%100%99% 75%3.Question 3According to the ‘Introduction to Charts’ video, which chart is one of the most commonly used?1 pointBubble chart Funnel chart Bar chart Scatter chart 4.Question 4In the ‘Expert Viewpoints: Using Visualizations to Tell a Data Story’ video, one expert mentioned two software programs that help highlight the important information. Which were the two software programs? 1 pointPowerPoint and Excel Google and Bing Google Docs and Word Db2 and SQL 5.Question 5In the ‘Creating Basic Charts in Excel’ video, which type of chart shows the relative contribution of unit sales from Ford car models? 1 pointPie chart Line chart Funnel chart Bar chart 6.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 7.Question 7What is the main difference between Area and Column charts? 1 pointA column chart uses vertical bars, and an area chart uses data points An area chart uses horizontal bars, and a column chart uses rows A column chart uses data points, and an area chart uses vertical bars An area chart makes sense of complicated data and a column chart shows chart axis like basic charts

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