Question 1

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 2

In the Allow list box in the Data Validation dialog box, the ____________________ option means that the cell will accept any value entered into the cell.

Accepted Answer

The answer of In the Allow list box in the...

Question 3

To remove workbook protection, click the Unprotect Workbook button in the _____ group on the REVIEW tab.

Accepted Answer

A)  Format 
B)  Changes 
C)  Sheet 
D)  Options 
A)  Format 
B)  Changes 
C)  Sheet 
D)  Options

Question 4

Match between columns
                        Premises: Error alert that accepts the invalid data but still allows you to cancel the data entry

Accepted Answer

The Answer of digital certificate and Information and locked and is...

Question 5

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.
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 6

The Name dialog box lists all of the names currently defined in the workbook, including Excel table names.

Accepted Answer

A) True 
 B)False

Question 7

Match between columns
                        Premises: Appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell

Accepted Answer

The Answer of macro and validation rule and locked and is...

Question 8

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,...

Question 9

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

Accepted Answer

A)  Integer 
B)  Decimal 
C)  Numerical 
D)  Whole Number 
A)  Integer 
B)  Decimal 
C)  Numerical 
D)  Whole Number

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Match between columns
                        Premises: Word or string of characters associated with a single cell or a range

Accepted Answer

The Answer of defined name and input message and Stop is...

Question 12

Defined names are automatically substituted for existing range references in a formula.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

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.
What phrase could Rina use to best describe a digital signature?

Accepted Answer

A)  a merit badge 
B)  an indication of value 
C)  an invitation to collaborate 
D)  a seal of approval 
A)  a merit badge 
B)  an indication of value 
C)  an invitation to collaborate 
D)  a seal of approval

Question 16

To view the code of a macro, you need to open the Visual Basic _____.

Accepted Answer

A)  Manager 
B)  Code Window 
C)  Reader 
D)  Editor 
A)  Manager 
B)  Code Window 
C)  Reader 
D)  Editor

Question 17

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 18

What are the steps for creating a validation rule?

Accepted Answer

In the Data Tools group on the DATA tab,

Question 19

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 20

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

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

In the Allow list box in the Data Validation dialog box, the ____________________ option means that the cell will accept any value entered into the cell.

To remove workbook protection, click the Unprotect Workbook button in the _____ group on the REVIEW tab.

The Name dialog box lists all of the names currently defined in the workbook, including Excel table names.

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

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

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

Defined names are automatically substituted for existing range references in a formula.

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

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

To view the code of a macro, you need to open the Visual Basic _____.

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

What are the steps for creating a validation rule?

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

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.

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 Excel data _____ feature restricts data entry to follow a defined set of rules.

In the Allow list box in the Data Validation dialog box, the ____________________ option means that the cell will accept any value entered into the cell.

To remove workbook protection, click the Unprotect Workbook button in the _____ group on the REVIEW tab.

The Name dialog box lists all of the names currently defined in the workbook, including Excel table names.

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

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

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

Defined names are automatically substituted for existing range references in a formula.

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

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

To view the code of a macro, you need to open the Visual Basic _____.

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

What are the steps for creating a validation rule?

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

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.

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