Advertisements
Advertisements
Question
Excel automatically redraws the chart ______.
Options
If any change is made in the data.
If any change is made in the range data.
If any change is made in the data, and if any change is made in the range data, both.
None of the above
Advertisements
Solution
Excel automatically redraws the chart if any change is made in the data, and if any change is made in the range data.
Explanation:
In Microsoft Excel, charts maintain a dynamic, live link to their source worksheet cells. Because of this automatic linkage, Excel will immediately redraw and refresh the chart if you modify an existing number inside the linked cells, or if you expand, shrink, or shift the selected block of cells that the chart reads from. Both altering individual values and modifying the designated data range trigger an instant visual update.
