Question 1

Given the flowchart in the accompanying figure a Health Plan value of ____ yields a Health Plan Cost of 875.

Accepted Answer

A) HMOF 
B) HMOI 
C) PPOF 
D) PPOI 
A) HMOF 
B) HMOI 
C) PPOF 
D) PPOI B

Question 2

In the DATEDIF function the first date is the latest date.

Accepted Answer

A) True 
 B)False  False

Question 3

The _________________________ error value appears when text is entered in a function that requires a number.

Accepted Answer

#NUM!

Question 4

Calculated columns work only in ranges of data.

Accepted Answer

A) True 
 B)False

Question 5

In the Styles group on the Home tab click the Conditional Formatting button and then click ____ to open the Conditional Formatting Rules Manager dialog box.

Accepted Answer

A) Conditional Formatting Rules Management 
B) Conditions 
C) Manage Rules 
D) Formatting Rules 
A) Conditional Formatting Rules Management 
B) Conditions 
C) Manage Rules 
D) Formatting Rules

Question 6

When Excel automatically fills the rest of a table column with a formula entered into an empty table column this is referred to as a(n)____ column.

Accepted Answer

A) concatenated 
B) calculated 
C) autofilled 
D) custom 
A) concatenated 
B) calculated 
C) autofilled 
D) custom

Question 7

According to the dialog box in the accompanying figure the HealthPlanRates table contains the data you want to look up.

Accepted Answer

A) True 
 B)False

Question 8

The ____ function returns the minimum value in search column that meets specified criteria.

Accepted Answer

A) DMAX 
B) DMIN 
C) DSTDEV 
D) DSUM 
A) DMAX 
B) DMIN 
C) DSTDEV 
D) DSUM

Question 9

The _________________________ function searches horizontally across a lookup table and is used when the compare values are stored in the first row of the lookup table.

Accepted Answer

The answer of The _________________________ function searches horizontally across a...

Question 10

The ____ error value means that a value is not available to a function or formula.

Accepted Answer

A) #NAME? 
B) #N\A 
C) #NULL! 
D) #NUM 
A) #NAME? 
B) #N\A 
C) #NULL! 
D) #NUM

Question 11

The ____ error value means that a formula or function requires two cell ranges to intersect but they do not.

Accepted Answer

A) #NAME? 
B) #N\A 
C) #NULL! 
D) #NUM 
A) #NAME? 
B) #N\A 
C) #NULL! 
D) #NUM

Question 12

Given the flowchart in the accompanying figure the Pay Grade of ____ yields a Bonus value of 5000.

Accepted Answer

A) 1 
B) 2 
C) 3 
D) 4 
A) 1 
B) 2 
C) 3 
D) 4

Question 13

You can calculate the number of cells in a range that match criteria you specify using the SUMIF function.

Accepted Answer

A) True 
 B)False

Question 14

Given the flowchart in the accompanying figure a Health Plan value of ____ yields a Health Plan Cost of 950.

Accepted Answer

A) HMOF 
B) HMOI 
C) PPOI 
D) None 
A) HMOF 
B) HMOI 
C) PPOI 
D) None

Question 15

The ____ function returns the sum of the values in the summary column that meets specified criteria.

Accepted Answer

A) DMAX 
B) DMIN 
C) DSTDEV 
D) DSUM 
A) DMAX 
B) DMIN 
C) DSTDEV 
D) DSUM

Question 16

Column ____ provide a description of the data entered in each column.

Accepted Answer

A) keys 
B) headers 
C) indices 
D) seals 
A) keys 
B) headers 
C) indices 
D) seals

Question 17

Match between columns
                        Premises: Database function that returns the number of cells containing numbers that meet specified criteria

Accepted Answer

The Answer of DCOUNT and AVERAGEIFS and SUMIFS and AVERAGEIF is...

Question 18

The _________________________ function enables you to display a more descriptive message that helps users fix a problem rather than adding confusion as error values often do.

Accepted Answer

The answer of The _________________________ function enables you to display...

Question 19

The ____ function returns the number of nonblank cells that meets specified criteria.

Accepted Answer

A) DAVERAGE 
B) DCOUNT 
C) DCOUNTA 
D) DMAX 
A) DAVERAGE 
B) DCOUNT 
C) DCOUNTA 
D) DMAX

Question 20

When a lookup value matches a particular ____ value a value from an appropriate column in the lookup table is returned to the cell in which the lookup formula is entered or used as part of a more complex formula.

Accepted Answer

A) key 
B) index 
C) compare 
D) rating 
A) key 
B) index 
C) compare 
D) rating

Given the flowchart in the accompanying figure a Health Plan value of ____ yields a Health Plan Cost of 875.

In the DATEDIF function the first date is the latest date.

The _________________________ error value appears when text is entered in a function that requires a number.

Calculated columns work only in ranges of data.

In the Styles group on the Home tab click the Conditional Formatting button and then click ____ to open the Conditional Formatting Rules Manager dialog box.

When Excel automatically fills the rest of a table column with a formula entered into an empty table column this is referred to as a(n)____ column.

According to the dialog box in the accompanying figure the HealthPlanRates table contains the data you want to look up.

The ____ function returns the minimum value in search column that meets specified criteria.

The _________________________ function searches horizontally across a lookup table and is used when the compare values are stored in the first row of the lookup table.

The ____ error value means that a value is not available to a function or formula.

The ____ error value means that a formula or function requires two cell ranges to intersect but they do not.

Given the flowchart in the accompanying figure the Pay Grade of ____ yields a Bonus value of 5000.

You can calculate the number of cells in a range that match criteria you specify using the SUMIF function.

Given the flowchart in the accompanying figure a Health Plan value of ____ yields a Health Plan Cost of 950.

The ____ function returns the sum of the values in the summary column that meets specified criteria.

Column ____ provide a description of the data entered in each column.

The _________________________ function enables you to display a more descriptive message that helps users fix a problem rather than adding confusion as error values often do.

The ____ function returns the number of nonblank cells that meets specified criteria.

When a lookup value matches a particular ____ value a value from an appropriate column in the lookup table is returned to the cell in which the lookup formula is entered or used as part of a more complex formula.

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: Developing an Excel Application

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 7: Excel: Using Advanced Functions Conditional Formatting and Filtering

Given the flowchart in the accompanying figure a Health Plan value of ____ yields a Health Plan Cost of 875.

In the DATEDIF function the first date is the latest date.

The _________________________ error value appears when text is entered in a function that requires a number.

Calculated columns work only in ranges of data.

In the Styles group on the Home tab click the Conditional Formatting button and then click ____ to open the Conditional Formatting Rules Manager dialog box.

When Excel automatically fills the rest of a table column with a formula entered into an empty table column this is referred to as a(n)____ column.

According to the dialog box in the accompanying figure the HealthPlanRates table contains the data you want to look up.

The ____ function returns the minimum value in search column that meets specified criteria.

The _________________________ function searches horizontally across a lookup table and is used when the compare values are stored in the first row of the lookup table.

The ____ error value means that a value is not available to a function or formula.

The ____ error value means that a formula or function requires two cell ranges to intersect but they do not.

Given the flowchart in the accompanying figure the Pay Grade of ____ yields a Bonus value of 5000.

You can calculate the number of cells in a range that match criteria you specify using the SUMIF function.

Given the flowchart in the accompanying figure a Health Plan value of ____ yields a Health Plan Cost of 950.

The ____ function returns the sum of the values in the summary column that meets specified criteria.

Column ____ provide a description of the data entered in each column.

The _________________________ function enables you to display a more descriptive message that helps users fix a problem rather than adding confusion as error values often do.

The ____ function returns the number of nonblank cells that meets specified criteria.

When a lookup value matches a particular ____ value a value from an appropriate column in the lookup table is returned to the cell in which the lookup formula is entered or used as part of a more complex formula.

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: Developing an Excel Application

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