Term
A Loop will repeat a specified block of code a number of times. |
|
Definition
|
|
Term
Both Types of Do loops rely on a condition to be either True or False |
|
Definition
|
|
Term
A Do While loop tests the condition at the bottom of the loop |
|
Definition
False. A Do While tests the condition at the top of the loop. |
|
|
Term
In a Do Until loop, the code in the loop is executed at least once. |
|
Definition
|
|
Term
The MsgBox Function displays a window to ask the user for input |
|
Definition
False. An InputBox function displays a window to ask the user for input. |
|
|
Term
In an endless loop, the condition that will stop the loop from repeating never becomes true |
|
Definition
|
|
Term
Unlike If statements, loops cannot be nested |
|
Definition
False. Loops can be nested in the same way that If statements can be nested. |
|
|
Term
Using Application.DoEvents prevents the computer from running multiple programs |
|
Definition
False. The Application.DoEvents subroutine allows the computer to process events inside a loop. |
|
|
Term
You can use Ctrl+Alt+Break to pause a program that has entered an endless loop |
|
Definition
|
|
Term
A loop can contain only one statement |
|
Definition
False. A loop can hold many statements. |
|
|
Term
What is another name for the code required to create a loop. |
|
Definition
|
|
Term
What is the main difference between a Do While loop and a Do Until loop? |
|
Definition
The Do Until loop repeats the statements until a certain condition is True, whereas the Do While loop repeats the statements only while a certain condition is met. |
|
|
Term
What keyword marks the end of the block of code contained within a loop? |
|
Definition
|
|
Term
Where is the condition of a Do Until loop tested? |
|
Definition
|
|
Term
What are the three parameters of the InputBox function? |
|
Definition
The three parameters of the InputBox function are the prompt that the user will see, the title bar text, and the optional default entry. |
|
|
Term
What is the purpose of using the Application.DoEvents statement? |
|
Definition
allows the program to process other events while an event procedure is executing. |
|
|
Term
How can you prevent the Application.DoEvents subroutine from allowing a routine to be executed a second time before it is completely finished? |
|
Definition
Disable the button at the beginning of the event procedure that uses the Application.DoEvents subroutine to prevent the user from clicking the button again until the event is completely processed. |
|
|
Term
How many times will the following loop be executed?
intCount = 0 Do While intCount <= 5 intCount = IntCount +1 Loop |
|
Definition
|
|
Term
How many times will the following loop be executed?
intCount = 7 Do While intCount < 5 intCount = IntCount +1 Loop |
|
Definition
This is an infinite loop because the test value (Count) is never changed and, in this code snippet, Count is not even initialized. |
|
|
Term
How many times will the following loop be executed?
intCount = 9 Do intCount = intCount - 1 Loop Until intCount <= 5 |
|
Definition
|
|