Question 1

In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only text of a specified number of characters.

Accepted Answer

A)  Custom 
B)  Text Length 
C)  Any Value 
D)  Specified Text 
A)  Custom 
B)  Text Length 
C)  Any Value 
D)  Specified Text

Question 2

Match between columns
                        Premises: Programming language that allows you to create macros

Accepted Answer

The Answer of Warning and defined name and validation rule is...

Question 3

Using defined names like those shown in the accompanying figure makes creating and understanding a(n) _____ easier.

Accepted Answer

A)  index 
B)  log 
C)  formula 
D)  workbook 
A)  index 
B)  log 
C)  formula 
D)  workbook

Question 4

The ____________________ alert, by default, rejects the invalid data, but allows you to override the rejection.

Accepted Answer

The answer of The ____________________ alert, by default, rejects the...

Question 5

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 6

Match between columns
                        Premises: Error alert that prevents you from storing the data in the cell

Accepted Answer

The Answer of Stop and Warning and Information and digital is...

Question 7

The _____ alert accepts the invalid data but still allows you to cancel the data entry.

Accepted Answer

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

Question 8

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.
Based on what she has learned, which of the following would Rina say is a true statement about digital signatures?

Accepted Answer

A)  Adding a digital signature is the first step before you distribute a file. 
B)  A digital signature is often used to identify the author of a workbook that contains macros. 
C)  Before you can add a digital ID to a workbook, you need to obtain a digital signature. 
D)  Digital certificates are usually issued by Microsoft. 
A)  Adding a digital signature is the first step before you distribute a file. 
B)  A digital signature is often used to identify the author of a workbook that contains macros. 
C)  Before you can add a digital ID to a workbook, you need to obtain a digital signature. 
D)  Digital certificates are usually issued by Microsoft.

Question 9

Match between columns
                        Premises: Series of stored commands

Accepted Answer

The Answer of input message and VBA and Information and is...

Question 10

The following are Excel-supported error alert types: _____.

Accepted Answer

A)  Stop, Warning, and Alert 
B)  Alert, Warning, and Information 
C)  Security, Warning, and Alert 
D)  Stop, Warning, and Information 
A)  Stop, Warning, and Alert 
B)  Alert, Warning, and Information 
C)  Security, Warning, and Alert 
D)  Stop, Warning, and Information

Question 11

A digital ____________________ is often used to identify the author of a workbook that contains macros.

Accepted Answer

The answer of A digital ____________________ is often used to...

Question 12

Each macro must have a unique name that begins with a letter.

Accepted Answer

A) True 
 B)False

Question 13

A(n) ____________________ is a series of stored commands that can be run whenever you need to perform a task.

Accepted Answer

The answer of A(n) ____________________ is a series of stored...

Question 14

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

Accepted Answer

Some advantages to using defined names i

Question 15

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 16

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 17

Match between columns
                        Premises: Error alert that rejects invalid data but allows you to override the rejection

Accepted Answer

The Answer of validation rule and defined name and Warning is...

Question 18

Range names can be up to _____ characters.

Accepted Answer

A)  15 
B)  27 
C)  56 
D)  255 
A)  15 
B)  27 
C)  56 
D)  255

Question 19

Case-Based Critical Thinking Questions
Case 7-1
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.
After a year of work, Ted is taking coursework to become a VBA programmer. He is working on developing an application that contains macros. Which 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 20

A(n) ____________________ is a text box that is attached to a specific cell in a worksheet.

Accepted Answer

The answer of A(n) ____________________ is a text box that...

In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only text of a specified number of characters.

Using defined names like those shown in the accompanying figure makes creating and understanding a(n) _____ easier.

The ____________________ alert, by default, rejects the invalid data, but allows you to override the rejection.

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

The _____ alert accepts the invalid data but still allows you to cancel the data entry.

The following are Excel-supported error alert types: _____.

A digital ____________________ is often used to identify the author of a workbook that contains macros.

Each macro must have a unique name that begins with a letter.

A(n) ____________________ is a series of stored commands that can be run whenever you need to perform a task.

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

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

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

Range names can be up to _____ characters.

A(n) ____________________ is a text box that is attached to a specific cell in a worksheet.

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

In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only text of a specified number of characters.

Using defined names like those shown in the accompanying figure makes creating and understanding a(n) _____ easier.

The ____________________ alert, by default, rejects the invalid data, but allows you to override the rejection.

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

The _____ alert accepts the invalid data but still allows you to cancel the data entry.

The following are Excel-supported error alert types: _____.

A digital ____________________ is often used to identify the author of a workbook that contains macros.

Each macro must have a unique name that begins with a letter.

A(n) ____________________ is a series of stored commands that can be run whenever you need to perform a task.

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

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

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

Range names can be up to _____ characters.

A(n) ____________________ is a text box that is attached to a specific cell in a worksheet.

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