Exam 22: Programming in Excel With VBA

When you record a macro,Excel automatically inserts a VBA _____ to hold the recorded code.

To assign a value to a variable,you must use the _____ operator.

When you want to execute one or more statements conditionally,what VBA structure would you use?

Which of the following is used to declare an explicit variable with VBA code?

When entering code directly into a module,which key should be used to indent some of the lines to make the code easier to read?

Which of the following key(s)will display the Project Explorer window if it is not visible on the VBE Program Window?

Units of VBA code are called subroutines.

A single VBA module can store any number of Sub procedures,Function procedures,and declarations.

If the function you need is not already in Excel,you can write your own _____ using VBA.

Excel and VBA can work with both numbers and text.

Which of the following Excel tools allows you to automate the building and running of complex calculations that are not included in the standard set of Excel functions?

The term _____ refers to repeating a block of statements or code numerous times.

The Select Case structure is used for decisions involving 2 options.

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

All macros reside in code modules of which there are two types: _____ and _____ modules.

Excel and VBA can work with both numbers and text.Text is often referred to as ____.

In a VBA statement,a comment begins with a double quote (").

The _____ is a separate application where you write and edit your Visual Basic macros.

When saving an Excel workbook,any macro that has been created will automatically get saved within the workbook.

The macro recorder is a software tool that lets you record a sequence of commands in Excel and save them as a macro.