Exam 7: Developing an Excel Application

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 an example of a valid defined name Juan can provide to you?

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

Sometimes when you build a worksheet for other users,you may decide to add a(n)_____ message to a cell even if you do not validate the data in that cell.

Any blanks or parentheses in a row or column label will be changed to _____ in defined names.

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

The ____________________ alert,by default,rejects the invalid data,but allows you to override the rejection.

In the Allow list box in the Data Validation dialog box,the _____ option means that the cell will accept only integers.

One way to ensure that correct data is entered into a cell or range is to use the Excel data _____ feature.

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. -Based on what she has learned,which of the following would Rina say is a true statement about digital signatures? 

An input message appears when the cell becomes active,and can be used to specify the _____ of data the user should enter in that cell.

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

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. -After a year of work,Ted is taking coursework to become a VBA programmer.He is working on developing an application that contains macros.Which should his option be in the Trust Center? 

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

The following are Excel-supported error alert types: _____.

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

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.

You use the _____ tab in the Data Validation dialog box to enter the validation rules for the active cell.

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

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

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