Question 1

The ____ error value means that for example a function name is misspelled.

Accepted Answer

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

Question 2

You can ____ IF functions to allow for three or more outcomes.

Accepted Answer

A) loop 
B) cycle 
C) nest 
D) link 
A) loop 
B) cycle 
C) nest 
D) link

Question 3

In an unqualified structured reference only the column qualifier appears in the reference.

Accepted Answer

A) True 
 B)False

Question 4

The ____ qualifier references the data in the table.

Accepted Answer

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

Question 5

When you want to reference an entire column of data in a table you create a column ____.

Accepted Answer

A) label 
B) name 
C) variable 
D) qualifier 
A) label 
B) name 
C) variable 
D) qualifier

Question 6

If you need to track information such as the specific age a best practice is to use calculations to determine this value based on values in the Birth Date field.

Accepted Answer

A) True 
 B)False

Question 7

Even if the compare values are not arranged in order Excel can still retrieve the correct results from a lookup table.

Accepted Answer

A) True 
 B)False

Question 8

The _________________________ error value means that a cell reference used in a formula or function is no longer valid.

Accepted Answer

The answer of The _________________________ error value means that a...

Question 9

If you use a structured reference outside a table or in another worksheet to reference an Excel table or portion of the table you need to use a(n)unqualified reference.

Accepted Answer

A) True 
 B)False

Question 10

The ____ error value occurs when an invalid value is specified in the LOOKUP function.

Accepted Answer

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

Question 11

The #REF! error value can occur when you supply a range of values to a function that requires a single value.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

The complete formula that corresponds to the flowchart in the accompanying figure is ____.

Accepted Answer

A) =IF(Pay Grade=1 2500 IF(Pay Grade=2 5000 IF(Pay Grade=3 7500 "Invalid pay grade"))) 
B) =IF[Pay Grade]=1 2500 IF[Pay Grade]=2 5000 IF[Pay Grade]=3 7500 "Invalid pay grade" 
C) =IF([Pay Grade]=1 2500 IF([Pay Grade]=2 5000 IF([Pay Grade]=3 7500 "Invalid pay grade"))) 
D) =IF 
A) =IF(Pay Grade=1 2500 IF(Pay Grade=2 5000 IF(Pay Grade=3 7500 "Invalid pay grade"))) 
B) =IF[Pay Grade]=1 2500 IF[Pay Grade]=2 5000 IF[Pay Grade]=3 7500 "Invalid pay grade" 
C) =IF([Pay Grade]=1 2500 IF([Pay Grade]=2 5000 IF([Pay Grade]=3 7500 "Invalid pay grade"))) 
D) =IF

Question 14

You can edit existing conditional formatting ____ from the Conditional Formatting Rules Manager dialog box.

Accepted Answer

A) themes 
B) objects 
C) conditions 
D) rules 
A) themes 
B) objects 
C) conditions 
D) rules

Question 15

Match between columns
                        Premises: Database function that returns the sum of the values in the summary column that meets specified criteria

Accepted Answer

The Answer of DAVERAGE and DMIN and AVERAGEIFS and DSTDEV is...

Question 16

If you see ____ as the result of a VLOOKUP formula you might have entered a letter for the col_index_num instead of a number.

Accepted Answer

A) #NULL 
B) #REF? 
C) #NAME? 
D) #DIV\0 
A) #NULL 
B) #REF? 
C) #NAME? 
D) #DIV\0

Question 17

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

Accepted Answer

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

Question 18

You can include up to ____ logical conditions in the AND function.

Accepted Answer

A) 25 
B) 50 
C) 225 
D) 255 
A) 25 
B) 50 
C) 225 
D) 255

Question 19

You cannot nest more than one IF function.

Accepted Answer

A) True 
 B)False

Question 20

The ____ function returns the average of the values that meet specified criteria.

Accepted Answer

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

The ____ error value means that for example a function name is misspelled.

You can ____ IF functions to allow for three or more outcomes.

In an unqualified structured reference only the column qualifier appears in the reference.

The ____ qualifier references the data in the table.

When you want to reference an entire column of data in a table you create a column ____.

If you need to track information such as the specific age a best practice is to use calculations to determine this value based on values in the Birth Date field.

Even if the compare values are not arranged in order Excel can still retrieve the correct results from a lookup table.

The _________________________ error value means that a cell reference used in a formula or function is no longer valid.

If you use a structured reference outside a table or in another worksheet to reference an Excel table or portion of the table you need to use a(n)unqualified reference.

The ____ error value occurs when an invalid value is specified in the LOOKUP function.

The #REF! error value can occur when you supply a range of values to a function that requires a single value.

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

The complete formula that corresponds to the flowchart in the accompanying figure is ____.

You can edit existing conditional formatting ____ from the Conditional Formatting Rules Manager dialog box.

If you see ____ as the result of a VLOOKUP formula you might have entered a letter for the col_index_num instead of a number.

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

You can include up to ____ logical conditions in the AND function.

You cannot nest more than one IF function.

The ____ function returns the average of the values that meet specified criteria.

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 ____ error value means that for example a function name is misspelled.

You can ____ IF functions to allow for three or more outcomes.

In an unqualified structured reference only the column qualifier appears in the reference.

The ____ qualifier references the data in the table.

When you want to reference an entire column of data in a table you create a column ____.

If you need to track information such as the specific age a best practice is to use calculations to determine this value based on values in the Birth Date field.

Even if the compare values are not arranged in order Excel can still retrieve the correct results from a lookup table.

The _________________________ error value means that a cell reference used in a formula or function is no longer valid.

If you use a structured reference outside a table or in another worksheet to reference an Excel table or portion of the table you need to use a(n)unqualified reference.

The ____ error value occurs when an invalid value is specified in the LOOKUP function.

The #REF! error value can occur when you supply a range of values to a function that requires a single value.

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

The complete formula that corresponds to the flowchart in the accompanying figure is ____.

You can edit existing conditional formatting ____ from the Conditional Formatting Rules Manager dialog box.

If you see ____ as the result of a VLOOKUP formula you might have entered a letter for the col_index_num instead of a number.

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

You can include up to ____ logical conditions in the AND function.

You cannot nest more than one IF function.

The ____ function returns the average of the values that meet specified criteria.

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