Exam 7: Developing an Excel Application

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?

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

Range names can be up to _____ characters.

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

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.

Which of the following is NOT a valid defined name?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Programming language that allows you to create macros

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Property that determines whether or not changes can be made to a cell

-In the accompanying figure,the column labeled "Refers To" is the range's _____.

What are the steps for creating a validation rule?

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.

Each macro must have a unique name that begins with a letter.

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

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.

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?

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

If content is blocked,the _____ located under the Ribbon appears,notifying you that some content was disabled.

Validation rules come into play only during data entry.

In the Allow list box in the Data Validation dialog box,the ____________________ option means that the cell will accept any value entered into the cell.

To open the Data Validation dialog box,click the DATA tab on the Ribbon,and then click $\underline { \text { Authentication } }$ in the Data Tools group._________________________