Exam 22: Programming in Excel With VBA

The quickest way to activate the VBE is to press Ctrl + F11 when Excel is active.

Which of the following would be considered a named element whose value would not change during the execution of a procedure?

Which of the following is true about the Immediate window?

A variable is the simplest type of VBA statement.

Which of the following is a VBA statement that allocates the result of an expression to a variable or an object?

Which of the following terms refers to repeating a block of statements or code numerous times?

Which of the following is true about the way a macro works?

Which of the following statements is VBA's most important control structure?

You can customize the Excel toolbars with your own buttons that execute the macros you write.

Which of the following Excel tools allows you to record a sequence of commands in Excel and save them?

_____ is a type of code which consists of one or more statements that you provide to VBA.

Some Visual Basic for Applications (VBA)procedures,such as ____,always start at the code's beginning and progress line by line to the end,never deviating from this top-to-bottom flow.

Excel and Visual Basic for Applications (VBA)can work with both numbers and text.Text is often referred to as a(n)____.

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

Which of the following is a programming language that includes build-in commands that mimic the functionality available from menus and dialog boxes within an application?

Which of the following data type uses 1 byte per character and whose range of values varies?

A(n)_____ is the simplest type of VBA statement.

Which VBA loop structure is controlled by a counter variable,which starts at one value and stops at another value?

While entering a VBA code directly,to continue a single line of code from one line to the next,end the first line with:

Dan was making a science project.He wanted to automate the two steps of adding a background theme to the cells and then printing the worksheet.Which of the following Excel actions can help Dan achieve this?