Multiple Choice
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"?
A) Workbooks("Hilton Hotels")
B) Excel("Hilton Hotels")
C) Book("Hilton Hotels")
D) Worksheets("Hilton Hotels")
Correct Answer:

Verified
Correct Answer:
Verified
Q25: VBA allows you to create custom dialog
Q26: The _ is a Visual Basic Editor
Q27: The VBA code Worksheets("Raw Data").Change = "Sample
Q28: MATCHING<br>Identify the letter of the choice that
Q29: Hold down the Ctrl Key and press
Q31: The VBA method ActiveWorkbook.SaveAs saves the current
Q32: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB5278/.jpg" alt=" -As shown in
Q33: MATCHING<br>Identify the letter of the choice that
Q34: To step through a sub procedure one
Q35: Formatting a cell or displaying a chart