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.

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

Which of the following is true about tree maps?1 pointThey show a hierarchy of information without much detail.They are best used for geographical information.They are seldom customized, so they are very consistent.They can show a lot of data at once because of features like the color and shape of components.

What does each rectangle in a Tree Map represent?Review LaterA different color.A different category or sub-category.A different hierarchy of data.None of the above

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 1How does a treemap display the proportion of data represented?1 pointAs numerical valuesAs data points on a lineAs columnsAs rectangular shapes