Exam 10: Troubleshooting Workbooks and Automating Excel Applications

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 has included a Print Formulas button on the worksheet. This button links to ____.

If you set up the validation rule only, all future data entry in that cell is restricted to the values ____.

The data validation tool restricts data being entered and data already stored in the worksheet.

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. -In order for Seth to allow others to enter data into some of the cells in the worksheet but not others, he should ____.

For optimal password security, Microsoft recommends that you always assign a password to open and view a file. Users who also have permission to modify data should then enter ____.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Error Checking menu

The Excel formula auditing tools help you troubleshoot formula problems by letting you review the ____ of a formula.

In VBA, comments appear in green and start with a(n) ____.

One way to make a workbook easier to use is to automate repetitive or difficult tasks. To do so, you can use ____.

Macro viruses are viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open an infected document. _________________________

MATCHING Identify the letter of the choice that best matches the tools listed above. -Trace Dependents

In addition to a helpful message that appears before users enter data, you can also display a(n) ____ message in a message box if users enter data that violates the cell's validation rule.

A trusted location is usually any computer that is used only by one person.

New or casual Excel users usually prefer to create a macro using the ____, an excellent choice for automating tasks that you perform using the keyboard or mouse.

____ data is input data for which you already know the results.

When printing worksheet formulas, especially for the purposes of documentation, it is very helpful to set the print options to ____.

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 ____.

A #VALUE! error in a worksheet cell indicates ____.

A(n) digital certificate should contain a digital signature, which confirms that the signer created the macro and that the macro has not been changed since its digital certificate was created. _________________________

The formula auditing tool called Evaluate Formula displays the different parts of a nested formula, evaluated in the order the formula is written.