COMP APPS II: 5.4.4 Worksheet Printing Facts

Where are the Excel protect features found?

• On the Review tab.

• On the Home tab.

• On the View tab.

• 1. On the File tab.

  
  

How do you protect an individual worksheet?

• Click Protect Workbook and enter a password.

• Click Protect Sheet and enter a password.

• Click Format Cells and enter a password.

• Click Page Layout and enter a password.

How do you unlock cells in a protected workbook?

• Right-click on the cell, click Format Cells, go to the Number tab, and clear the Locked check box.

• Right-click on the cell, click Format Cells, go to the Alignment tab, and clear the Locked check box.

• Right-click on the cell, click Format Cells, go to the Protection tab, and clear the Locked check box.

• Right-click on the cell, click Format Cells, go to the Font tab, and clear the Locked check box.

How do you protect all worksheets in workbook from being edited?

• Click Protect Workbook then enter password

• Click Protect Sheet then enter password

• All of these

• None of these

How do you modify document’s properties?

• Go to Info tab of Backstage view then click property to edit

• Go to File tab of Backstage view then click property to edit

• All of these

• None of these

How do you select non-default printer?

• Select printer from Printer drop-down list

• Add printer to computer’s configuration first if necessary

• All of these

• None of these

What is default sheet selection for printing?

• Active worksheet

• All worksheets

• All of these

• None of these

How can you print all worksheets in workbook?

• Choose to print all worksheets in workbook

• Choose to print particular selection of cells

• All of these

• None of these

How can you print particular selection of cells?

• Choose to print all worksheets in workbook

• Choose to print particular selection of cells

• All of these

• None of these

What is purpose of protecting individual worksheet?

• To control what content others can modify in worksheet

• To ensure that worksheet will continue to function as intended

• All of these

• None of these