FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What is the name of the separate worksheet that temporarily lists all tracked changes in a shared workbook?
A
Changes
B
History
C
Review
D
Tracking
Explanation: 

Detailed explanation-1: -On the Review tab, click Track Changes, and then click Highlight Changes. Select the Track changes while editing. This also shares your workbook check box. Under Highlight which changes, select the When check box, and then in the dropdown list, click the option that you want.

Detailed explanation-2: -To do this, For all other Excel versions, click File > Options > Advanced-in under Display options for this workbook-and then ensure that there is a check in the Show sheet tabs box.

Detailed explanation-3: -A workbook is a separate file just like every other application has. Each workbook contains one or more worksheets. You can also say that a workbook is a collection of multiple worksheets or can be a single worksheet.

Detailed explanation-4: -Answer. If you work with an Excel file that needs to be updated or reviewed by other people, the option to track changes can come in handy. You can also use it when you’re updating a file and need to keep a track of all the changes you do yourself.

There is 1 question to complete.