Question 1

A project cannot contain more than one module.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

A(n)____ is a named element in a program that can be used to store and retrieve information.

Accepted Answer

A)  object 
B)  component 
C)  key 
D)  variable 
A)  object 
B)  component 
C)  key 
D)  variable

Question 4

In VBA,a project consists of a single macro in one worksheet.

Accepted Answer

A) True 
 B)False

Question 5

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.
-Jason explains to Chantal that Excel screen elements fall into general categories.Which of the following is NOT one of the categories into which the screen elements fall?

Accepted Answer

A)  taskbar 
B)  window 
C)  workbook 
D)  worksheet 
A)  taskbar 
B)  window 
C)  workbook 
D)  worksheet

Question 6

Comments must begin with a(n)____.

Accepted Answer

A)  apostrophe 
B)  comma 
C)  period 
D)  double quotation mark 
A)  apostrophe 
B)  comma 
C)  period 
D)  double quotation mark

Question 7

Macro buttons on the Quick Access Toolbar can be customized to display unique icons.

Accepted Answer

A) True 
 B)False

Question 8

All objects have properties.

Accepted Answer

A) True 
 B)False

Question 9

To go to cell A1 in a worksheet,hold down the ____ key and press the Home key.

Accepted Answer

A)  Alt 
B)  Enter 
C)  Ctrl 
D)  Esc 
A)  Alt 
B)  Enter 
C)  Ctrl 
D)  Esc

Question 10

Procedure names cannot contain ____.

Accepted Answer

A)  spaces 
B)  numbers 
C)  letters 
D)  any of the above 
A)  spaces 
B)  numbers 
C)  letters 
D)  any of the above

A project cannot contain more than one module.

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

A(n)____ is a named element in a program that can be used to store and retrieve information.

In VBA,a project consists of a single macro in one worksheet.

Comments must begin with a(n)____.

Macro buttons on the Quick Access Toolbar can be customized to display unique icons.

All objects have properties.

To go to cell A1 in a worksheet,hold down the ____ key and press the Home key.

Procedure names cannot contain ____.

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 cannot contain more than one module.

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

A(n)____ is a named element in a program that can be used to store and retrieve information.

In VBA,a project consists of a single macro in one worksheet.

Comments must begin with a(n)____.

Macro buttons on the Quick Access Toolbar can be customized to display unique icons.

All objects have properties.

To go to cell A1 in a worksheet,hold down the ____ key and press the Home key.

Procedure names cannot contain ____.

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