FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

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.
A
Cell protection
B
Range Finder
C
The formula checker
D
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: -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: -When you protect a worksheet, unlocked areas can still be changed. Data can be consolidated from different workbooks in one workbook. Cell and range names can have spaces. The Excel Custom Views features allows you to create several views of a worksheet without having to create separate sheets.

There is 1 question to complete.
Previous
Next