Exam 7: Excell: Developing an Excel Application

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

One way to run a macro is to assign it to a(n) button that is placed directly on the worksheet.

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

Range names must begin with _____.

A digital _____ is like a seal of approval.

Clicking the Edit button in the accompanying figure opens the New Name dialog box in which you can modify the selected defined name.

In VBA, macros are called _____ procedures.

Comments like those in the accompanying figure are often used to _____.

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

The _____ dialog box displays all of the names in the workbook.

The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code.

For cell and range names, names of 5 to 15 characters are considered practical, although names can be up to 255 characters.

Input messages appear as ____________________ next to the active cell.

A(n) _____ certificate is another name for a digital ID.

Which of the following is NOT a valid defined name?

Which of the following tabs in the Data Validation dialog box allows you to set validation criteria?

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?