Question 1

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 2

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 3

To keep a comment like the one in the accompanying figure on the screen, in the Comments group on the _____ tab, click the Show/Hide Comment button.

Accepted Answer

A)  REVIEW 
B)  FORMAT 
C)  OPTIONS 
D)  HOME 
A)  REVIEW 
B)  FORMAT 
C)  OPTIONS 
D)  HOME

Question 4

Case-Based Critical Thinking Questions
Case 7-3
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 a true statement Juan 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)  The name should start with a hash tag 
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)  The name should start with a hash tag

Question 5

A _____ can be destructive and can modify or delete files that may not be recoverable.

Accepted Answer

A)  digital signature 
B)  macro virus 
C)  comment virus 
D)  micro virus 
A)  digital signature 
B)  macro virus 
C)  comment virus 
D)  micro virus

Question 6

Describe the four macro security settings.

Accepted Answer

Disable all macros without notification:

Question 7

In the accompanying figure, the column labeled Refers To is the range s _____.

Accepted Answer

A)  link location 
B)  location in the workbook 
C)  target location in the worksheet 
D)  web name 
A)  link location 
B)  location in the workbook 
C)  target location in the worksheet 
D)  web name

Question 8

Case-Based Critical Thinking Questions
Case 7-3
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 9

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

The answer of In addition to referring to cells by...

Question 10

_____ messages appear as ScreenTips next to the active cell.

Accepted Answer

A)  Value 
B)  Input 
C)  Key 
D)  User 
A)  Value 
B)  Input 
C)  Key 
D)  User

Question 11

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 12

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 13

A digital ____________________ is typically issued by a certificate authority.

Accepted Answer

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

Question 14

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

Accepted Answer

The answer of One way to ensure that correct data...

Question 15

To open the Data Validation dialog box, click the DATA tab on the Ribbon, and then click Authentication in the Data Tools group.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  Active Cell 
B)  Criteria 
C)  Settings 
D)  Input Message 
A)  Active Cell 
B)  Criteria 
C)  Settings 
D)  Input Message

Question 18

Case-Based Critical Thinking Questions
Case 7-2
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 19

To create a macro, you can enter 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

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

Accepted Answer

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

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

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

To keep a comment like the one in the accompanying figure on the screen, in the Comments group on the _____ tab, click the Show/Hide Comment button.

A _____ can be destructive and can modify or delete files that may not be recoverable.

Describe the four macro security settings.

In the accompanying figure, the column labeled Refers To is the range s _____.

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.

_____ messages appear as ScreenTips next to the active cell.

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

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

A digital ____________________ is typically issued by a certificate authority.

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

To open the Data Validation dialog box, click the DATA tab on the Ribbon, and then click Authentication in the Data Tools group.

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

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

To create a macro, you can enter a series of commands in the _____ programming language.

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

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters

Exam 7: Excell: Developing an Excel Application

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

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

To keep a comment like the one in the accompanying figure on the screen, in the Comments group on the _____ tab, click the Show/Hide Comment button.

A _____ can be destructive and can modify or delete files that may not be recoverable.

Describe the four macro security settings.

In the accompanying figure, the column labeled Refers To is the range s _____.

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.

_____ messages appear as ScreenTips next to the active cell.

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

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

A digital ____________________ is typically issued by a certificate authority.

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

To open the Data Validation dialog box, click the DATA tab on the Ribbon, and then click Authentication in the Data Tools group.

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

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

To create a macro, you can enter a series of commands in the _____ programming language.

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

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters