What is one way to preserve the value of a calculation without retaining the calculation in...

 

Transcribed Image Text:

What is one way to preserve the value of a calculation without retaining the calculation in the cell? Select the cells, copy, and use the Paste Special option to paste the values of the calculations, not the calculations themselves, in the cells. Create a column next to the calculated values and type the values into the new column. O Use the Ctrl-Shift-Plus option to replicate the column of values to the right of a highlighted column. Copy and paste the entire worksheet into a new worksheet and then manipulate the columns in the original worksheet only. This method preserves the values in the duplicate worksheet. What is one way to preserve the value of a calculation without retaining the calculation in the cell? Select the cells, copy, and use the Paste Special option to paste the values of the calculations, not the calculations themselves, in the cells. Create a column next to the calculated values and type the values into the new column. O Use the Ctrl-Shift-Plus option to replicate the column of values to the right of a highlighted column. Copy and paste the entire worksheet into a new worksheet and then manipulate the columns in the original worksheet only. This method preserves the values in the duplicate worksheet.

Answer rating: 100% (QA)

Paste Special options has an option to paste the value itself instead of ... View the full answer