Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-In this control structure,one set of commands is run if the condition is true and a different set of commands is run if the condition is false

Accepted Answer

The If-Then-Else structure is specifically described as having one set of commands run if a condition is true, and a different set of commands run if the condition is false.

Question 2

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-An action that can be performed on an object

Accepted Answer

A method is a set of instructions or actions that can be performed on an object.

Answer: G 
 A variable is a value or property that can be changed.

Answer: K 
 A comparison is a way of evaluating whether two values are equal or not.

Answer: H 
 A control structure is a set of programming statements that control the flow of execution of a program.

Answer: I 
 If-Then-Else is a control structure that allows a program to execute one set of code if a condition is true, and another set of code if the condition is false.

Answer: J 
 If-Then-ElseIf is a control structure that allows a program to execute a different set of code depending on the result of multiple conditionals.

The remaining choices do not match the given phrase or definition.

Question 3

Explain which of the following screen elements are part of the Excel window,the workbook window,and the worksheet: formula bar,ScreenTips,chart element names on hover,horizontal and vertical scroll bars,row and column headers,sheet tabs,and gridlines.

Accepted Answer

The answer of Explain which of the following screen elements...

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A collection of VBA macros

Accepted Answer

A collection of VBA macros is referred to as a module in VBA.

Question 5

What are the seven comparison operators in VBA?

Accepted Answer

The answer of What are the seven comparison operators in...

Question 6

Is it necessary to specify a data type or declare a variable in Visual Basic? If you do not,what happens? What is good programming practice in regard to specifying a data type and declaring a variable?

Accepted Answer

The answer of Is it necessary to specify a data...

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Any element within the Excel working environment

Accepted Answer

Object refers to any element within the Excel working environment, such as a worksheet, chart, or cell.

(Note: None of the other choices specifically refer to an element within the Excel working environment.)

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Used if a control structure has more than two possible outcomes

Accepted Answer

The If-Then-ElseIf control structure is used when there are more than two possible outcomes in decision-making within programming.

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-= and <> and examples of this kind of operator

Accepted Answer

Comparison operators are used to compare values and return a boolean (true/false) result. Answer: L Logical operators are used to combine multiple conditions and return a boolean (true/false) result based on their truth values. Examples of comparison operators: <, >, <=, >=, ==, != Examples of logical operators: && (and), || (or), ! (not)

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A named element that can be used to store and retrieve information

Accepted Answer

A variable is a named element that can store and retrieve information.

Quiz 12: Expanding Excel With Visual Basic for Applications

MATCHING Identify the letter of the choice that best matches the phrase or definition. -In this control structure,one set of commands is run if the condition is true and a different set of commands is run if the condition is false

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An action that can be performed on an object

Explain which of the following screen elements are part of the Excel window,the workbook window,and the worksheet: formula bar,ScreenTips,chart element names on hover,horizontal and vertical scroll bars,row and column headers,sheet tabs,and gridlines.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of VBA macros

What are the seven comparison operators in VBA?

Is it necessary to specify a data type or declare a variable in Visual Basic? If you do not,what happens? What is good programming practice in regard to specifying a data type and declaring a variable?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Any element within the Excel working environment

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used if a control structure has more than two possible outcomes

MATCHING Identify the letter of the choice that best matches the phrase or definition. -= and <> and examples of this kind of operator

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A named element that can be used to store and retrieve information