Excel Assessment

Which chart type is best suited for showing trends over time?

• Pie Chart

• Column Chart

• Line Chart

• Scatter Plot

What option allows you to switch the rows and columns in an Excel chart?

• "Chart Tools" > "Switch Row/Column"

• "Design" > "Switch Row/Column"

• "Insert" > "Switch Data Source"

• "Format" > "Transpose Data"

How can you insert sparklines into a worksheet?

• Go to "Insert" > "Sparklines" and choose the type

• Right-click on the data and select "Insert Sparklines"

• Go to "Data" > "Insert Sparklines"

• Use "Home" > "Conditional Formatting"

Which of the following is NOT a type of sparkline in Excel?

• Line

• Column

• Win/Loss

• Area

What is the purpose of using sparklines in Excel?

• To create large, detailed charts for presentations

• To display mini-charts within a single cell for quick analysis

• To replace formulas in Excel

• To highlight errors in data

Which chart type is most suitable for visualizing the proportion of parts to a whole?

• Bar Chart

• Pie Chart

• Line Chart

• Scatter Plot

What does the "High Point" option in sparklines do?

• Highlights the highest value in the sparkline with a different color

• Adds a data label showing the highest value

• Automatically creates a new chart for high values

• Filters data to show only high values

How can you add a trendline to a chart in Excel?

• Select the chart, go to "Insert" > "Trendline"

• Right-click on the data series and select "Add Trendline"

• Go to "Data" > "Trendline"

• Use "Formulas" > "Trendline"

How can you change the style of an existing chart in Excel?

• Select the chart and go to "Format" > "Chart Style"

• Right-click the chart and choose "Change Style"

• Select the chart, go to "Design" > "Chart Styles"

• Use "Data" > "Chart Styles"

How do you group sparklines in Excel?

• Select multiple sparklines, then go to "Insert" > "Group Sparklines"

• Select the sparklines, right-click, and choose "Group"

• Use "Sparkline Tools" > "Design" > "Group"

• Sparklines cannot be grouped in Excel