FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
When building a worksheet for novice users, you should ____ the cells in the worksheet that you do not want changed, such as cells that contain text or formulas.
A
hide
B
protect
C
code
D
delete
Explanation: 

Detailed explanation-1: -Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect. Right click and choose Format cells again. Go to the protection tab and check Locked option and click Ok.

Detailed explanation-2: -Select the cells you want to lock. On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window. On the Protection tab, select the Locked check box, and then click OK to close the popup.

Detailed explanation-3: -A template is a pre-designed worksheet which could be modified to suit users’ needs. The Excel template contains predefined formulas and custom formatting. This saves a lot of time and effort while working on a new project.

There is 1 question to complete.