Question 1

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

Accepted Answer

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

Question 2

If a formula references a cell or range outside the table relative references should be used.

Accepted Answer

A) True 
 B)False

Question 3

According to the dialog box in the accompanying figure the column in the HealthPlanRates lookup table that stores the monthly cost is the first column.

Accepted Answer

A) True 
 B)False

Question 4

Testing for text values is case-sensitive.

Accepted Answer

A) True 
 B)False

Question 5

To get the effect of a calculated column in a range of data you must copy and paste the formula or use the ____ feature.

Accepted Answer

A) Concatenation 
B) Merged 
C) AutoFill 
D) Indexed 
A) Concatenation 
B) Merged 
C) AutoFill 
D) Indexed

Question 6

A(n)_________________________ function is when one IF function is placed inside another IF function to test an additional condition.

Accepted Answer

The answer of A(n)_________________________ function is when one IF function...

Question 7

The _________________________ function can determine if a cell contains an error value and displays the message you choose rather than the default error value.

Accepted Answer

The answer of The _________________________ function can determine if a...

Question 8

An error value begins with a number sign followed by an error name which indicates the type of error.

Accepted Answer

A) True 
 B)False

Question 9

You could test two or more conditions and determine whether all conditions are true using the ____ function.

Accepted Answer

A) OR 
B) IF 
C) AND 
D) THIS 
A) OR 
B) IF 
C) AND 
D) THIS

Question 10

_________________________ values indicate that some element in a formula or a cell referenced in a formula is preventing Excel from returning a calculated value.

Accepted Answer

The answer of _________________________ values indicate that some element in...

Question 11

If all of the logical conditions are true the AND function returns the logical value ____.

Accepted Answer

A) FALSE 
B) ON 
C) TRUE 
D) OFF 
A) FALSE 
B) ON 
C) TRUE 
D) OFF

Question 12

The ____ qualifier references the current row in the specified column of the table.

Accepted Answer

A) #Data 
B) #All 
C) #Headers 
D) #ThisRow 
A) #Data 
B) #All 
C) #Headers 
D) #ThisRow

Question 13

When a lookup table is used with a range of values the compare values must be sorted in alphabetical order if they are text.

Accepted Answer

A) True 
 B)False

Question 14

Each time you create a conditional format you are defining a conditional formatting ____.

Accepted Answer

A) theme 
B) object 
C) condition 
D) rule 
A) theme 
B) object 
C) condition 
D) rule

Question 15

Press the ____ keys to move to the top of the table.

Accepted Answer

A) Alt+Home 
B) Shift+Home 
C) Ctrl+Home 
D) Esc+Home 
A) Alt+Home 
B) Shift+Home 
C) Ctrl+Home 
D) Esc+Home

Question 16

The ____ error value means that invalid numbers are used in a formula or function.

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

The #VALUE! error value can occur when a cell used by the function was deleted from the worksheet.

Accepted Answer

A) True 
 B)False

Question 19

When you create a calculated column you can use ____ references to create the formula.

Accepted Answer

A) indexed 
B) structured 
C) key 
D) logical 
A) indexed 
B) structured 
C) key 
D) logical

Question 20

You can use the ____ to combine multiple fields into one cell.

Accepted Answer

A) ampersand 
B) caret 
C) pound sign 
D) percent symbol 
A) ampersand 
B) caret 
C) pound sign 
D) percent symbol

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

If a formula references a cell or range outside the table relative references should be used.

According to the dialog box in the accompanying figure the column in the HealthPlanRates lookup table that stores the monthly cost is the first column.

Testing for text values is case-sensitive.

To get the effect of a calculated column in a range of data you must copy and paste the formula or use the ____ feature.

A(n)_________________________ function is when one IF function is placed inside another IF function to test an additional condition.

The _________________________ function can determine if a cell contains an error value and displays the message you choose rather than the default error value.

An error value begins with a number sign followed by an error name which indicates the type of error.

You could test two or more conditions and determine whether all conditions are true using the ____ function.

_________________________ values indicate that some element in a formula or a cell referenced in a formula is preventing Excel from returning a calculated value.

If all of the logical conditions are true the AND function returns the logical value ____.

The ____ qualifier references the current row in the specified column of the table.

When a lookup table is used with a range of values the compare values must be sorted in alphabetical order if they are text.

Each time you create a conditional format you are defining a conditional formatting ____.

Press the ____ keys to move to the top of the table.

The ____ error value means that invalid numbers are used in a formula or function.

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

The #VALUE! error value can occur when a cell used by the function was deleted from the worksheet.

When you create a calculated column you can use ____ references to create the formula.

You can use the ____ to combine multiple fields into one cell.

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

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

If a formula references a cell or range outside the table relative references should be used.

According to the dialog box in the accompanying figure the column in the HealthPlanRates lookup table that stores the monthly cost is the first column.

Testing for text values is case-sensitive.

To get the effect of a calculated column in a range of data you must copy and paste the formula or use the ____ feature.

A(n)_________________________ function is when one IF function is placed inside another IF function to test an additional condition.

The _________________________ function can determine if a cell contains an error value and displays the message you choose rather than the default error value.

An error value begins with a number sign followed by an error name which indicates the type of error.

You could test two or more conditions and determine whether all conditions are true using the ____ function.

_________________________ values indicate that some element in a formula or a cell referenced in a formula is preventing Excel from returning a calculated value.

If all of the logical conditions are true the AND function returns the logical value ____.

The ____ qualifier references the current row in the specified column of the table.

When a lookup table is used with a range of values the compare values must be sorted in alphabetical order if they are text.

Each time you create a conditional format you are defining a conditional formatting ____.

Press the ____ keys to move to the top of the table.

The ____ error value means that invalid numbers are used in a formula or function.

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

The #VALUE! error value can occur when a cell used by the function was deleted from the worksheet.

When you create a calculated column you can use ____ references to create the formula.

You can use the ____ to combine multiple fields into one cell.

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