Exam 22: Programming in Excel With VBA

Which of the following VBA macros can be used in a worksheet formula?

A(n)_____ is a set of programming instructions that performs some action on or with objects.

A(n)_____ is a VBA macro that returns a single value.

When VBA executes a Select Case structure,the structure is exited:

Which of the following describes the process of defining the names of all the variables you are going to use,before you use them in your code?

Excel's VBA macro recorder makes it easy to record user defined functions.

A(n)_____ loop continues to execute until a specified condition has been met.

Which of the following is the simplest type of VBA statement?

A(n)_____ can be used in VBA macro to store such things as values,text,or property settings (such as a font color or alignment).

Which of the following refers to a place used to store a piece of information in Excel?

In VBA,which of the following logical operators performs the function of conjunction on two expressions?

Which of the following options would describe the process of creating variables simply by using them?

When assigning variable names,you can use letters,numbers,and some punctuation characters,but the first character must be a(n)____.

Excel must be running before a VBA macro can be edited using the VB editor.

If the Project Window is not visible in VBE,press the Ctrl + W to open it.

If you want to declare a variable explicitly,you do so using a _____ statement.

In the context of the standard structured decision offered by VBA,the _____ structure is suggested for decisions involving three or more options.

In the Visual Basic Editor (VBE),the _____ window displays a tree diagram that consists of every workbook currently open in Excel.

A macro is a VBA procedure that starts executing the code at the beginning and progresses line by line until it reaches the end.

In which of the following VBA structures,a macro continues to execute the loop until a specified condition is met?