Exam 7: Excel 3: Developing an Excel Application

A protected sheet can always be unprotected, but you can also require users to enter a(n)____________________ before the protection is removed.

The Name dialog box lists all of the names currently defined in the workbook, including Excel table names. _________________________

Each sub procedure in VBA begins with the keyword "Sub" followed by the name of the sub procedure and a set of _____.

The _____ Macro workbook is a hidden workbook opened whenever you start Excel, making its macros available anytime you use Excel.

In addition to referring to cells by their cell references, it is easier to remember where different data is stored by assigning a meaningful, descriptive ____________________ to each cell or range.

When Excel creates a macro button, the Assign Macro dialog box opens with the button's default name showing. _________________________

Case-Based Critical Thinking Questions Case 7-1 Ted knows that macros can be helpful to him in his work with Excel spreadsheets, but he also knows they have their hazards, so he comes to you for guidance about what kind of security settings he should put in place, and at what times. As Ted gets more comfortable with Excel, he thinks that he might be able to decide whether or not to run a macro on a case-by-case basis. What should his option be in the Trust Center?

If a _____ error appears when you run a macro that has worked in the past, some part of the macro code no longer makes sense to Excel.

After the comments, in VBA code the next item is the _____ of the macro.

Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets.

A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was created. _________________________

When you _____ a workbook, you control the ability users have to make changes to the file.

Any blanks or parentheses in row or column labels are changed to underscore characters in defined names. _________________________

Case-Based Critical Thinking Questions Case 7-2 Rina has just completed some coursework in Excel application writing and wants to begin developing her own macros to share more widely. She knows that she has to learn more about digital signatures in order to make her plan a reality. Which of the following can Rina tell when she opens a digitally signed file?

Case-Based Critical Thinking Questions Case 7-3 Juan tells you that your work in Excel will go a lot faster if you start using defined names instead of cell and range addresses. You believe him but you have been frustrated by defined names in the past because you did not know the rules for naming them and you have run into errors as a result. Juan offers to help you. Which of the following is a true statement Juan can make about defined names as he is explaining the rules to you?

A digital _____ is like a seal of approval.

A _____ can be destructive and can modify or delete files that may not be recoverable.

Usually, you will want to protect a worksheet but leave some cells _____.

To create a macro, you can enter a series of commands in the _____ programming language.

Even when the worksheet is unprotected, the locked property determines whether or not changes can be made to a given cell.