FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What command limits structural changes, such as adding, deleting, ormoving sheets, that can be made in a workbook?
A
Protect Workbook
B
Protect Sheet
C
Share
D
Protection
Explanation: 

Detailed explanation-1: -Select File > Info. Select the Protect Workbook box and choose Encrypt with Password. Enter a password in the Password box, and then select OK. Confirm the password in the Reenter Password box, and then select OK.

Detailed explanation-2: -In the upper-right corner of the Excel window, click Close. . On the File tab, click Exit.

Detailed explanation-3: -A workbook is a spreadsheet program file that you create in Excel. A workbook contains one or more worksheets. A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data. The cells are organized into columns and rows. A worksheet is always stored in a workbook.

Detailed explanation-4: -You can protect Excel workbooks at the file level or at the worksheet level. There are three levels of password protection in Excel: password protection to open a file, password protection to change data, or password protection for changing the file’s structure, such as adding, deleting, or hiding worksheets.

There is 1 question to complete.