DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Track Changes
|
|
|
Change History
|
|
|
History
|
|
|
Names Manager
|
Detailed explanation-1: -The main features of MS Excel include inserting a pivot table, sorting of tabulated data, adding formulas to the sheet, and calculating large data.
Detailed explanation-2: -In the Review tab, select Show Changes. Changes are shown in the pane with the most recent changes on top, in the order the changes were made. You can see who made edits, exactly where in the workbook, when, and what they changed. You can also see Changes made at once by clicking on See changes in a bulk card.
Detailed explanation-3: -To accept the change shown, click “Accept” at the bottom of the dialog box. To reject the change shown, click “Reject” at the bottom of the dialog box. If you want to accept all the changes, click the “Accept All” button at the bottom of the dialog box.
Detailed explanation-4: -The three most common general uses for spreadsheet software are to create budgets, produce graphs and charts, and for storing and sorting data.