Question

To link an Excel chart to a Word document, select the chart, click the Copy button, click the destination location in Word, click the Paste button arrow, and then click the _____ option.

Answer 1

To link an Excel chart to a Word document, select 'Paste Special' after clicking the 'Paste' button arrow in Word, then choose 'Paste link' for a dynamic connection.

Step-by-step explanation:

To link an Excel chart to a Word document, after selecting and copying the chart, you should navigate to the desired location in the Word document where you aim to paste it. Once there, after clicking the Paste button arrow, you need to select the appropriate paste option. Typically, you would click either 'Keep Source Formatting' to maintain the original format of the chart, 'Use Destination Theme' to adapt the chart to the formatting of the Word document, or 'Paste as Picture' if you want a static image of the chart. However, to ensure the chart is linked rather than just embedded or inserted as an image, you should select the 'Paste Special' option and then choose 'Paste link' to create a dynamic link to the original Excel chart. This ensures that if the data in the Excel chart is updated, the changes will reflect in the Word document as well.