Question 1

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

Accepted Answer

Excel application

Question 2

The $\underline {\text { Name }}$ dialog box lists all of the names currently defined in the workbook,including Excel table names._________________________

Accepted Answer

A) True 
 B)False  False

Question 3

In addition to referring to cells by their cell references,it is easier to remember where different data is stored by assigning a meaningful,descriptive ____________________ to each cell or range.

Accepted Answer

name

Question 4

-The current data in the SeasonFee cell,according to the accompanying figure,is _____.

Accepted Answer

A) 5 
B) SM 
C) 12/1/2016 
D) 75 
A) 5 
B) SM 
C) 12/1/2016 
D) 75

Question 5

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

Accepted Answer

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

Question 6

Juan 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. Juan offers to help you.
-Which of the following is an example of a valid defined name Juan can provide to you?

Accepted Answer

A) 	.FY2010 
B) F-Y2010 
C) FY2010 
D) FiscalYear2010 
A) 	.FY2010 
B) F-Y2010 
C) FY2010 
D) FiscalYear2010

Question 7

For cell and range names,names of 5 to 15 characters are considered practical,although names can be up to 255 characters.

Accepted Answer

A) True 
 B)False

Question 8

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)VBA
G)defined name
H)input message
I)validation rule
J)digital certificate 
A) Stop 
B) Warning 
C) Information 
D) locked 
E) macro
F)VBA
G)defined name
H)input message
I)validation rule
J)digital certificate

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Series of stored commands

Accepted Answer

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

Question 10

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 11

-In the accompanying figure,clicking the New button opens the New _____ dialog box.

Accepted Answer

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

Question 12

When Excel creates a macro button,the $\underline {\text { Assign Macro }}$ dialog box opens with the button's default name showing._________________________

Accepted Answer

A) True 
 B)False

Question 13

A protected sheet can always be unprotected,but you can also require users to enter a(n)____________________ before the protection is removed.

Accepted Answer

The answer of A protected sheet can always be unprotected,but...

Question 14

Describe the four macro security settings.

Accepted Answer

Disable all macros without notification:

Question 15

Rina 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,Rina assures her audience _____.

Accepted Answer

A) of the identity of the user 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) that no data entry errors will stop the macro from running 
A) of the identity of the user 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) that no data entry errors will stop the macro from running

Question 16

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

Accepted Answer

A) ensure 
B) protect 
C) secure 
D) seal 
A) ensure 
B) protect 
C) secure 
D) seal

Question 17

Ted 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.
-While just getting his feet wet with Excel,you suggest to Ted that he might want to begin without having his installation of Excel have any macros run at all.Which of the following options would he select 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 18

The Excel data _____ feature restricts data entry to follow a defined set of rules.

Accepted Answer

A) error-checking 
B) rule-based 
C) validation 
D) contingent 
A) error-checking 
B) rule-based 
C) validation 
D) contingent

Question 19

-The red triangle (which 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 20

Even when the worksheet is unprotected,the locked property determines whether or not changes can be made to a given cell.

Accepted Answer

A) True 
 B)False

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

The $\underline {\text { Name }}$ dialog box lists all of the names currently defined in the workbook,including Excel table names._________________________

In addition to referring to cells by their cell references,it is easier to remember where different data is stored by assigning a meaningful,descriptive ____________________ to each cell or range.

-The current data in the SeasonFee cell,according to the accompanying figure,is _____.

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

For cell and range names,names of 5 to 15 characters are considered practical,although names can be up to 255 characters.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Series of stored commands

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

-In the accompanying figure,clicking the New button opens the New _____ dialog box.

When Excel creates a macro button,the $\underline {\text { Assign Macro }}$ dialog box opens with the button's default name showing._________________________

A protected sheet can always be unprotected,but you can also require users to enter a(n)____________________ before the protection is removed.

Describe the four macro security settings.

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

The Excel data _____ feature restricts data entry to follow a defined set of rules.

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

Even when the worksheet is unprotected,the locked property determines whether or not changes can be made to a given cell.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

Exam 7: Developing an Excel Application

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

The Name ‾\underline {\text { Name }} Name ​ dialog box lists all of the names currently defined in the workbook,including Excel table names._________________________

In addition to referring to cells by their cell references,it is easier to remember where different data is stored by assigning a meaningful,descriptive ____________________ to each cell or range.

-The current data in the SeasonFee cell,according to the accompanying figure,is _____.

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

For cell and range names,names of 5 to 15 characters are considered practical,although names can be up to 255 characters.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Series of stored commands

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

-In the accompanying figure,clicking the New button opens the New _____ dialog box.

When Excel creates a macro button,the Assign Macro ‾\underline {\text { Assign Macro }} Assign Macro ​ dialog box opens with the button's default name showing._________________________

A protected sheet can always be unprotected,but you can also require users to enter a(n)____________________ before the protection is removed.

Describe the four macro security settings.

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

The Excel data _____ feature restricts data entry to follow a defined set of rules.

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

Even when the worksheet is unprotected,the locked property determines whether or not changes can be made to a given cell.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

The $\underline {\text { Name }}$ dialog box lists all of the names currently defined in the workbook,including Excel table names._________________________

When Excel creates a macro button,the $\underline {\text { Assign Macro }}$ dialog box opens with the button's default name showing._________________________