Question 1

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)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 2

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

Accepted Answer

Some advantages to using defined names i

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Word or string of characters associated with a single cell or a 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 4

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

Question 5

Protecting the ____________________ of a workbook prohibits users from moving,resizing,closing,or hiding parts of the Excel window.

Accepted Answer

The answer of Protecting the ____________________ of a workbook prohibits...

Question 6

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.
-Which of the following can Rina tell when she opens a digitally signed file?

Accepted Answer

A) Who the author of the file is 
B) Whether the information in the file is correct 
C) Whether the macros in the workbook will produce accurate results 
D) Whether the macro will perform as expected 
A) Who the author of the file is 
B) Whether the information in the file is correct 
C) Whether the macros in the workbook will produce accurate results 
D) Whether the macro will perform as expected

Question 7

Usually,you will want to protect a worksheet but leave some cells _____.

Accepted Answer

A) open 
B) empty 
C) clear 
D) unlocked 
A) open 
B) empty 
C) clear 
D) unlocked

Question 8

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)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

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

Accepted Answer

A) explain the contents of a particular cell, such as a complex formula 
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, such as a complex formula 
B) provide instructions to users 
C) share ideas and notes from several users collaborating on a project 
D) All of the above

Question 10

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.
-As Ted does more even work in Excel,he 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 11

The _____ Macro workbook is a hidden workbook opened whenever you start Excel,making its macros available anytime you use Excel.

Accepted Answer

A) Universal 
B) Personal 
C) Microsoft 
D) XP 
A) Universal 
B) Personal 
C) Microsoft 
D) XP

Question 12

Every cell in a workbook has a(n)$\underline { \text { locked }   }$ property that determines whether or not changes can be made to that cell._________________________

Accepted Answer

A) True 
 B)False

Question 13

Any $\underline {  \text { blanks }  }$ or parentheses in row or column labels are changed to underscore characters in defined names._________________________

Accepted Answer

A) True 
 B)False

Question 14

The _____ dialog box displays all of the names in the workbook.

Accepted Answer

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

Question 15

A digital ____________________ is typically issued by a certificate authority.

Accepted Answer

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

Question 16

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

Accepted Answer

A) Chronology 
B) Clock 
C) Time 
D) Calendar 
A) Chronology 
B) Clock 
C) Time 
D) Calendar

Question 17

One way to run a macro is to assign it to a(n)$\underline {\text { button }}$that is placed directly on the worksheet._________________________

Accepted Answer

A) True 
 B)False

Question 18

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.
-As Ted 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 all macros with notification 
D) Disable all macros except digitally signed macros 
A) Disable all macros without notification 
B) Cancel all macros 
C) Disable all macros with notification 
D) Disable all macros except digitally signed macros

Question 19

To save a workbook with macros,the default Excel Workbook format needs to change to a macro-enabled workbook,which has the _____ file extension.

Accepted Answer

A) xlsm 
B) xlst 
C) xlsx 
D) xls 
A) xlsm 
B) xlst 
C) xlsx 
D) xls

Question 20

The $\underline {\text { 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

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Word or string of characters associated with a single cell or a range

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

Protecting the ____________________ of a workbook prohibits users from moving,resizing,closing,or hiding parts of the Excel window.

Usually,you will want to protect a worksheet but leave some cells _____.

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

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

The _____ Macro workbook is a hidden workbook opened whenever you start Excel,making its macros available anytime you use Excel.

Every cell in a workbook has a(n) $\underline { \text { locked } }$ property that determines whether or not changes can be made to that cell._________________________

Any $\underline { \text { blanks } }$ or parentheses in row or column labels are changed to underscore characters in defined names._________________________

The _____ dialog box displays all of the names in the workbook.

A digital ____________________ is typically issued by a certificate authority.

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

One way to run a macro is to assign it to a(n) $\underline {\text { button }}$ that is placed directly on the worksheet._________________________

To save a workbook with macros,the default Excel Workbook format needs to change to a macro-enabled workbook,which has the _____ file extension.

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

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

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Word or string of characters associated with a single cell or a range

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

Protecting the ____________________ of a workbook prohibits users from moving,resizing,closing,or hiding parts of the Excel window.

Usually,you will want to protect a worksheet but leave some cells _____.

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

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

The _____ Macro workbook is a hidden workbook opened whenever you start Excel,making its macros available anytime you use Excel.

Every cell in a workbook has a(n) locked ‾\underline { \text { locked } } locked ​ property that determines whether or not changes can be made to that cell._________________________

Any blanks ‾\underline { \text { blanks } } blanks ​ or parentheses in row or column labels are changed to underscore characters in defined names._________________________

The _____ dialog box displays all of the names in the workbook.

A digital ____________________ is typically issued by a certificate authority.

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

One way to run a macro is to assign it to a(n) button ‾\underline {\text { button }} button ​ that is placed directly on the worksheet._________________________

To save a workbook with macros,the default Excel Workbook format needs to change to a macro-enabled workbook,which has the _____ file extension.

The Visual Basic Editor ‾\underline {\text { Visual Basic Editor } } Visual Basic Editor ​ is a separate application that works with Excel and all of the Office products to edit and manage VBA code._________________________

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

Every cell in a workbook has a(n) $\underline { \text { locked } }$ property that determines whether or not changes can be made to that cell._________________________

Any $\underline { \text { blanks } }$ or parentheses in row or column labels are changed to underscore characters in defined names._________________________

One way to run a macro is to assign it to a(n) $\underline {\text { button }}$ that is placed directly on the worksheet._________________________

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