FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The option to protect your workbook is located under the “Page Layout” tab on the Excel Ribbon
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -On the Review tab, see the Protect Workbook icon. If it’s highlighted, then the workbook is protected. If you click on the bottom of a sheet inside your workbook, you will notice that the options to change the workbook structure, such as Insert, Delete, Rename, Move, Copy, Hide, and Unhide sheets are all unavailable.

Detailed explanation-2: -On the worksheet, select just the cells that you want to lock. Bring up the Format Cells popup window again (Ctrl+Shift+F). This time, on the Protection tab, check the Locked box and then click OK. On the Review tab, click Protect Sheet.

Detailed explanation-3: -The ribbon is a set of toolbars at the top of the window in Office programs designed to help you quickly find the commands that you need to complete a task.

There is 1 question to complete.