Exam 7: Developing an Excel Application

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? 

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

In VBA,macros are called _____ procedures.

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

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.

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

A(n)____________________ is a series of stored commands that can be run whenever you need to perform a task.

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

In the Allow list box in the Data Validation dialog box,the _____ option means that the cell will accept only text of a specified number of characters.

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

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

Validation rules come into play only during data entry.

The Stop alert prevents an entry from being stored in the cell.

The _____ alert accepts the invalid data but still allows you to cancel the data entry.

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