DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
____ ensures that users do not change values inadvertently that are critical to the worksheet.
|
|
Cell protection
|
|
|
Range Finder
|
|
|
The formula checker
|
|
|
A data table
|
Explanation:
Detailed explanation-1: -Once you’ve unlocked the input cells in your financial model, you can now protect your worksheet by going to the “Review” ribbon and selecting “Protect Sheet.” It is important that we unlock the input cells prior to protecting the worksheet, as users will need to make changes to the model inputs.
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.
There is 1 question to complete.