Line graphs are effective for highlighting:Proportions within a category.Significant changes in data points over time.pen_sparkComparisons between multiple categories.Outliers and unusual data points.

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.

What is a capability of line charts?1 pointCompare different, unrelated data sets Compare similar, unrelated data sets Compare the frequency of data sets Compare different, but related data sets

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

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

Data from which of the following scenarios is best suited for visualization using a line chart? Select all that apply.1 pointCustomer satisfaction ratings across different product categoriesSales figures for each month over the last yearWebsite traffic throughout the dayProportion of different age groups in a population