Exam 12: Expanding Excel With Visual Basic for Applications

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of macros,worksheets,data entry forms,etc. ,that comprise a customized application

You can define exactly what type of data can be stored in a variable with the ____ command.

The Excel object you will use to create VBA programs and refer to a chart embedded within a worksheet is ____.

Since Visual Basic for Applications is an application-specific language,Excel and Access use different variations of VBA.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An object's attribute that defines one of its characteristics

Use ____________________ lines to explain the purpose of the macro and how it works without affecting the code.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -= and <> and examples of this kind of operator

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Series of commands that evaluates conditions and then directs the program to perform certain actions based on the status of those conditions

Case-Based Critical Thinking Questions Case 12-2 Your cousin Rebecca knows that you are an experienced VBA programmer so she turns to you for some general guidance when she wants to get started as a programmer herself. -The ____________________ Explorer is a window in the Visual Basic Editor that displays a hierarchical list of all currently opened projects and their contents.

The ____ function returns the value FALSE if the logical expression is true.

In the function user = InputBox("Enter your username" ,"Log In"),"user" is the prompt._________________________

The object name ____ refers to the workbook containing the macro code that is currently running.

Excel macros are written in the programming language ____.

Within each project are various items called ____.

The MsgBox function is similar to the InputBox function except that the MsgBox function does not contain a text box for the user to enter values.

When you enter the name and description of a project,you are actually modifying two of its ____.

The object name ____ refers to the worksheet currently being displayed in the workbook.

If a control structure has several conditions,you need to use a(n)____________________ control structure to run commands in response to each condition.

All procedures are considered public unless specified as Private._________________________

To hide a macro's actions as it runs,insert the command Application.ScreenUpdating = ____________________ at the beginning of the sub procedure.