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

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.

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

What are Sparklines used for in Excel?Answer areaDisplaying small, inline charts or graphs within a cell to visualize trends or patterns in data.Importing external data from other sources into an Excel workbook.Automatically generating pivot tables based on specified data ranges.Creating conditional formatting rules to highlight specific data points in a worksheet.

In which situation would you have a higher-value visualization in terms of performing data analysis with a treemap rather than with a pie chart?Select an answer:You want your legend to wrap in the content area.You want to distill your data into categories.You prefer to have the data displayed in the form of a table.You want to look at a higher level of detail in a category.