MOS Excel: Charting Data 2

Question 1

Which chart type is most appropriate for showing how individual parts contribute to a total across multiple categories?

Accepted Answer

100% Stacked Bar chart

Answer

A 100% Stacked Bar chart normalizes each bar to 100%, making it easy to compare proportional contributions across categories.

Question 2

What happens when you click 'Switch Row/Column' in the Chart Design tab?

Accepted Answer

Excel transposes the chart's data series and category axes

Answer

'Switch Row/Column' reassigns which dimension of your data table becomes the series versus the axis categories.

Question 3

A secondary axis is useful when a chart contains data series that:

Accepted Answer

Have very different value scales

Answer

A secondary vertical axis lets you plot series with vastly different magnitudes (e.g., revenue in thousands and percentage rates) without one series appearing flat.

Question 4

In Excel, which keyboard shortcut inserts a chart on a new chart sheet using the default chart type?

Accepted Answer

F11

Answer

Pressing F11 creates an embedded chart on a dedicated chart sheet using Excel's default chart type.

Question 5

Which of the following correctly describes the 'Plot Area' of a chart?

Accepted Answer

The rectangular region bounded by the axes where data is plotted

Answer

The plot area is the inner region bounded by the chart axes where the actual data markers, bars, or lines appear.

MOS - Microsoft Office Specialist Certification Practice Test

MOS - Microsoft Office Specialist Certification Practice Test

MOS Excel: Charting Data 2