A Company's word-processed daily report contains a graph from a spreadsheet. The report needs to display the most recent information from the spreadsheet. What feature should be used to insert the most up-to-date graph?

The correct answer is Linking and embedding.

Important Points

Object Linking and Embedding (or OLE for short)

• It is a technique used to insert data from one programme into another.
• A simple spreadsheet to illustrate the process, and place it in to Word document.
• When the Excel spreadsheet is updated, one can see the Word version update itself as well.

Additional Information

Mail merge wizard:

• Under MS WORD Mail merge lets you create a batch of documents that are personalized for each recipient.
• For example, a form letter might be personalized to address each recipient by name.
• A data source, like a list, spreadsheet, or database, is associated with the document.

Automated importing:

• Excel can import data from external data sources including other files, databases, or web pages. Click the Get Data button.
• Some data sources may require special security access, and the connection process can often be very complex.

Cut Copy Paste:

• By default when one copy (or cut) and paste in Excel, everything in the source cell or range—data, formatting, formulas, validation, comments—is pasted to the destination cell(s).