Question 1

When you ____________________ a workbook,you control the ability users have to make changes to the file.

Accepted Answer

The answer of When you ____________________ a workbook,you control the...

Question 2

After the Stop alert,the next alert in severity is the ____ alert.

Accepted Answer

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

Question 3

Describe the four macro security settings.

Accepted Answer

Disable all macros without notification:

Question 4

A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was created._________________________

Accepted Answer

A) True 
 B)False

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Spreadsheet written or tailored to meet the user's specific needs

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 6

Defined names are automatically substituted for the cell addresses in a formula.

Accepted Answer

A) True 
 B)False

Question 7

A macro ____________________ uses a program's own macro programming language for distribution.

Accepted Answer

The answer of A macro ____________________ uses a program's own...

Question 8

Case-Based Critical Thinking Questions
Case 8-2
Renee has just completed some coursework in Excel application writing and wants to begin developing her own macros to share more widely.She knows that she has to learn more about digital signatures in order to make her plan a reality.
-Which of the following can Renee NOT tell when she opens a digitally signed file?

Accepted Answer

A)  who the author is 
B)  whether the information in the file is authentic 
C)  whether the macros in the workbook are safe to run 
D)  whether the macro will perform as expected 
A)  who the author is 
B)  whether the information in the file is authentic 
C)  whether the macros in the workbook are safe to run 
D)  whether the macro will perform as expected

Question 9

In the figure above,the column labeled "Refers to" is the name's ____.

Accepted Answer

A)  link location 
B)  location in the worksheet 
C)  target location in the worksheet 
D)  none of the above 
A)  link location 
B)  location in the worksheet 
C)  target location in the worksheet 
D)  none of the above

Question 10

-Clicking the Edit button in the accompanying figure opens the New Name dialog box in which you can modify the selected defined name.

Accepted Answer

A) True 
 B)False

Question 11

A digital ____________________ is typically issued by a certificate authority.

Accepted Answer

The answer of A digital ____________________ is typically issued by...

Question 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Error alert that rejects invalid data but allows you to override the rejection

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 13

In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept any type of numeric value.

Accepted Answer

A)  Whole Number 
B)  Any Number 
C)  Decimal 
D)  Integer 
A)  Whole Number 
B)  Any Number 
C)  Decimal 
D)  Integer

Question 14

In Office 2010,you can define a set of locations (file paths)where you can place files you consider trustworthy.This feature is known as ____ Locations.

Accepted Answer

A)  Safe 
B)  Secure 
C)  Trusted 
D)  Quarantined 
A)  Safe 
B)  Secure 
C)  Trusted 
D)  Quarantined

Question 15

The current data in the ParkingFee cell,according to the accompanying figure,is ____.

Accepted Answer

A)  25 
B)  8 
C)  2 
D)  15 
A)  25 
B)  8 
C)  2 
D)  15

Question 16

Sometimes when you build a worksheet for other users,you may decide to add a(n)____ message to a cell even if you don't validate the data in that cell.

Accepted Answer

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

Question 17

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

Accepted Answer

A)  Integer 
B)  Decimal 
C)  Numerical 
D)  Whole Number 
A)  Integer 
B)  Decimal 
C)  Numerical 
D)  Whole Number

Question 18

Case-Based Critical Thinking Questions
Case 8-3
Javier tells you that your work in Excel will go a lot faster if you start using defined names instead of cell and range addresses.You believe him but you have been frustrated by defined names in the past because you did not know the rules for naming them and you have run into errors as a result.Javier offers to help you.
-Which of the following is true statement Javier can make about defined names as he is explaining the rules to you?

Accepted Answer

A)  The name can include letters,numbers,periods,and underscores 
B)  To distinguish multiword names,use a hyphen between the words 
C)  Defined names are case sensitive 
D)  All of the above 
A)  The name can include letters,numbers,periods,and underscores 
B)  To distinguish multiword names,use a hyphen between the words 
C)  Defined names are case sensitive 
D)  All of the above

Question 19

When you set up worksheet protection,you can allow users to ____.

Accepted Answer

A)  insert new rows or columns 
B)  delete rows and columns 
C)  select any cell in the worksheet. 
D)  any of the above 
A)  insert new rows or columns 
B)  delete rows and columns 
C)  select any cell in the worksheet. 
D)  any of the above

Question 20

You drag the comment's border to resize a comment box like the one shown in the accompanying figure.

Accepted Answer

A) True 
 B)False

When you ____________________ a workbook,you control the ability users have to make changes to the file.

After the Stop alert,the next alert in severity is the ____ alert.

Describe the four macro security settings.

A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was created._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Spreadsheet written or tailored to meet the user's specific needs

Defined names are automatically substituted for the cell addresses in a formula.

A macro ____________________ uses a program's own macro programming language for distribution.

In the figure above,the column labeled "Refers to" is the name's ____.

-Clicking the Edit button in the accompanying figure opens the New Name dialog box in which you can modify the selected defined name.

A digital ____________________ is typically issued by a certificate authority.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Error alert that rejects invalid data but allows you to override the rejection

In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept any type of numeric value.

In Office 2010,you can define a set of locations (file paths)where you can place files you consider trustworthy.This feature is known as ____ Locations.

The current data in the ParkingFee cell,according to the accompanying figure,is ____.

Sometimes when you build a worksheet for other users,you may decide to add a(n)____ message to a cell even if you don't validate the data in that cell.

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

When you set up worksheet protection,you can allow users to ____.

You drag the comment's border to resize a comment box like the one shown in the accompanying figure.

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

When you ____________________ a workbook,you control the ability users have to make changes to the file.

After the Stop alert,the next alert in severity is the ____ alert.

Describe the four macro security settings.

A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was created._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Spreadsheet written or tailored to meet the user's specific needs

Defined names are automatically substituted for the cell addresses in a formula.

A macro ____________________ uses a program's own macro programming language for distribution.

In the figure above,the column labeled "Refers to" is the name's ____.

-Clicking the Edit button in the accompanying figure opens the New Name dialog box in which you can modify the selected defined name.

A digital ____________________ is typically issued by a certificate authority.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Error alert that rejects invalid data but allows you to override the rejection

In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept any type of numeric value.

In Office 2010,you can define a set of locations (file paths)where you can place files you consider trustworthy.This feature is known as ____ Locations.

The current data in the ParkingFee cell,according to the accompanying figure,is ____.

Sometimes when you build a worksheet for other users,you may decide to add a(n)____ message to a cell even if you don't validate the data in that cell.

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

When you set up worksheet protection,you can allow users to ____.

You drag the comment's border to resize a comment box like the one shown in the accompanying figure.

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