Question 1

A project might contain several different modules._________________________

Accepted Answer

A) True 
 B)False

Question 2

The object name ____ refers to the cell from which a custom function is being run.

Accepted Answer

A)  ThisWorkbook 
B)  ThisCell 
C)  ActiveCell 
D)  FunctionCell 
A)  ThisWorkbook 
B)  ThisCell 
C)  ActiveCell 
D)  FunctionCell

Question 3

A(n)____ is any element within the Excel working environment,such as a worksheet,macro,or workbook.

Accepted Answer

A)  source 
B)  component 
C)  object 
D)  window 
A)  source 
B)  component 
C)  object 
D)  window

Question 4

If a control structure has more than two possible outcomes,you will have to use a(n)____ control structure.

Accepted Answer

A)  If-Then 
B)  If-Then-Else 
C)  If-Then-ElseIf 
D)  If-Then-If 
A)  If-Then 
B)  If-Then-Else 
C)  If-Then-ElseIf 
D)  If-Then-If

Question 5

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.
-If a window is ____________________,you can drag it to the edge of the screen,and the window will always remain on top,above other windows.

Accepted Answer

The answer of Case-Based Critical Thinking Questions
Case 12-2
Your cousin Rebecca...

Question 6

____ errors occur when the program is executing.

Accepted Answer

A)  Syntax 
B)  Run-time 
C)  Logical 
D)  Type-based 
A)  Syntax 
B)  Run-time 
C)  Logical 
D)  Type-based

Question 7

Attributes such as name,size,or color are known as properties._________________________

Accepted Answer

A) True 
 B)False

Question 8

The Project Explorer window is dockable._________________________

Accepted Answer

A) True 
 B)False

Question 9

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 do you tell Rebecca is the best way to learn VBA?

Accepted Answer

A)  By using the VBA Editor online help 
B)  By using it 
C)  By examining what other programmers are doing 
D)  By reading programming manuals 
A)  By using the VBA Editor online help 
B)  By using it 
C)  By examining what other programmers are doing 
D)  By reading programming manuals

Question 10

The ____ comparison operator compares whether one object is the same as another.

Accepted Answer

A)  = 
B)  + 
C)   
D)  is 
A)  = 
B)  + 
C)   
D)  is

Question 11

Property values containing text strings and numeric values do not need to be placed within quotation marks._________________________

Accepted Answer

A) True 
 B)False

Question 12

The And operator requires only one of two combined logical expressions to be true.

Accepted Answer

A) True 
 B)False

Question 13

-Click ____ on the menu bar and then click Immediate Window to open the window in the accompanying figure.

Accepted Answer

A)  View 
B)  Code 
C)  Display 
D)  Options 
A)  View 
B)  Code 
C)  Display 
D)  Options

Question 14

The following is a type of procedure supported by Visual Basic: ____.

Accepted Answer

A)  function procedure 
B)  attribute procedure 
C)  formula procedure 
D)  settings procedure 
A)  function procedure 
B)  attribute procedure 
C)  formula procedure 
D)  settings procedure

Question 15

The Excel object you will use to create VBA programs and refer to a range in a worksheet is ____.

Accepted Answer

A)  Cell 
B)  Range 
C)  Chart 
D)  Name 
A)  Cell 
B)  Range 
C)  Chart 
D)  Name

Question 16

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 turn off AutoComplete for cell values?

Accepted Answer

A)  Advanced options,Display section 
B)  Advanced options,Editing options section 
C)  Save options 
D)  Formulas options 
A)  Advanced options,Display section 
B)  Advanced options,Editing options section 
C)  Save options 
D)  Formulas options

Question 17

To quickly switch to the Visual Basic Editor,press ____ on your keyboard.

Accepted Answer

A)  Esc + F1 
B)  Ctrl + F7 
C)  Alt + F11 
D)  Enter + F12 
A)  Esc + F1 
B)  Ctrl + F7 
C)  Alt + F11 
D)  Enter + F12

Question 18

The VBA code Set WBook = Workbooks("Smith")stores the WBook variable in the Smith workbook.

Accepted Answer

A) True 
 B)False

Question 19

-The item marked 2 in the accompanying figure is the property ____________________.

Accepted Answer

The answer of  
-The item marked 2 in the...

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Used if a control structure has more than two possible outcomes

Accepted Answer

A) project 
B) object 
C) property 
D) module 
E) comment
F)method
G)variable
H)control structure
I)If-Then-Else
J)If-Then-ElseIf
K)comparison
L)logical 
A) project 
B) object 
C) property 
D) module 
E) comment
F)method
G)variable
H)control structure
I)If-Then-Else
J)If-Then-ElseIf
K)comparison
L)logical

A project might contain several different modules._________________________

The object name ____ refers to the cell from which a custom function is being run.

A(n)____ is any element within the Excel working environment,such as a worksheet,macro,or workbook.

If a control structure has more than two possible outcomes,you will have to use a(n)____ control structure.

____ errors occur when the program is executing.

Attributes such as name,size,or color are known as properties._________________________

The Project Explorer window is dockable._________________________

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 do you tell Rebecca is the best way to learn VBA?

The ____ comparison operator compares whether one object is the same as another.

Property values containing text strings and numeric values do not need to be placed within quotation marks._________________________

The And operator requires only one of two combined logical expressions to be true.

-Click ____ on the menu bar and then click Immediate Window to open the window in the accompanying figure.

The following is a type of procedure supported by Visual Basic: ____.

The Excel object you will use to create VBA programs and refer to a range in a worksheet is ____.

To quickly switch to the Visual Basic Editor,press ____ on your keyboard.

The VBA code Set WBook = Workbooks("Smith")stores the WBook variable in the Smith workbook.

-The item marked 2 in the accompanying figure is the property ____________________.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used if a control structure has more than two possible outcomes

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 12: Expanding Excel With Visual Basic for Applications

A project might contain several different modules._________________________

The object name ____ refers to the cell from which a custom function is being run.

A(n)____ is any element within the Excel working environment,such as a worksheet,macro,or workbook.

If a control structure has more than two possible outcomes,you will have to use a(n)____ control structure.

____ errors occur when the program is executing.

Attributes such as name,size,or color are known as properties._________________________

The Project Explorer window is dockable._________________________

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 do you tell Rebecca is the best way to learn VBA?

The ____ comparison operator compares whether one object is the same as another.

Property values containing text strings and numeric values do not need to be placed within quotation marks._________________________

The And operator requires only one of two combined logical expressions to be true.

-Click ____ on the menu bar and then click Immediate Window to open the window in the accompanying figure.

The following is a type of procedure supported by Visual Basic: ____.

The Excel object you will use to create VBA programs and refer to a range in a worksheet is ____.

To quickly switch to the Visual Basic Editor,press ____ on your keyboard.

The VBA code Set WBook = Workbooks("Smith")stores the WBook variable in the Smith workbook.

-The item marked 2 in the accompanying figure is the property ____________________.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used if a control structure has more than two possible outcomes

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Managing Your Files

Getting Started With Microsoft Office 2010

Filters