Question 1

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

Question 2

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

Accepted Answer

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

Question 3

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 4

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

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

Question 6

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 7

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

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 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

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

Question 13

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 14

The ____ qualifier references the data in the table.

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

You cannot nest more than one IF function.

Accepted Answer

A) True 
 B)False

Question 20

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

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

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

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

The ____ qualifier references the data in the table.

Correct Answer
verified

You cannot nest more than one IF function.

Correct Answer
verified

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

Correct Answer
verified

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

The ____ qualifier references the data in the table.

Correct AnswerverifiedShow Answer

You cannot nest more than one IF function.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified