USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____
|
|
locked
|
|
|
indexed
|
|
|
unprotected
|
|
|
hybrid
|
Explanation:
Detailed explanation-1: -Remove data validation-Select the cell or cells that contain the validation you want to delete, then go to Data > Data Validation and in the data validation dialog press the Clear All button, then click OK.
Detailed explanation-2: -Which action will edit locked cells in a protected worksheet? You are correct! Enter the password to turn off the protection. Enter the password to turn off the protection.
Detailed explanation-3: -A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function. You can nest IF functions as deep as you want, but after you get yet beyond a nest of three IF functions, the logic becomes difficult to follow.
There is 1 question to complete.