FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
All of the FBLA officers have access to the spreadsheet of member contact information. Which feature in Excel allows others to view which officer made changes to the spreadsheet, when the change was made and what changes were made?
A
Track Changes
B
Change History
C
History
D
Names Manager
Explanation: 

Detailed explanation-1: -File encryption: When you choose this option, you specify a password and lock the Excel file. This prevents other users from opening the file. For more information, see Protect an Excel file.

Detailed explanation-2: -The three most common general uses for spreadsheet software are to create budgets, produce graphs and charts, and for storing and sorting data.

Detailed explanation-3: -MS Excel is a spreadsheet program for storing and analysing numerical data. It is a spreadsheet program with several columns and rows, where each intersection of a column and row is referred to as a “cell.” Each cell includes a single piece of data or information.

Detailed explanation-4: -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.

There is 1 question to complete.