Question 1

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.

Accepted Answer

A)   Custom
B)   Text Length 
C)   Any Value
D)   Specified TextE) C) and D)
F) All of the above

Question 2

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

Accepted Answer

The answer of A(n)____________________ is a series of stored commands...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A)   ensure
B)   protect 
C)   secure
D)   sealE) A) and B)
F) A) and C)

Question 5

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

Accepted Answer

The answer of A(n)____________________ is a text box that is...

Question 6

In VBA,macros are called _____ procedures.

Accepted Answer

A)   body
B)   sub 
C)   commented
D)   modularE) None of the above
F) A) and B)

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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?

Accepted Answer

A)   Who the author of the file is 
B)   Whether the information in the file is correct 
C)   Whether the macros in the workbook will produce accurate results 
D)   Whether the macro will perform as expectedE) None of the above
F) A) and B)

Question 10

Validation rules come into play only during data entry.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A)   Universal
B)   Personal 
C)   Microsoft
D)   XPE) None of the above
F) A) and B)

Question 12

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.

Accepted Answer

A)   syntax
B)   run-time 
C)   logic
D)   baselineE) None of the above
F) A) and B)

Question 13

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

Accepted Answer

A)   Information
B)   Stop 
C)   Security
D)   WarningE) None of the above
F) All of the above

Question 14

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

Accepted Answer

A)   Name Manager
B)   Ranges 
C)   Definition
D)   TermsE) A) and B)
F) A) and C)

Question 15

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

Accepted Answer

A) True 
 B)False

Exam 7: Developing an Excel Application

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

In VBA,macros are called _____ procedures.

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Validation rules come into play only during data entry.

Correct Answer
verified

Exam 7: Developing an Excel Application

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

In VBA,macros are called _____ procedures.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Validation rules come into play only during data entry.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified