Excel Module 4 Review

You can insert WordArt into a worksheet, but not a chart.

• True

• False

To move a chart to another location on the same worksheet, drag it to the location you want.

• True

• False

A Scatter chart shows positive values in green and negative values in red.

• True

• False

You can add a legend to sparklines to indicate the high and low points in the chart.

• True

• False

You can use trendlines to project future data based on past trends.

• True

• False

When you click a chart element such as a legend, it displays sizing handles to indicate it is selected.

• True

• False

To make the appearance of sparklines consistent with other parts of a worksheet, you can change their layout.

• True

• False

To edit placeholder text, such as in a chart title, you click the object and then type the new text.

• True

• False

When you switch rows and columns in a chart, Excel updates the legend at the same time.

• True

• False

A histogram chart displays each category as a rectangle and each subcategory nested within a rectangle.

• True

• False