Question 1

Each cell can have at most three validation rules.

Accepted Answer

A) True 
 B)False  False

Question 2

In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept only times.

Accepted Answer

A)  Chronology 
B)  Clock 
C)  Time 
D)  Calendar 
A)  Chronology 
B)  Clock 
C)  Time 
D)  Calendar C

Question 3

Most ____ are not harmful and do not affect data in any way.

Accepted Answer

A)  viruses 
B)  macro viruses 
C)  Trojan horses 
D)  all of the above 
A)  viruses 
B)  macro viruses 
C)  Trojan horses 
D)  all of the above B

Question 4

-The red triangle (that has an arrow pointing to it)in the accompanying figure indicates that a given cell does not have a comment.

Accepted Answer

A) True 
 B)False

Question 5

Using defined names like the kind shown in the accompanying figure makes creating and understanding a(n)____ easier.

Accepted Answer

A)  index 
B)  log 
C)  formula 
D)  all of the above 
A)  index 
B)  log 
C)  formula 
D)  all of the above

Question 6

One way to ensure that correct data is entered into a cell or range is to use the Excel data ____________________ feature.

Accepted Answer

The answer of One way to ensure that correct data...

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell

Accepted Answer

A) Stop 
B) Warning 
C) Information 
D) locked 
E) macro
F)Excel application
G)defined name
H)input message
I)validation rule
J)digital certificate
K)digital signature
L)VBA 
A) Stop 
B) Warning 
C) Information 
D) locked 
E) macro
F)Excel application
G)defined name
H)input message
I)validation rule
J)digital certificate
K)digital signature
L)VBA

Question 8

Applications typically include an interface to assist the user in using the system,ranging from special buttons that assist in existing specific tasks to changing the entire Excel interface with customized ____.

Accepted Answer

A)  commands 
B)  menus 
C)  toolbars 
D)  all of the above 
A)  commands 
B)  menus 
C)  toolbars 
D)  all of the above

Question 9

In VBA procedures,the ____ are used if you want to include any arguments in the procedure.

Accepted Answer

A)  underscores 
B)  brackets 
C)  braces 
D)  parentheses 
A)  underscores 
B)  brackets 
C)  braces 
D)  parentheses

Question 10

A macro can be stored in ____.

Accepted Answer

A)  the current workbook 
B)  the Personal Macro workbook 
C)  a new workbook 
D)  any of the above 
A)  the current workbook 
B)  the Personal Macro workbook 
C)  a new workbook 
D)  any of the above

Question 11

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Word or string of characters associated with a single cell or a range

Accepted Answer

A) Stop 
B) Warning 
C) Information 
D) locked 
E) macro
F)Excel application
G)defined name
H)input message
I)validation rule
J)digital certificate
K)digital signature
L)VBA 
A) Stop 
B) Warning 
C) Information 
D) locked 
E) macro
F)Excel application
G)defined name
H)input message
I)validation rule
J)digital certificate
K)digital signature
L)VBA

Question 12

To move the box,you would drag the selection handle of the comment in the accompanying figure.

Accepted Answer

A) True 
 B)False

Question 13

Protecting the ____________________ of a workbook prohibits users from moving,resizing,closing,or hiding parts of the Excel window.

Accepted Answer

The answer of Protecting the ____________________ of a workbook prohibits...

Question 14

In the Allow list box in the Data Validation dialog box,the ____________________ option means that the cell will accept only dates.

Accepted Answer

The answer of In the Allow list box in the...

Question 15

You can use the Name Manager dialog box,shown above,to create a defined name.

Accepted Answer

A) True 
 B)False

Question 16

In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept only values from a list.

Accepted Answer

A)  List 
B)  Index 
C)  Roster 
D)  Catalog 
A)  List 
B)  Index 
C)  Roster 
D)  Catalog

Question 17

Every cell in a workbook has a(n)sealed property that determines whether or not changes can be made to that cell._________________________

Accepted Answer

A) True 
 B)False

Question 18

In the figure above,clicking the New button,opens the New Name dialog box.

Accepted Answer

A)  Name 
B)  Macro 
C)  Label 
D)  Range 
A)  Name 
B)  Macro 
C)  Label 
D)  Range

Question 19

You control how Excel handles suspect macros by setting Excel's ____________________.

Accepted Answer

The answer of You control how Excel handles suspect macros...

Question 20

By default,the locked property is turned off for each cell when you protect a workbook._________________________

Accepted Answer

A) True 
 B)False

Each cell can have at most three validation rules.

In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept only times.

Most ____ are not harmful and do not affect data in any way.

-The red triangle (that has an arrow pointing to it)in the accompanying figure indicates that a given cell does not have a comment.

Using defined names like the kind shown in the accompanying figure makes creating and understanding a(n)____ easier.

One way to ensure that correct data is entered into a cell or range is to use the Excel data ____________________ feature.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell

Applications typically include an interface to assist the user in using the system,ranging from special buttons that assist in existing specific tasks to changing the entire Excel interface with customized ____.

In VBA procedures,the ____ are used if you want to include any arguments in the procedure.

A macro can be stored in ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Word or string of characters associated with a single cell or a range

To move the box,you would drag the selection handle of the comment in the accompanying figure.

Protecting the ____________________ of a workbook prohibits users from moving,resizing,closing,or hiding parts of the Excel window.

In the Allow list box in the Data Validation dialog box,the ____________________ option means that the cell will accept only dates.

You can use the Name Manager dialog box,shown above,to create a defined name.

In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept only values from a list.

Every cell in a workbook has a(n)sealed property that determines whether or not changes can be made to that cell._________________________

In the figure above,clicking the New button,opens the New Name dialog box.

You control how Excel handles suspect macros by setting Excel's ____________________.

By default,the locked property is turned off for each cell when you protect a workbook._________________________

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

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 8: Developing an Excel Application

Each cell can have at most three validation rules.

In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept only times.

Most ____ are not harmful and do not affect data in any way.

-The red triangle (that has an arrow pointing to it)in the accompanying figure indicates that a given cell does not have a comment.

Using defined names like the kind shown in the accompanying figure makes creating and understanding a(n)____ easier.

One way to ensure that correct data is entered into a cell or range is to use the Excel data ____________________ feature.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell

Applications typically include an interface to assist the user in using the system,ranging from special buttons that assist in existing specific tasks to changing the entire Excel interface with customized ____.

In VBA procedures,the ____ are used if you want to include any arguments in the procedure.

A macro can be stored in ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Word or string of characters associated with a single cell or a range

To move the box,you would drag the selection handle of the comment in the accompanying figure.

Protecting the ____________________ of a workbook prohibits users from moving,resizing,closing,or hiding parts of the Excel window.

In the Allow list box in the Data Validation dialog box,the ____________________ option means that the cell will accept only dates.

You can use the Name Manager dialog box,shown above,to create a defined name.

In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept only values from a list.

Every cell in a workbook has a(n)sealed property that determines whether or not changes can be made to that cell._________________________

In the figure above,clicking the New button,opens the New Name dialog box.

You control how Excel handles suspect macros by setting Excel's ____________________.

By default,the locked property is turned off for each cell when you protect a workbook._________________________

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

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters