Question 1

The red triangle in the accompanying figure indicates that a given cell does not have a comment.

Accepted Answer

A) True 
 B)False  False

Question 2

Using the Excel data validation feature you can specify a(n)____ of acceptable values.

Accepted Answer

A) roster 
B) series 
C) array 
D) range 
A) roster 
B) series 
C) array 
D) range D

Question 3

A digital ____________________ is typically issued by a certificate authority.

Accepted Answer

certificate

Question 4

If you select the Custom option in the Allow list box in the Data Validation dialog box the validation rule will be based on an Excel logistical formula.

Accepted Answer

A) True 
 B)False

Question 5

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 Excel application and Stop and defined name is...

Question 6

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 7

For simple macros it is easier to create a macro using the macro ____.

Accepted Answer

A) recorder 
B) manager 
C) explorer 
D) programmer 
A) recorder 
B) manager 
C) explorer 
D) programmer

Question 8

The ____________________ alert prevents you from storing the data in the cell.

Accepted Answer

The answer of The ____________________ alert prevents you from storing...

Question 9

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 10

You can create a(n)____________________ key that will run a macro directly from the keyboard.

Accepted Answer

The answer of You can create a(n)____________________ key that will...

Question 11

In the Allow list box in the Data Validation dialog box the ____________________ option means that the cell will accept only dates.

Accepted Answer

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

Question 12

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) runtime 
C) logic 
D) baseline 
A) syntax 
B) runtime 
C) logic 
D) baseline

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

Even if a sheet is protected you can limit the user to selecting only unlocked cells or allow the user to select any cell in the worksheet.

Accepted Answer

A) True 
 B)False

Question 17

The most serious error alert is the ____ alert.

Accepted Answer

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

Question 18

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

Accepted Answer

The Answer of digital certificate and VBA and Stop and is...

Question 19

If a formula uses a defined name that doesn't exist ____ appears in the cell.

Accepted Answer

A) #DEF? 
B) #NAME? 
C) #REF? 
D) #CELL? 
A) #DEF? 
B) #NAME? 
C) #REF? 
D) #CELL?

Question 20

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

The red triangle in the accompanying figure indicates that a given cell does not have a comment.

Using the Excel data validation feature you can specify a(n)____ of acceptable values.

A digital ____________________ is typically issued by a certificate authority.

If you select the Custom option in the Allow list box in the Data Validation dialog box the validation rule will be based on an Excel logistical formula.

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

For simple macros it is easier to create a macro using the macro ____.

The ____________________ alert prevents you from storing the data in the cell.

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

You can create a(n)____________________ key that will run a macro directly from the keyboard.

In the Allow list box in the Data Validation dialog box the ____________________ option means that the cell will accept only dates.

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.

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

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

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

Even if a sheet is protected you can limit the user to selecting only unlocked cells or allow the user to select any cell in the worksheet.

The most serious error alert is the ____ alert.

If a formula uses a defined name that doesn't exist ____ appears in the cell.

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

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

Exce: Working With Excel Tables Pivottables and Pivotcharts

Excel: Managing Multiple Worksheets and Workbooks

Excel: Using Advanced Functions Conditional Formatting and Filtering

Powerpoint: Adding Special Effects to a Presentation

Powerpoint: Integrating Powerpoint With Other Programs and Collaborating With Workgroups

Word: Working With Templates and Outlines

Word: Using Mail Merge

Word: Collaborating With Others and Creating Web Pages

Filters

Exam 8: Excel: Developing an Excel Application

The red triangle in the accompanying figure indicates that a given cell does not have a comment.

Using the Excel data validation feature you can specify a(n)____ of acceptable values.

A digital ____________________ is typically issued by a certificate authority.

If you select the Custom option in the Allow list box in the Data Validation dialog box the validation rule will be based on an Excel logistical formula.

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

For simple macros it is easier to create a macro using the macro ____.

The ____________________ alert prevents you from storing the data in the cell.

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

You can create a(n)____________________ key that will run a macro directly from the keyboard.

In the Allow list box in the Data Validation dialog box the ____________________ option means that the cell will accept only dates.

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.

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

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

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

Even if a sheet is protected you can limit the user to selecting only unlocked cells or allow the user to select any cell in the worksheet.

The most serious error alert is the ____ alert.

If a formula uses a defined name that doesn't exist ____ appears in the cell.

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.

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

Exce: Working With Excel Tables Pivottables and Pivotcharts

Excel: Managing Multiple Worksheets and Workbooks

Excel: Using Advanced Functions Conditional Formatting and Filtering

Powerpoint: Adding Special Effects to a Presentation

Powerpoint: Integrating Powerpoint With Other Programs and Collaborating With Workgroups

Word: Working With Templates and Outlines

Word: Using Mail Merge

Word: Collaborating With Others and Creating Web Pages

Filters

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