Exam 12: Expanding Excel With Visual Basic for Applications

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. -Where in the Excel Options dialog box would Chantal find the setting to change the default location for Excel workbook files?

To open the Visual Basic Editor you must first click the Macros button in the Code group on the Developer tab.

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. -If Chantal hides a screen element that is part of the worksheet,where is that screen element hidden?

-The item marked ____________________ in the accompanying window is the Properties window.

VBA allows you to create custom dialog boxes.

The ____ is a Visual Basic Editor window.

The VBA code Worksheets("Raw Data").Change = "Sample Data" changes the name of the "Raw Data" worksheet to "Sample Data"._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A named element that can be used to store and retrieve information

Hold down the Ctrl Key and press the Home key to go to cell A1 in the worksheet._________________________

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. -What would you tell Rebecca to use if she wants to refer to a workbook that is named "Hilton Hotels"?

The VBA method ActiveWorkbook.SaveAs saves the current workbook.

-As shown in the accompanying figure,you can run single command lines in the Visual Basic Editor ____________________ window.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Operator used to combine expressions within a condition

To step through a sub procedure one line at a time,click in the sub procedure code and then repeatedly press the ____ key.

Formatting a cell or displaying a chart are examples of ____ procedures in Visual Basic.

Procedure names can be up to ____ characters in length.

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. -Which of the following is NOT a true statement you would make to Rebecca?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of VBA macros

The ____ operator requires that only one of two (or more)expressions be true.

____ errors can be the most difficult to resolve.