DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
lock
|
|
|
protect
|
|
|
hide
|
|
|
delete
|
Detailed explanation-1: -It simply prevents users from modifying locked cells within the worksheet. Protecting a worksheet is not the same as protecting an Excel file or a workbook with a password. See below for more information: To lock your file so that other users can’t open it, see Protect an Excel file.
Detailed explanation-2: -By locking cells in an Excel worksheet and protecting the worksheet, you can protect your work from unwanted tampering from other users.
Detailed explanation-3: -A Locked cell cannot be formatted, nor can its contents be changed or deleted. This is a great feature for preventing complex formulas and functions from being accidentally erased. But even though cells may be locked, the “locking” doesn’t go into effect until the user also protects the worksheet.
Detailed explanation-4: -By default, protecting a worksheet locks all cells so none of them are editable. To enable some cell editing, while leaving other cells locked, it’s possible to unlock all the cells.