Scenario: You have a dashboard that contains charts linked to pivot tables, which in turn links to data in a table. If you add new data to the table and want to update the dashboard, you would need to update:

(A) The table first, then only one of the pivots and the other pivots and the dashboard will update with the pivot update

(B) The table first, then the pivots and then the charts on the dashboard in three separate updates

(C) Only the table, all will refresh when the table is updated

(D) It is not necessary to update anything, Excel always displays the current data

Conclusion

This question is from the Quiz section of the third lesson “Visualizing Data in Excel” from the HubSpot Excel for Marketers course. You can find answers to all the quiz questions asked in this course on our HubSpot Excel for Marketers Lesson Quiz Answers page.

Leave a Comment

Share via
Copy link
Powered by Social Snap