GMetrix Exam GMetrix Excel: Charts and Data Visualization

Question 1

Which chart type is best suited for showing trends over a period of time in Excel?

Accepted Answer

Line chart

Answer

Pie chart

Answer

Doughnut chart

Answer

Radar chart

Question 2

How do you add a trendline to an existing chart in Excel?

Accepted Answer

Right-click the data series and select Add Trendline

Answer

Click Insert > Trendline

Answer

Click Chart Tools > Format > Trendline

Answer

Click Data > Add Trendline

Question 3

What are Sparklines in Excel?

Accepted Answer

Miniature charts embedded within a single cell

Answer

Full-size animated charts

Answer

Charts saved as images

Answer

3D chart previews

Question 4

Which Excel chart type uses a secondary axis to compare two data series with different scales?

Accepted Answer

Combo chart

Answer

Bubble chart

Answer

Histogram

Answer

Pie chart

Question 5

What is the primary purpose of a PivotChart in Excel?

Accepted Answer

To interactively visualize data summarized in a PivotTable

Answer

To create static printable charts

Answer

To format chart color schemes

Answer

To animate chart transitions

Question 6

After creating a chart in Excel, how do you change its chart type?

Accepted Answer

Right-click the chart and select Change Chart Type

Answer

Delete it and create a new one

Answer

Click File > Chart Options

Answer

Use the View menu