Question 1

The Name dialog box lists all of the names currently defined in the workbook,including Excel table names._________________________

Accepted Answer

A) True 
 B)False

Question 2

Using the Excel data validation feature,you can specify a(n)____ of acceptable values.

Accepted Answer

A)  roster 
B)  series 
C)  array 
D)  range 
A)  roster 
B)  series 
C)  array 
D)  range

Question 3

Range names can be up to ____ characters.

Accepted Answer

A)  15 
B)  27 
C)  56 
D)  255 
A)  15 
B)  27 
C)  56 
D)  255

Question 4

The default is to protect only the appearance of a workbook._________________________

Accepted Answer

A) True 
 B)False

Question 5

Any blanks or parentheses in a row or column label will be changed to ____ in defined names.

Accepted Answer

A)  ampersands 
B)  underscore characters 
C)  hyphens 
D)  dashes 
A)  ampersands 
B)  underscore characters 
C)  hyphens 
D)  dashes

Question 6

After the first character in a range name,the following is acceptable: ____.

Accepted Answer

A)  hyphen 
B)  space 
C)  periods 
D)  either a.or b. 
A)  hyphen 
B)  space 
C)  periods 
D)  either a.or b.

Question 7

____ messages appear as ScreenTips next to the active cell.

Accepted Answer

A)  Value 
B)  Input 
C)  Key 
D)  User 
A)  Value 
B)  Input 
C)  Key 
D)  User

Question 8

You use the ____ tab in the Data Validation dialog box to enter the validation rules for the active cell.

Accepted Answer

A)  Active Cell 
B)  Rules 
C)  Settings 
D)  Input Message 
A)  Active Cell 
B)  Rules 
C)  Settings 
D)  Input Message

Question 9

The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code._________________________

Accepted Answer

A) True 
 B)False

Question 10

After the comments in VBA code is the ____ of the macro.

Accepted Answer

A)  module 
B)  body 
C)  procedure 
D)  command 
A)  module 
B)  body 
C)  procedure 
D)  command

The Name dialog box lists all of the names currently defined in the workbook,including Excel table names._________________________

Using the Excel data validation feature,you can specify a(n)____ of acceptable values.

Range names can be up to ____ characters.

The default is to protect only the appearance of a workbook._________________________

Any blanks or parentheses in a row or column label will be changed to ____ in defined names.

After the first character in a range name,the following is acceptable: ____.

____ messages appear as ScreenTips next to the active cell.

You use the ____ tab in the Data Validation dialog box to enter the validation rules for the active cell.

The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code._________________________

After the comments in VBA code is the ____ of the macro.

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

The Name dialog box lists all of the names currently defined in the workbook,including Excel table names._________________________

Using the Excel data validation feature,you can specify a(n)____ of acceptable values.

Range names can be up to ____ characters.

The default is to protect only the appearance of a workbook._________________________

Any blanks or parentheses in a row or column label will be changed to ____ in defined names.

After the first character in a range name,the following is acceptable: ____.

____ messages appear as ScreenTips next to the active cell.

You use the ____ tab in the Data Validation dialog box to enter the validation rules for the active cell.

The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code._________________________

After the comments in VBA code is the ____ of the macro.

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