Exam 12: Expanding Excel With Visual Basic for Applications

In the function user = InputBox("Enter your username" ,"Log In"),the words "Enter your username" comprise the ____.

The Display property of the Worksheet object determines if a worksheet is hidden._________________________

Closing a workbook or printing a worksheet's contents are examples of ____.

Logical operators are used to combine expressions within a(n)condition._________________________

The ____ command is always the last line in a sub procedure and tells Excel to stop running the macro.

All of the following are properties of the Range object EXCEPT ____.

One important use of the Visual Basic Editor is to manage your projects.

The ____ control structure allows you to repeat a series of commands a set number of times.

To run an entire sub procedure,press the ____ key.

To refer to a specific object in a(n)____________________,use this syntax: object_collection(id).

A(n)____________________ is a statement that describes the behavior or purpose of a procedure.

The macro recorder writes the most efficient code and records only those commands and actions you want in the finished project.

Explain which of the following screen elements are part of the Excel window,the workbook window,and the worksheet: formula bar,ScreenTips,chart element names on hover,horizontal and vertical scroll bars,row and column headers,sheet tabs,and gridlines.

The item marked 4 in the accompanying figure is the ____.

The ____ control structure repeats a series of commands as long as a particular condition is true.

Visual Basic supports ____ kinds of procedures.

Comments are usually displayed by the editor in ____ font.

-In the window in the accompanying figure,to view the list of properties in alphabetical order and by category,you can click the tabs at the top of the window.

To open the Code window to the contents of a specific module,select the module in the Project Explorer window and then press the ____ key.

To break a line to make your code easier to read,type a space followed by the ____ character at the end of the line.