MOS Excel: Charting Data 3

Question 1

Which chart type displays three variables simultaneously using X position, Y position, and the size of each data point?

Accepted Answer

Bubble chart

Answer

A Bubble chart extends the Scatter chart by using a third numeric variable to determine the size (bubble diameter) of each plotted point.

Question 2

When you move a chart from the current worksheet to a separate chart sheet, the chart's data source:

Accepted Answer

Remains linked to the original worksheet

Answer

Moving a chart to a chart sheet only relocates the chart object; the data still resides in and links to the original worksheet.

Question 3

Which option in the Format Data Labels pane allows you to show the category name next to each data point?

Accepted Answer

Category Name checkbox under Label Contains

Answer

Checking 'Category Name' in the Label Contains section displays the category (axis label) alongside each data marker.

Question 4

A Radar chart is best suited for which type of analysis?

Accepted Answer

Comparing multiple attributes of several items simultaneously

Answer

Radar (or spider) charts display multiple quantitative variables on axes radiating from a central point, ideal for comparing profiles across categories.

Question 5

What does the 'Explosion' setting in the Format Data Point pane do for a Pie chart?

Accepted Answer

Pulls a single slice away from the rest of the pie

Answer

Explosion separates an individual slice from the body of the pie chart to emphasize that specific data point.

MOS - Microsoft Office Specialist Certification Practice Test

MOS - Microsoft Office Specialist Certification Practice Test

MOS Excel: Charting Data 3