Question 1

____ the top portion of the column header in an Excel table to select the column data but not the header.

Accepted Answer

A) Click 
B) Double-click 
C) Triple-click 
D) Right-click

Question 2

Given the flowchart in the accompanying figure the Pay Grade of ____ yields a Bonus value of Invalid pay grade.

Accepted Answer

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

Question 3

The ____ error value means that Excel does not recognize text in the formula or function.

Accepted Answer

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

Question 4

Match between columns
                        Premises: Adds values in a range that meet multiple criteria

Accepted Answer

The Answer of DAVERAGE and DCOUNTA and COUNTIF and DSUM is...

Question 5

The _________________________ function is a logical function that returns a TRUE value if all the logical conditions are true and a FALSE value if any or all of the logical conditions are false.

Accepted Answer

The answer of The _________________________ function is a logical function...

Question 6

Match between columns
                        Premises: Database function that returns the estimate of standard deviation based on a sample of entries that meet the specified criteria

Accepted Answer

The Answer of AVERAGEIF and AVERAGEIFS and DSTDEV and COUNTIFS is...

Question 7

When you create a formula that references all or parts of an Excel table you can replace the specific cell or range address with a(n)_________________________ reference the actual table name or column header.

Accepted Answer

The answer of When you create a formula that references...

Question 8

With the DATEIF function the ____ interval code means months.

Accepted Answer

A) m 
B) mo 
C) mon 
D) mth

Question 9

The ____ function is a logical function that evaluates a condition and then returns one value if the condition is true and another value if the condition is false.

Accepted Answer

A) THIS 
B) IF 
C) WHEN 
D) NOT

Question 10

The COUNTIF function is sometimes referred to as a(n)____ count.

Accepted Answer

A) network 
B) criterion 
C) conditional 
D) basic

Question 11

If you are creating a calculated column or formula within an Excel table you can use the ____ structured reference in the formula.

Accepted Answer

A) basic 
B) advanced 
C) unqualified 
D) restricted

Question 12

Match between columns
                        Premises: Database function that returns the minimum value in search column that meets specified criteria

Accepted Answer

The Answer of AVERAGEIF and COUNTIFS and DAVERAGE and DSUM is...

Question 13

An alternative to using several nested IF functions is to use a ____ table.

Accepted Answer

A) lookup 
B) value 
C) comparison 
D) rating

Question 14

If you are not sure of a table's name click in the table click the ____ tab on the Ribbon and then click the Table Name box in the Properties group.

Accepted Answer

A) Layout 
B) Format 
C) Table Tools Design 
D) Structured References

Question 15

The ____ range is an area in a worksheet used to specify the criteria for the data to be displayed after the filter is applied to the table.

Accepted Answer

A) conditional 
B) prefilter 
C) criteria 
D) task

Question 16

____ the top portion of a column header in an Excel table to select the entire column including the column header.

Accepted Answer

A) Click 
B) Double-click 
C) Triple-click 
D) Right-click

Question 17

The SUMIFS and AVERAGEIFS functions have identical syntax.

Accepted Answer

A) True 
 B)False

Question 18

With the AVERAGEIFS function the associated criteria can be evaluated up to 127 ranges.

Accepted Answer

A) True 
 B)False

Question 19

A formula that includes a structured reference can be fully qualified or unqualified.

Accepted Answer

A) True 
 B)False

Question 20

The ____ function returns the estimate of standard deviation based on a sample of entries that meet the specified criteria.

Accepted Answer

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

Exam 7: Excel: Using Advanced Functions Conditional Formatting and Filtering

____ the top portion of the column header in an Excel table to select the column data but not the header.

Given the flowchart in the accompanying figure the Pay Grade of ____ yields a Bonus value of Invalid pay grade.

The ____ error value means that Excel does not recognize text in the formula or function.

Identify the letter of the choice that best matches the phrase or definition.

The _________________________ function is a logical function that returns a TRUE value if all the logical conditions are true and a FALSE value if any or all of the logical conditions are false.

Identify the letter of the choice that best matches the phrase or definition.

When you create a formula that references all or parts of an Excel table you can replace the specific cell or range address with a(n)_________________________ reference the actual table name or column header.

With the DATEIF function the ____ interval code means months.

The ____ function is a logical function that evaluates a condition and then returns one value if the condition is true and another value if the condition is false.

The COUNTIF function is sometimes referred to as a(n) ____ count.

If you are creating a calculated column or formula within an Excel table you can use the ____ structured reference in the formula.

Identify the letter of the choice that best matches the phrase or definition.

An alternative to using several nested IF functions is to use a ____ table.

If you are not sure of a table's name click in the table click the ____ tab on the Ribbon and then click the Table Name box in the Properties group.

The ____ range is an area in a worksheet used to specify the criteria for the data to be displayed after the filter is applied to the table.

____ the top portion of a column header in an Excel table to select the entire column including the column header.

The SUMIFS and AVERAGEIFS functions have identical syntax.

With the AVERAGEIFS function the associated criteria can be evaluated up to 127 ranges.

A formula that includes a structured reference can be fully qualified or unqualified.

The ____ function returns the estimate of standard deviation based on a sample of entries that meet the specified criteria.