Exam 10: Troubleshooting Workbooks and Automating Excel Applications

____ is a program that is attached to a file and runs when you open the file. It can harm your computer by changing program settings or deleting hard disk files.

The following types of documentation are helpful in an Excel application: ____.

When you choose ____, Excel disables all macros and security alerts about macros in documents that are not stored in a trusted location.

When you choose ____, Excel disables all macros but retains security alerts about macros in documents that are not stored in a trusted location.

You can use up to three levels of security and protection to control who can access and change your Excel data. Please describe two of the three levels and how you access each of them.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Circular References

Which of the following is NOT one of the three tabs in the Data Validation dialog box?

MATCHING Identify the letter of the choice that best matches the tools listed above. -Remove Arrows

Case 10-2 As part of his new job, Seth has created a Projected Income worksheet for his company. He wants to prohibit users from changing the formulas in the Projected Income worksheet, while allowing them to change values such as unit sales and unit price. Seth has also imported a worksheet named Sales History, which contains sales information for sunglasses for the last year. -Seth is thinking about hiding all cells with formulas in his Projected Income worksheet. He thinks this will definitely protect them from being changed. You would advise him not to hide all of these cells because ____.

Case 10-1 Elianna has put together the Projected Income worksheet above. She is finalizing the worksheet for a presentation to her company's board of directors. When needed, please refer to the figure above as you answer the questions below. -Elianna is ready to edit one of the macros in the worksheet. To do this, she opens the ____.