Question

1. question 8: what does the \bubble chart\ option do when creating an xy scatter plot in excel? a) it changes the shape of the data points from circles to bubbles b) it adds labels to the data points c) it adds a trendline to the chart d) it displays an additional data series as bubble sizes for each data point

Explanation:

A bubble chart in Excel, when creating an XY scatter plot, uses an additional data series to determine the size of each bubble (data point). It's not just about changing the shape name (a is wrong as circles and bubbles are similar in basic concept here in terms of the misunderstanding of the option's real function). Adding labels (b) is a different formatting option. Adding a trendline (c) is a separate feature. The key is that the bubble chart uses an extra data series for bubble - size (d).

Answer:

d) It displays an additional data series as bubble sizes for each data point