When utilising the 'Paste Special' function in MS Word to insert content copied from a spreadsheet, which of the following paste options would preserve the original formula calculations while displaying the calculated values in the Word document?

Correct option is C

Correct Answer: (C) MS Excel Worksheet Object

Explanation:

• When you use the 'Paste Special' function in MS Word to insert content copied from a spreadsheet and want to preserve the original formula calculations while displaying the calculated values in the Word document, the "MS Excel Worksheet Object" option is the most suitable.
• This option inserts the spreadsheet as an embedded Excel object, which allows you to retain the functionality of the original Excel formulas and calculations. When you double-click on the inserted object, it opens in Excel, allowing you to modify the content and the calculations.

Information Booster:

• Picture (Enhanced Metafile): This option pastes the data as a static image, which does not retain any formulas or calculations.
• HTML Format: This option pastes the content as HTML, which will not preserve Excel formulas.
• Unformatted Text: This option pastes the data as plain text without any formatting or formulas, displaying only the calculated values at the time of copying.