Exam 22: Programming in Excel With VBA

What type of strings theoretically can hold as many as 2 billion characters?

Mr.Joseph is the CEO of a leading manufacturing concern.He wanted his name and designation to appear in italics on all the spreadsheets of the company's annual report.Which of the following Excel action should he use to achieve this?

A(n)_____ in VBA is an item available for you to control in your code.

A variable in VBA is an item available for you to control in your code.

Which of the following tools enables users to view and edit a VBA macro?

The _____ window is most useful for executing VBA statements directly and for debugging code.

A macro is a set of actions recorded or written by a user.

With which of the following would you begin a comment line?

You can use VBA to create your own worksheet functions.

When typing code directly into a VBA macro,the Ctrl key is used to indent some of the lines to make the code easier to read.

The Visual Basic Editor is used to record a sequence of commands in Excel to save them in a macro.

A(n)_____ is a set of actions recorded or written by a user.

When you're working in the Visual Basic Editor (VBE),each Excel workbook that's open is known as a(n)____.

Which of the following statements is true about a macro in Excel?

In VBA,dates and times are placed between two:

In VBA,which of the following symbols represents the exponentiation operator?

Which of the following is a VBA macro that returns a single value?

_____ extends and customizes Excel,allowing you to do things that Excel itself is not able to do,such as calculating values in cells based on user input values.

To use VBA in an Excel worksheet,you must purchase a separate plug-in module.

Which of the following is a set of Excel actions recorded or written by a user?