DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -You will not be able to make changes to the file unless you disable the protection mode. Double-clicking the cell for editing purposes will pop a message “The cell or chart you are trying to change is on a protected sheet. To make a change, unprotect the sheet.”
Detailed explanation-2: -To unprotect a sheet, follow these steps: Go to the worksheet you want to unprotect. Go to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet.
Detailed explanation-3: -1. Click Review > Protect Sheet. 2. In the Protect Sheet dialog box, specify a password in the Password to unprotect sheet box, and check the Edit objects box in the Allow all users of this worksheet to box, then click the OK button.