Exam 12: Expanding Excel With Visual Basic for Applications

The VBA code ____ refers to the collection of cells in the cell range,A1:B10.

The Project ____ is a window in the Visual Basic Editor that displays a hierarchical list of all currently opened projects and their contents.

In a(n)____________________ control structure,one set of commands is run if the condition is true and a different set of commands is run if the condition is false.

What are the seven comparison operators in VBA?

All of the following are attributes of an object except ____.

The VBA code ActiveWorkbook.____:="broadband" protects the current workbook,using the password "broadband".

When you want to view the VBA macro code associated with any item in Project Explorer,you use the ____ window.

To test several conditions in a macro,using the VBA ____ statement is recommended.

To determine whether an expression used in a condition is true or false,the expression needs to contain a(n)condition operator._________________________

Is it necessary to specify a data type or declare a variable in Visual Basic? If you do not,what happens? What is good programming practice in regard to specifying a data type and declaring a variable?

To edit a VBA macro,you need to use the Visual Basic ____.

Case-Based Critical Thinking Questions Case 12-1 Chantal is building a kiosk-based Excel application.She wants to make some modifications to the screen elements in order to keep users from being distracted by parts of the application that are irrelevant to her application.She turns to Jason for guidance as she knows he built a similar solution earlier this year. -Chantal has decided to hide the worksheet gridlines and the vertical scroll bar.What does Jason tell her to use to do this?

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. -Rebecca would like to make a reference to the second open Excel workbook window.What do you tell her is the syntax for this?

VBA is a(n)object-linked programming language._________________________

A(n)____ is a collection of VBA macros.

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

When you hide screen elements that are part of the worksheet,they will be hidden in that worksheet only.

____________________ is a file format developed by Adobe Systems that supports all of the elements of a printed document but in an electronic format that is easily shared.

A control ____________________ is a series of commands that evaluates conditions in your program and then directs the program to perform certain actions based on the status of those conditions.

-As you enter a command in the Project window shown in the accompanying figure,its effects are immediately applied to that workbook._________________________