Question 1

The Excel macro recorder is the fastest way to create macros.

Accepted Answer

A) True 
 B)False

Question 2

To dock and undock the window in the accompanying figure,right-click the window and then click the ____ on the shortcut menu.

Accepted Answer

A)  Location 
B)  Stationary 
C)  Dockable 
D)  Movement 
A)  Location 
B)  Stationary 
C)  Dockable 
D)  Movement

Question 3

The ____ property of the Workbook object contains the folder and drive in which the workbook is stored.

Accepted Answer

A)  Folder 
B)  Path 
C)  Drive 
D)  Location 
A)  Folder 
B)  Path 
C)  Drive 
D)  Location

Question 4

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.
-After Rebecca has done some research into VBA,she discovers that one of the following statements is NOT true.Which statement is false?

Accepted Answer

A)  The interactive tools in the VBA Editor online Help guides you to use the correct syntax by identifying syntax errors as you type them. 
B)  In many cases,program code is password-protected. 
C)  You can use code from another programmer without permission,if you have downloaded it from the Web. 
D)  The Web is a great source of VBA code samples. 
A)  The interactive tools in the VBA Editor online Help guides you to use the correct syntax by identifying syntax errors as you type them. 
B)  In many cases,program code is password-protected. 
C)  You can use code from another programmer without permission,if you have downloaded it from the Web. 
D)  The Web is a great source of VBA code samples.

Question 5

The Excel object you will use to create VBA programs and refer to a defined name in a workbook is ____.

Accepted Answer

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

Question 6

-To open the window in the accompanying figure,first click ____ on the menu bar.

Accepted Answer

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

Question 7

The ____ symbol is used to combine two text strings into a single text string.

Accepted Answer

A)  & 
B)  ^ 
C)  % 
D)  $ 
A)  & 
B)  ^ 
C)  % 
D)  $

Question 8

The item marked 3 in the accompanying figure is the ____ code.

Accepted Answer

A)  Perl 
B)  VBA 
C)  Java 
D)  JavaScript 
A)  Perl 
B)  VBA 
C)  Java 
D)  JavaScript

Question 9

A(n)____________________ procedure is used when you want to create customized properties for the objects in your project.

Accepted Answer

The answer of A(n)____________________ procedure is used when you want...

Question 10

To create sub procedures without using the macro recorder,you need to know some rules of VBA ____.

Accepted Answer

A)  formulas 
B)  statistics 
C)  metrics 
D)  syntax 
A)  formulas 
B)  statistics 
C)  metrics 
D)  syntax

Question 11

When the Visual Basic Editor opens,it usually displays three windows: the Project Explorer window,the Project window,and the Code window._________________________

Accepted Answer

A) True 
 B)False

Question 12

-The application shown in the accompanying figure is the Visual Basic ____.

Accepted Answer

A)  Manager 
B)  Explorer 
C)  Writer 
D)  Editor 
A)  Manager 
B)  Explorer 
C)  Writer 
D)  Editor

Question 13

Every variable is identified by a unique variable ____.

Accepted Answer

A)  referent 
B)  key 
C)  name 
D)  index 
A)  referent 
B)  key 
C)  name 
D)  index

Question 14

A ____ procedure returns a value.

Accepted Answer

A)  sub 
B)  function 
C)  property 
D)  calculation 
A)  sub 
B)  function 
C)  property 
D)  calculation

Question 15

The item marked 1 in the accompanying figure is the ____.

Accepted Answer

A)  Project Explorer 
B)  Code window 
C)  Properties window 
D)  VBA Manager 
A)  Project Explorer 
B)  Code window 
C)  Properties window 
D)  VBA Manager

Question 16

-The window in the accompanying figure displays each property's name in the right column and its value in the left column.

Accepted Answer

A) True 
 B)False

Question 17

____ operators are used to combine expressions within a condition.

Accepted Answer

A)  Conditional 
B)  Logical 
C)  Key 
D)  Concatenation 
A)  Conditional 
B)  Logical 
C)  Key 
D)  Concatenation

Question 18

You can display the value of a variable by typing the variable name preceded by a(n)____ in the Immediate window and pressing the Enter key.

Accepted Answer

A)  caret 
B)  apostrophe 
C)  question mark 
D)  ampersand 
A)  caret 
B)  apostrophe 
C)  question mark 
D)  ampersand

Question 19

To save time when running similar commands in the Immediate Window,press the Up Arrow key to go to the previous command,edit it,and then press the ____ key to run the revised command.

Accepted Answer

A)  Shift 
B)  Run 
C)  Enter 
D)  F12 
A)  Shift 
B)  Run 
C)  Enter 
D)  F12

Question 20

The cell reference of a range is located in the ____ property of the Range object.

Accepted Answer

A)  Where 
B)  CellRef 
C)  Reference 
D)  Address 
A)  Where 
B)  CellRef 
C)  Reference 
D)  Address

The Excel macro recorder is the fastest way to create macros.

To dock and undock the window in the accompanying figure,right-click the window and then click the ____ on the shortcut menu.

The ____ property of the Workbook object contains the folder and drive in which the workbook is stored.

The Excel object you will use to create VBA programs and refer to a defined name in a workbook is ____.

-To open the window in the accompanying figure,first click ____ on the menu bar.

The ____ symbol is used to combine two text strings into a single text string.

The item marked 3 in the accompanying figure is the ____ code.

A(n)____________________ procedure is used when you want to create customized properties for the objects in your project.

To create sub procedures without using the macro recorder,you need to know some rules of VBA ____.

When the Visual Basic Editor opens,it usually displays three windows: the Project Explorer window,the Project window,and the Code window._________________________

-The application shown in the accompanying figure is the Visual Basic ____.

Every variable is identified by a unique variable ____.

A ____ procedure returns a value.

The item marked 1 in the accompanying figure is the ____.

-The window in the accompanying figure displays each property's name in the right column and its value in the left column.

____ operators are used to combine expressions within a condition.

You can display the value of a variable by typing the variable name preceded by a(n)____ in the Immediate window and pressing the Enter key.

To save time when running similar commands in the Immediate Window,press the Up Arrow key to go to the previous command,edit it,and then press the ____ key to run the revised command.

The cell reference of a range is located in the ____ property of the Range object.

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

The Excel macro recorder is the fastest way to create macros.

To dock and undock the window in the accompanying figure,right-click the window and then click the ____ on the shortcut menu.

The ____ property of the Workbook object contains the folder and drive in which the workbook is stored.

The Excel object you will use to create VBA programs and refer to a defined name in a workbook is ____.

-To open the window in the accompanying figure,first click ____ on the menu bar.

The ____ symbol is used to combine two text strings into a single text string.

The item marked 3 in the accompanying figure is the ____ code.

A(n)____________________ procedure is used when you want to create customized properties for the objects in your project.

To create sub procedures without using the macro recorder,you need to know some rules of VBA ____.

When the Visual Basic Editor opens,it usually displays three windows: the Project Explorer window,the Project window,and the Code window._________________________

-The application shown in the accompanying figure is the Visual Basic ____.

Every variable is identified by a unique variable ____.

A ____ procedure returns a value.

The item marked 1 in the accompanying figure is the ____.

-The window in the accompanying figure displays each property's name in the right column and its value in the left column.

____ operators are used to combine expressions within a condition.

You can display the value of a variable by typing the variable name preceded by a(n)____ in the Immediate window and pressing the Enter key.

To save time when running similar commands in the Immediate Window,press the Up Arrow key to go to the previous command,edit it,and then press the ____ key to run the revised command.

The cell reference of a range is located in the ____ property of the Range object.

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