High School

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?

1) Save a backup copy of the workbook
2) Rename the workbook
3) Create a new workbook
4) Delete the original workbook

Answer :

To preserve the original workbook, use the Save As function to make and save a copy under a new name or at a different location, enabling you to work on the copy without affecting the original.

To preserve the original version of a workbook while allowing changes to be made to a copy, the best approach would be to save a backup copy of the workbook. This can be achieved by using the Save As function in your spreadsheet software. Here are the steps you might take:

  1. Go to menu item: File > Save As....
  2. In the Save As box, enter a file name for your document to differentiate it from the original version.
  3. In the Where drop-down menu, select the location where you would like to save this backup copy.
  4. Optionally, in the Format drop-down list, select a desired file format such as Excel 97 - 2004 Workbook (.xls) if needed.
  5. Click Select Save to complete the process.

Once the backup copy is saved under a new name or at a different location, you can freely make changes to the workbook without worrying about altering the original file.

Other Questions