USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Changes become part of the change history only when the user:
|
|
exits Excel.
|
|
|
saves the workbook.
|
|
|
shares the workbook.
|
|
|
turns off Track Changes.
|
Explanation:
Detailed explanation-1: -By default, Excel keeps the change history for 30 days and permanently erases any change history that is older than this number of days. To keep change history for a longer than 30 days, enter a number that is larger than 30. Click OK and, if you are prompted to save the workbook, click OK to save the workbook.
Detailed explanation-2: -This will list all tracked changes on a new worksheet, called the History sheet, which shows many details about each change including when it was made, who made it, what data was changed, whether the change was kept or not.
There is 1 question to complete.