DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS 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: -Locked is the default setting for all cells in a new worksheet/workbook. Once we protect the worksheet (in the next step) those locked cells will not be able to be altered by users. If you want users to be able to edit a particular cell or range, uncheck the Locked box so they are unlocked.
Detailed explanation-2: -On the Home tab, click the Format Cell Font popup launcher. You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells popup, in the Protection tab, uncheck the Locked box and then click OK. This unlocks all the cells on the worksheet when you protect the worksheet.
Detailed explanation-3: -Lock or Unlock Cells By default, cells are locked once a worksheet is protected. If there are cells that users should be able to change after a worksheet has been protected, make sure to unlock them before you protect the worksheet. Select the cells you want to unlock.
Detailed explanation-4: -By default, all cells are locked in Excel, as I discussed above. So, the first thing you have to do in order to lock certain cells is to unlock all cells. To unlock all cells, press Ctrl + A to select all cells. Right-click anywhere within the selection and click “Format Cells”.