Question 1

Input messages appear as ____________________ next to the active cell.

Accepted Answer

The answer of Input messages appear as ____________________ next to...

Question 2

-You can use the Name Manager dialog box,shown in the accompanying figure,to create a defined name.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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) A) and C)
F) A) and D)

Question 5

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

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell

Accepted Answer

A)  Stop
B)  Warning
C)  Information
D)  locked
E)  macroF) VBAG) defined nameH) input messageI) validation ruleJ) digital certificateK) H) and J)
L) E) and G)

Question 7

The _____ Center is a central location for all the security settings in Office.

Accepted Answer

A)  Secure
B)  Security
C)  Trust
D)  ProtectionE) C) and D)
F) B) and D)

Question 8

Range names must begin with _____.

Accepted Answer

A)  a letter or an underscore
B)  a number
C)  a hash tag
D)  an asteriskE) B) and C)
F) A) and B)

Question 9

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

Accepted Answer

A)  validation
B)  concatenation
C)  security
D)  indexE) A) and B)
F) A) and C)

Question 10

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 invalid data,but...

Question 11

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 12

After the comments,in VBA code the next item is the _____ of the macro.

Accepted Answer

A)  module
B)  body
C)  procedure
D)  commandE) B) and C)
F) A) and D)

Question 13

A _____ can be destructive and can modify or delete files that may not be recoverable.

Accepted Answer

A)  digital signature
B)  macro virus
C)  comment virus
D)  micro virusE) None of the above
F) A) and B)

Question 14

Protecting the _____ prohibits users from renaming,deleting,hiding,or inserting worksheets.

Accepted Answer

A)  skeleton
B)  structure
C)  format
D)  locationE) B) and C)
F) None of the above

Question 15

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) VBAG) defined nameH) input messageI) validation ruleJ) digital certificateK) C) and I)
L) E) and G)

Question 16

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

Accepted Answer

A)  HTML
B)  Java
C)  VBA
D)  PerlE) C) and D)
F) B) and C)

Question 17

Cell and range$\underline { \text { references } }$ do not indicate what data is stored in those cells._________________________

Accepted Answer

A) True 
 B)False

Question 18

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) B) and D)
F) None of the above

Question 19

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

Accepted Answer

The answer of One way to ensure that correct data...

Question 20

_____ messages appear as ScreenTips next to the active cell.

Accepted Answer

A)  Value
B)  Input
C)  Key
D)  UserE) C) and D)
F) B) and C)

Exam 7: Developing an Excel Application

A _____ can be destructive and can modify or delete files that may not be recoverable.

Correct AnswerverifiedShow Answer

Input messages appear as ____________________ next to the active cell.

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

-You can use the Name Manager dialog box,shown in the accompanying figure,to create a defined name.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Protecting the _____ prohibits users from renaming,deleting,hiding,or inserting worksheets.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The _____ Center is a central location for all the security settings in Office.

Correct AnswerverifiedShow Answer

Cell and range references ‾\underline { \text { references } } references ​ do not indicate what data is stored in those cells._________________________

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Appears when the cell becomes active and can be used to specify the type 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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Range names must begin with _____.

Correct AnswerverifiedShow Answer

After the comments,in VBA code the next item is the _____ of the macro.

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

_____ messages appear as ScreenTips next to the active cell.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

Cell and range $\underline { \text { references } }$ do not indicate what data is stored in those cells._________________________

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