DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
No one can edit, only if there your friend or your colleague.
|
|
|
There three types of way to restrict anyone to not touch your work or data, this allow you to control it.
|
|
|
To not let anyone claim your work or edit it in anyway.
|
|
|
A worksheet protection feature that allows you to prevent anyone from changing anything in your workbook, or cells.
|
Detailed explanation-1: -If you don’t want content reviewers to accidentally change a Word document or an Excel spreadsheet, you can use formatting and editing restrictions. Note: To further restrict reviewers from making changes to your document or spreadsheet, you can make the file read-only or you can password protect it.
Detailed explanation-2: -By protecting your worksheet, you can specify that users can only perform specific functions in a sheet. For example, you can give users the ability to enter data, but keep them from deleting rows or columns, or only insert hyperlinks or sort data.
Detailed explanation-3: -To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets, you can protect the structure of your Excel workbook with a password.