426
QuizMultiple Choice

Cumulative Exam — Cumulative exam

Question 426 • Career Explorations A

After a chart has been inserted and formatted, is it possible to change the data range it refers to or to add new rows of data?

Answer
A
No, additional data cannot be included in a chart once it has been created; the user should delete the chart and create a new chart.
B
Yes, click the Select Data button in the Data group under the Design tab to extend or reduce the data range.
C
Yes, click the chart, select the additional rows or columns of data to add, and press Enter on the keyboard.
D
Yes, double-click the chart and select Properties from the list; in the Properties box, insert the new data range to include in the chart.

Explanation

Yes. In a spreadsheet program such as Excel, you can change a chart’s source data after creating it. Select the chart, then use Select Data in the Data group on the Design tab to edit or extend the data range. This lets you add or remove rows or columns without rebuilding the chart.

AI-written and checked against the verified answer.

Previous
Next