Exam 7: Developing an Excel Application

-To keep a comment like the one in the accompanying figure on the screen,in the Comments group on the _____ tab,click the Show/Hide Comment button.

To remove workbook protection,click the Unprotect Workbook button in the _____ group on the REVIEW tab.

Defined names are automatically substituted for existing range references in a formula.

A digital ____________________ is often used to identify the author of a workbook that contains macros.

Running a macro means Excel performs a portion of the steps that were recorded.

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?

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

When you $\underline { \text { lock } }$ a workbook,you control the ability users have to make changes to the file._________________________

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

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

A macro ____________________ uses a program's own macro programming language for distribution.

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. -What phrase could Rina use to best describe a digital signature?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Error alert that rejects invalid data but allows you to override the rejection

To view the code of a macro,you need to open the Visual Basic _____.

In VBA,macros are called _____ procedures.

A digital $\underline { \text { certificate } }$ confirms that the macro created by the signer has not been altered since the digital certificate was created._________________________

-Using defined names like those shown in the accompanying figure makes creating and understanding a(n)_____ easier.

A digital _____ is like a seal of approval.

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

A(n)____________________ is a text box that is attached to a specific cell in a worksheet.