Question 1

Excel 2010 enables you to change the Ribbon to fit your work style.Among many other customization features,you can do all of the following EXCEPT ____.

Accepted Answer

A)  eliminate the Ribbon 
B)  minimize the Ribbon 
C)  hide tabs or commands 
D)  rename tabs or commands 
A)  eliminate the Ribbon 
B)  minimize the Ribbon 
C)  hide tabs or commands 
D)  rename tabs or commands

Question 2

If a ____ error appears when you run a macro that has worked in the past,some part of the macro code no longer makes sense to Excel.

Accepted Answer

A)  syntax 
B)  run-time 
C)  logic 
D)  baseline 
A)  syntax 
B)  run-time 
C)  logic 
D)  baseline

Question 3

Protecting the ____ prohibits users from renaming,deleting,hiding,or inserting worksheets.

Accepted Answer

A)  skeleton 
B)  structure 
C)  format 
D)  location 
A)  skeleton 
B)  structure 
C)  format 
D)  location

Question 4

When you protect a sheet,unless you are concerned the users will turn off protection and make changes to formulas,it is probably best not to specify a ____.

Accepted Answer

A)  lock 
B)  password 
C)  username 
D)  any of the above 
A)  lock 
B)  password 
C)  username 
D)  any of the above

Question 5

You can keep users from deleting worksheets or inserting new ones.

Accepted Answer

A) True 
 B)False

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

A)  validation 
B)  concatenation 
C)  security 
D)  index 
A)  validation 
B)  concatenation 
C)  security 
D)  index

Question 7

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 gets more comfortable with Excel,he thinks that he might be able to decide whether or not to run a macro on a case-by-case basis.What should his option be in the Trust Center?

Accepted Answer

A)  Disable all macros without notification 
B)  Cancel all macros 
C)  Disable a macro with notification 
D)  Disable all macros except digitally signed macros 
A)  Disable all macros without notification 
B)  Cancel all macros 
C)  Disable a macro with notification 
D)  Disable all macros except digitally signed macros

Question 8

When you open a file with macros,the response you see is based on the security level set on the computer.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Range names must begin with ____.

Accepted Answer

A)  a letter 
B)  the underscore character 
C)  a number 
D)  either a.or b. 
A)  a letter 
B)  the underscore character 
C)  a number 
D)  either a.or b.

Question 11

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

Accepted Answer

A)  Calendar 
B)  Schedule 
C)  Date 
D)  Timeline 
A)  Calendar 
B)  Schedule 
C)  Date 
D)  Timeline

Question 12

A(n)____________________ is a spreadsheet written or tailored to meet the user's specific needs.

Accepted Answer

The answer of A(n)____________________ is a spreadsheet written or tailored...

Question 13

To open the Protect Sheet dialog box,click the Review tab on the Ribbon,and then click the Protect Sheet button in the ____________________ group.

Accepted Answer

The answer of To open the Protect Sheet dialog box,click...

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Error alert that accepts the invalid data but still allows you to cancel the data entry

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 15

In the City_State_Zip field name shown in the accompanying figure,the underscores replace ____ in the label name.

Accepted Answer

A)  spaces 
B)  periods 
C)  commas 
D)  numbers 
A)  spaces 
B)  periods 
C)  commas 
D)  numbers

Question 16

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.
-By digitally signing a workbook that contains a macro that she intends to publicly distribute,Renee assures her audience ____.

Accepted Answer

A)  of the identity of the creator of the macro 
B)  that the macro has not been altered since the digital signature was created 
C)  that the macro will perform as expected 
D)  both a.and b. 
A)  of the identity of the creator of the macro 
B)  that the macro has not been altered since the digital signature was created 
C)  that the macro will perform as expected 
D)  both a.and b.

Question 17

Once you protect a worksheet,the locked property is enabled and controls whether or not a cell can be edited.

Accepted Answer

A) True 
 B)False

Question 18

In VBA,macros are called ____ procedures.

Accepted Answer

A)  body 
B)  sub 
C)  commented 
D)  modular 
A)  body 
B)  sub 
C)  commented 
D)  modular

Question 19

To create a macro,you can write one by entering a series of commands in the ____ programming language.

Accepted Answer

A)  HTML 
B)  Java 
C)  VBA 
D)  Perl 
A)  HTML 
B)  Java 
C)  VBA 
D)  Perl

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Defines the criteria for storing data in a cell or 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

Excel 2010 enables you to change the Ribbon to fit your work style.Among many other customization features,you can do all of the following EXCEPT ____.

If a ____ error appears when you run a macro that has worked in the past,some part of the macro code no longer makes sense to Excel.

Protecting the ____ prohibits users from renaming,deleting,hiding,or inserting worksheets.

When you protect a sheet,unless you are concerned the users will turn off protection and make changes to formulas,it is probably best not to specify a ____.

You can keep users from deleting worksheets or inserting new ones.

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

When you open a file with macros,the response you see is based on the security level set on the computer.

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

Range names must begin with ____.

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

A(n)____________________ is a spreadsheet written or tailored to meet the user's specific needs.

To open the Protect Sheet dialog box,click the Review tab on the Ribbon,and then click the Protect Sheet button in the ____________________ group.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Error alert that accepts the invalid data but still allows you to cancel the data entry

In the City_State_Zip field name shown in the accompanying figure,the underscores replace ____ in the label name.

Once you protect a worksheet,the locked property is enabled and controls whether or not a cell can be edited.

In VBA,macros are called ____ procedures.

To create a macro,you can write one by entering a series of commands in the ____ programming language.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Defines the criteria for storing data in a cell or range

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

Excel 2010 enables you to change the Ribbon to fit your work style.Among many other customization features,you can do all of the following EXCEPT ____.

If a ____ error appears when you run a macro that has worked in the past,some part of the macro code no longer makes sense to Excel.

Protecting the ____ prohibits users from renaming,deleting,hiding,or inserting worksheets.

When you protect a sheet,unless you are concerned the users will turn off protection and make changes to formulas,it is probably best not to specify a ____.

You can keep users from deleting worksheets or inserting new ones.

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

When you open a file with macros,the response you see is based on the security level set on the computer.

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

Range names must begin with ____.

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

A(n)____________________ is a spreadsheet written or tailored to meet the user's specific needs.

To open the Protect Sheet dialog box,click the Review tab on the Ribbon,and then click the Protect Sheet button in the ____________________ group.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Error alert that accepts the invalid data but still allows you to cancel the data entry

In the City_State_Zip field name shown in the accompanying figure,the underscores replace ____ in the label name.

Once you protect a worksheet,the locked property is enabled and controls whether or not a cell can be edited.

In VBA,macros are called ____ procedures.

To create a macro,you can write one by entering a series of commands in the ____ programming language.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Defines the criteria for storing data in a cell or range

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