GMetrix Exam GMetrix Excel: Charts and Data Visualization 1 — Questions and Answers
Question 1: Which chart type is best suited for showing trends over a period of time in Excel?
- Pie chart
- Line chart (Correct answer)
- Doughnut chart
- Radar chart
Correct answer: Line chart
Line charts connect data points sequentially, making them ideal for visualizing trends over time.
Question 2: How do you add a trendline to an existing chart in Excel?
- Click Insert > Trendline
- Right-click the data series and select Add Trendline (Correct answer)
- Click Chart Tools > Format > Trendline
- Click Data > Add Trendline
Correct answer: Right-click the data series and select Add Trendline
Right-clicking a data series inside the chart reveals the Add Trendline option.
Question 3: What are Sparklines in Excel?
- Full-size animated charts
- Miniature charts embedded within a single cell (Correct answer)
- Charts saved as images
- 3D chart previews
Correct answer: Miniature charts embedded within a single cell
Sparklines are tiny in-cell charts that display data trends without occupying a separate chart area.
Question 4: Which Excel chart type uses a secondary axis to compare two data series with different scales?
- Bubble chart
- Combo chart (Correct answer)
- Histogram
- Pie chart
Correct answer: Combo chart
Combo charts combine two chart types and support a secondary axis to accommodate different data scales.
Question 5: What is the primary purpose of a PivotChart in Excel?
- To create static printable charts
- To interactively visualize data summarized in a PivotTable (Correct answer)
- To format chart color schemes
- To animate chart transitions
Correct answer: To interactively visualize data summarized in a PivotTable
PivotCharts dynamically visualize PivotTable data and update automatically when filters or slicers change.
Question 6: After creating a chart in Excel, how do you change its chart type?
- Delete it and create a new one
- Right-click the chart and select Change Chart Type (Correct answer)
- Click File > Chart Options
- Use the View menu
Correct answer: Right-click the chart and select Change Chart Type
Right-clicking the chart area presents the Change Chart Type option without requiring you to recreate the chart.
GMetrix Exam GMetrix Excel: Charts and Data Visualization 1
Which chart type is best suited for showing trends over a period of time in Excel?