Question

1. question 10: how can you change the range of data displayed on an axis in an xy scatter plot in excel? a) drag the axis to expand or contract the range b) right - click on the axis and select \format axis\ c) select the axis and choose \change axis range\ from the \chart tools\ tab in the ribbon d) the range of an axis cannot be changed on an xy scatter plot

Explanation:

In Excel, to change the range of data on an axis in an XY scatter - plot, the standard method is to right - click on the axis. This action brings up a context menu where the "Format Axis" option is available. Through the "Format Axis" dialog box, one can adjust various aspects including the range of the axis.

• Option a: Dragging the axis in Excel does not directly change the data range. It may change the visual appearance in some limited ways but not the actual range of data values.
• Option c: There is no "Change Axis Range" option in the "Chart Tools" tab in the ribbon in the way described. The main way is through the "Format Axis" option.
• Option d: The range of an axis in an XY scatter plot can be changed, so this option is incorrect.

Answer:

B. Right - click on the axis and select "Format Axis"