Question 2Which chart uses nested rectangles?1 pointSparklines Treemaps Bubble charts Scatter charts

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 7Which plot is used to plot a series of data points over time?1 pointMap ChartTree MapBar ChartLine Chart

50.What type of chart is best used to show the hierarchical structure of data?  A. Pie chart  B. Bar chart  C. Histogram  D. Tree map

How does a treemap display the proportion of data represented?1 pointAs columnsAs data points on a lineAs rectangular shapesAs numerical values2.Question 2What are scatter charts commonly used for? 1 pointTo compare sales, and inventory data values To compare values across hierarchy levels To compare statistical, scientific, and engineering data values To display distribution of data grouped into bins 3.Question 3When you are creating a sparklines visualization, which two methods can you use to specify where the sparklines should appear on a worksheet? (Select two answers)1 pointHighlight the column, then right-click the intended cell location, and select Insert.On the worksheet select a cell and Excel will add the cell reference to the Location Range box for you.Right-click the intended cell location, and select Paste.Enter the cell reference in the Location Range box.4.Question 4What's one data type intended for waterfall charts?1 pointStock performance data Progressively decreasing proportions Non-comparable categories Financial data

Question 1What do treemaps use to represent hierarchical data categories? 1 pointTreemaps use data points on a line.Treemaps use interconnected circles.Treemaps use different shapes.Treemaps use color, size, and closeness of shapes.2.Question 2Histograms can look like a bar chart, what’s the key difference? 1 pointHistograms use bins.Histograms use Axis Options to display different bin sizes.Bar charts use horizontal bars.Bar charts compare data and histograms display the distribution of data.3.Question 3What kind of data works best with filled map charts? 1 pointRaw data Scientific data Data containing geographical regions Complicated data 4.Question 4What are sparklines typically used for?1 pointTo show regional information.To highlight a data range.To contrast numerical values.To show data trends.