Objective 5.3 Questions

1.	Which of the following macro security levels prompts the user to choose whether potentially unsafe macros can be run? Very High High Medium Low
2.	One of your customers has created an Excel spreadsheet. The sheet has a number of cells in which data can be entered and several calculation cells that perform calculations on the entered data. The customer wants to protect only the cells that contain the formulas so that users of the spreadsheet can enter data but not alter the formulas. What should you tell him? The user must unlock all cells on the spreadsheet, lock only the formula cells, and then protect the document so that users cannot select locked cells. The user must lock the formula cells, and then protect the document so that users cannot select locked cells. The user must format the cells with formulas to be hidden. The user should lock the cells with formulas, and then enable the Read-Only attribute for the spreadsheet file.

Answers

1.

Correct Answers: C Incorrect The Medium macro security level prompts the user to choose whether potentially unsafe macros can be run. Incorrect The Medium macro security level prompts the user to choose whether potentially unsafe macros can be run. Correct The Medium macro security level prompts the user to choose whether potentially unsafe macros can be run. Incorrect The Medium macro security level prompts the user to choose whether potentially unsafe macros can be run.

2.

Correct Answers: A Correct This method protects the cells with formulas while allowing users to enter data into the other cells. Incorrect The user must first unlock all cells. By default, all cells in a spreadsheet are locked. Incorrect If the user hides the formula cells, users cannot see the calculations. Incorrect Enabling the Read-Only attribute does not protect locked cells.