Question 1

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) B) and C)
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

Even if a sheet is protected,you can limit the user to selecting only unlocked cells,or allow the user to select any cell in the worksheet.

Accepted Answer

A) True 
 B)False

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Error alert that prevents you from storing the data in the cell

Accepted Answer

A)  Stop
B)  Warning
C)  Information
D)  locked
E)  macroF) Excel applicationG) defined nameH) input messageI) validation ruleJ) digital certificateK) digital signatureL) VBAM) A) and B)
N) E) and G)

Question 5

You can delete or edit a macro by opening the Edit dialog box,selecting the macro from the list,and then clicking the appropriate button._________________________

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The answer of The ____________________ alert by default rejects the...

Question 7

What are the steps for creating a validation rule?

Accepted Answer

In the Data Tools group on the Data tab,...

Question 8

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

Accepted Answer

The answer of In the Allow list box in the...

Question 9

When the Ribbon is minimized,only the Quick Access Toolbar and the tab names are displayed.

Accepted Answer

A) True 
 B)False

Question 10

Each macro must have a unique name.

Accepted Answer

A) True 
 B)False

Question 11

You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the ____ tab.

Accepted Answer

A)   Insert
B)   Developer
C)   Layout
D)   MacroE) A) and D)
F) B) and D)

Question 12

Case-Based Critical Thinking Questions
Case 8-2
Renee 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 is a true statement about digital signatures?

Accepted Answer

A)   Adding a digital signature is the first step before you distribute a file.
B)   A digital signature is often used to identify the author of a workbook that contains macros.
C)   Before you can add a digital ID to a workbook,you need to obtain a digital signature.
D)   Digital certificates are usually issued by Microsoft.E) A) and B)
F) A) and C)

Question 13

Any blanks or parentheses in row or column labels are changed to underscore characters in defined names._________________________

Accepted Answer

A) True 
 B)False

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Confirms that a macro or document has not been altered

Accepted Answer

A)  Stop
B)  Warning
C)  Information
D)  locked
E)  macroF) Excel applicationG) defined nameH) input messageI) validation ruleJ) digital certificateK) digital signatureL) VBAM) B) and C)
N) J) and L)

Question 15

To open the Data Validation dialog box,click the Data tab on the Ribbon,and then click Authentication in the Data Tools group._________________________

Accepted Answer

A) True 
 B)False

Question 16

Even when the worksheet is unprotected,the locked property determines whether or not changes can be made to a given cell.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  Stop
B)  Warning
C)  Information
D)  locked
E)  macroF) Excel applicationG) defined nameH) input messageI) validation ruleJ) digital certificateK) digital signatureL) VBAM) F) and J)
N) C) and J)

Question 18

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.

Accepted Answer

A)   aspect
B)   type
C)   format
D)   castE) C) and D)
F) A) and B)

Question 19

-The most direct way to create defined names like the kind shown in the accompanying figure is to use the ____ box on the formula bar.

Accepted Answer

A)   Definition
B)   Name
C)   Term
D)   LabelE) A) and B)
F) B) and C)

Question 20

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.

Accepted Answer

A)   Review
B)   Format
C)   Options
D)   HomeE) A) and D)
F) B) and C)

Exam 8: Developing an Excel Application

Any blanks or parentheses in row or column labels are changed to underscore characters in defined names._________________________

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

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

Correct Answer
verified

You can delete or edit a macro by opening the Edit dialog box,selecting the macro from the list,and then clicking the appropriate button._________________________

Correct Answer
verified

To open the Data Validation dialog box,click the Data tab on the Ribbon,and then click Authentication in the Data Tools group._________________________

Correct Answer
verified

Even when the worksheet is unprotected,the locked property determines whether or not changes can be made to a given cell.

Correct Answer
verified

Even if a sheet is protected,you can limit the user to selecting only unlocked cells,or allow the user to select any cell in the worksheet.

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Confirms that a macro or document has not been altered

Correct Answer
verified

What are the steps for creating a validation rule?

Correct Answer
verified
In the Data Tools group on the Data tab,...
View Answer

-The most direct way to create defined names like the kind shown in the accompanying figure is to use the ____ box on the formula bar.

Correct Answer
verified

Each macro must have a unique name.

Correct Answer
verified

When the Ribbon is minimized,only the Quick Access Toolbar and the tab names are displayed.

Correct Answer
verified

Correct Answer
verified

You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the ____ tab.

Correct Answer
verified

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.

Correct Answer
verified

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Error alert that prevents you from storing the data in the cell

Correct Answer
verified

Exam 8: Developing an Excel Application

Any blanks or parentheses in row or column labels are changed to underscore characters in defined names._________________________

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

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

Correct AnswerverifiedShow Answer

You can delete or edit a macro by opening the Edit dialog box,selecting the macro from the list,and then clicking the appropriate button._________________________

Correct AnswerverifiedShow Answer

To open the Data Validation dialog box,click the Data tab on the Ribbon,and then click Authentication in the Data Tools group._________________________

Correct AnswerverifiedShow Answer

Even when the worksheet is unprotected,the locked property determines whether or not changes can be made to a given cell.

Correct AnswerverifiedShow Answer

Even if a sheet is protected,you can limit the user to selecting only unlocked cells,or allow the user to select any cell in the worksheet.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Confirms that a macro or document has not been altered

Correct AnswerverifiedShow Answer

What are the steps for creating a validation rule?

Correct AnswerverifiedIn the Data Tools group on the Data tab,...View AnswerShow Answer

-The most direct way to create defined names like the kind shown in the accompanying figure is to use the ____ box on the formula bar.

Correct AnswerverifiedShow Answer

Each macro must have a unique name.

Correct AnswerverifiedShow Answer

When the Ribbon is minimized,only the Quick Access Toolbar and the tab names are displayed.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the ____ tab.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Error alert that prevents you from storing the data in the cell

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
In the Data Tools group on the Data tab,...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified