To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?

a) Save the workbook with a new filename.
b) Delete the original workbook and work only on the copy.
c) Make a photocopy of the workbook.
d) Use the "Save As" function to create a duplicate copy of the workbook.

Answer :

Final answer:

To preserve the original version of a workbook, use the "Save As" function to create a duplicate copy with a new name or in a different location. The correct option is D .

Explanation:

To preserve the original version of a workbook so you can make changes to a copy of it, the correct action would be to use the "Save As" function to create a duplicate copy of the workbook. The "Save As" feature in software like Microsoft Excel allows you to save a new version of the file with a different name or in a different location. This ensures that the original file remains unchanged while you work on the new copy.

  1. Open the workbook that you wish to preserve.
  2. Go to File > Save As...
  3. In the Save As dialog box, type a new name for the file, adding identifiers like "-R1" or "-R2" to indicate revision versions.
  4. In the Where drop-down menu, select the location you would like to save the new copy of your document if you want to change it.
  5. If needed, select the appropriate format for your workbook, such as "Excel 97 - 2004 Workbook (.xls)" if you need compatibility with older versions of Excel.
  6. Click Save to create the new file, leaving the original file untouched.

By saving the workbook with a new filename, you create a separate document that allows you to make changes without affecting the original data. Additionally, you should consider the proper format for your needs, especially if you're using macros or need to maintain compatibility with older versions of Excel.