Question 1

A(n)____ message provides additional information about the type of data allowed for the cell.

Accepted Answer

A)  user 
B)  key 
C)  input 
D)  value 
A)  user 
B)  key 
C)  input 
D)  value

Question 2

The most serious error alert is the ____ alert.

Accepted Answer

A)  Warning 
B)  Information 
C)  Security 
D)  Stop 
A)  Warning 
B)  Information 
C)  Security 
D)  Stop

Question 3

If your data is organized in a tabular format,you can quickly create range names for each column or row in the list by using the ____ dialog box.

Accepted Answer

A)  Make from Table 
B)  Name 
C)  Create from Selection 
D)  Assign 
A)  Make from Table 
B)  Name 
C)  Create from Selection 
D)  Assign

Question 4

Case-Based Critical Thinking Questions
Case 8-1
Joe knows that macros can be helpful to him in his work with Excel spreadsheets,but he also knows they have their hazards,so he comes to you for guidance about what kind of security settings he should put in place,and at what times.
-As Joe does more even work in Excel,Joe has begun to develop a collection of publishers whom he trusts to deliver macros that are problem-free.What should his option be in the Trust Center?

Accepted Answer

A)  Enable all trusted macros 
B)  Enable all macros 
C)  Disable all macros except digitally signed macros 
D)  Disable a macro with notification 
A)  Enable all trusted macros 
B)  Enable all macros 
C)  Disable all macros except digitally signed macros 
D)  Disable a macro with notification

Question 5

The ____ box displays all of the names in the workbook.

Accepted Answer

A)  Name 
B)  Ranges 
C)  Definition 
D)  Terms 
A)  Name 
B)  Ranges 
C)  Definition 
D)  Terms

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Property that determines whether or not changes can be made to a 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 7

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

Accepted Answer

A) True 
 B)False

Question 8

If you select the Custom option in the Allow list box in the Data Validation dialog box,the validation rule will be based on an Excel logistical formula._________________________

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ alert prevents you from storing the data in the cell.

Accepted Answer

The answer of The ____________________ alert prevents you from storing...

Question 10

Input messages appear as ____________________ next to the active cell.

Accepted Answer

The answer of Input messages appear as ____________________ next to...

Question 11

Each sub procedure in VBA begins with the keyword "Sub" followed by the name of the sub procedure and a set of ____.

Accepted Answer

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

Question 12

Which of the following is a tab in the Data Validation dialog box?

Accepted Answer

A)  Settings 
B)  Input Message 
C)  Error Alert 
D)  All of the above 
A)  Settings 
B)  Input Message 
C)  Error Alert 
D)  All of the above

Question 13

One way to run a macro is to assign it to a(n)button that is placed directly on the worksheet._________________________

Accepted Answer

A) True 
 B)False

Question 14

The following is a valid function name: ____.

Accepted Answer

A)  FY2010 
B)  Print_Area 
C)  Net-Income 
D)  none of the above 
A)  FY2010 
B)  Print_Area 
C)  Net-Income 
D)  none of the above

Question 15

You cannot prevent users from changing all of the formulas in a worksheet.

Accepted Answer

A) True 
 B)False

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Needed before you can add a digital signature to a workbook

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 17

List three advantages to using defined names instead of cell references.

Accepted Answer

A name is more descriptive than a cell r

Question 18

You can create a(n)____________________ key that will run a macro directly from the keyboard.

Accepted Answer

The answer of You can create a(n)____________________ key that will...

Question 19

-Comments like those in the accompanying figure are often used to ____.

Accepted Answer

A)  explain the contents of a particular cell 
B)  provide instructions to users 
C)  share ideas and notes from several users collaborating on a project 
D)  all of the above 
A)  explain the contents of a particular cell 
B)  provide instructions to users 
C)  share ideas and notes from several users collaborating on a project 
D)  all of the above

Question 20

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

Accepted Answer

A)  ensured 
B)  locked 
C)  security 
D)  changeable 
A)  ensured 
B)  locked 
C)  security 
D)  changeable

A(n)____ message provides additional information about the type of data allowed for the cell.

The most serious error alert is the ____ alert.

If your data is organized in a tabular format,you can quickly create range names for each column or row in the list by using the ____ dialog box.

The ____ box displays all of the names in the workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Property that determines whether or not changes can be made to a cell

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

If you select the Custom option in the Allow list box in the Data Validation dialog box,the validation rule will be based on an Excel logistical formula._________________________

The ____________________ alert prevents you from storing the data in the cell.

Input messages appear as ____________________ next to the active cell.

Each sub procedure in VBA begins with the keyword "Sub" followed by the name of the sub procedure and a set of ____.

Which of the following is a tab in the Data Validation dialog box?

One way to run a macro is to assign it to a(n)button that is placed directly on the worksheet._________________________

The following is a valid function name: ____.

You cannot prevent users from changing all of the formulas in a worksheet.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Needed before you can add a digital signature to a workbook

List three advantages to using defined names instead of cell references.

You can create a(n)____________________ key that will run a macro directly from the keyboard.

-Comments like those in the accompanying figure are often used to ____.

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

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

A(n)____ message provides additional information about the type of data allowed for the cell.

The most serious error alert is the ____ alert.

If your data is organized in a tabular format,you can quickly create range names for each column or row in the list by using the ____ dialog box.

The ____ box displays all of the names in the workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Property that determines whether or not changes can be made to a cell

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

If you select the Custom option in the Allow list box in the Data Validation dialog box,the validation rule will be based on an Excel logistical formula._________________________

The ____________________ alert prevents you from storing the data in the cell.

Input messages appear as ____________________ next to the active cell.

Each sub procedure in VBA begins with the keyword "Sub" followed by the name of the sub procedure and a set of ____.

Which of the following is a tab in the Data Validation dialog box?

One way to run a macro is to assign it to a(n)button that is placed directly on the worksheet._________________________

The following is a valid function name: ____.

You cannot prevent users from changing all of the formulas in a worksheet.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Needed before you can add a digital signature to a workbook

List three advantages to using defined names instead of cell references.

You can create a(n)____________________ key that will run a macro directly from the keyboard.

-Comments like those in the accompanying figure are often used to ____.

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

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