Question 1What do treemaps use to represent hierarchical data categories? 1 pointTreemaps use interconnected circles.Treemaps use data points on a line.Treemaps use different shapes.Treemaps use color, size, and closeness of shapes.

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

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

Question 1How does a treemap display the proportion of data represented?1 pointAs numerical valuesAs data points on a lineAs columnsAs rectangular shapes

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