Question

1. question 4: how can you add a trendline to an xy scatter plot in excel? a) right - click on the data points and select \add trendline\ b) click on the data points and press \ctrl\ + \t\ c) select the data points and choose \add trendline\ from the \chart tools\ tab in the ribbon d) trendlines cannot be added to xy scatter plots in excel

Explanation:

In Excel, for an XY scatter plot, one common way to add a trendline is by right - clicking on the data points. This action brings up a context - sensitive menu where "Add Trendline" is an available option. Option b's "Ctrl + T" is typically for creating a table, not adding a trendline. Option c's description of using the "Chart Tools" tab is not the most straightforward or commonly known method compared to the right - click. Option d is incorrect as trendlines can be added to XY scatter plots.

Answer:

A. Right - click on the data points and select "Add Trendline"