Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

A(n)____________________ match lookup occurs when the lookup value is found within a range of numbers in the first column (or row)of the lookup table.

Accepted Answer

The answer of A(n)____________________ match lookup occurs when the lookup...

Question 3

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 4

Case 8-1
Evaluate the formula =AND(G2="FT",M2>=1)based upon the information provided.
-What value is returned assuming that G2 contains the value FT and M2 contains the value 2?

Accepted Answer

A)  TRUE 
B)  FALSE 
C)  PT 
D)  PT, 2 
A)  TRUE 
B)  FALSE 
C)  PT 
D)  PT, 2

Question 5

In the DATEDIF function,the first date argument is the latest date._________________________

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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 8

An error value begins with a(n)number sign followed by an error name,which indicates the type of error._________________________

Accepted Answer

A) True 
 B)False

Question 9

You can use a _____ function to return a value from a table that is based on an approximate match lookup.

Accepted Answer

A)  VLOOKUP 
B)  VAVERAGE 
C)  VMATCH 
D)  VAPPROXIMATE 
A)  VLOOKUP 
B)  VAVERAGE 
C)  VMATCH 
D)  VAPPROXIMATE

Question 10

Case 8-2
Your boss in the human resources department asks you to write a function that calculates the length of time that employees have been with the firm,using the DATEDIF function.Assume that C2 contains the hire date for a given employee and that cell $AE$2 contains the cut-off date against which to compare the hire date to determine length of service
-For a separate service recognition program,you need to calculate the length of service in complete years.What is the correct formula?

Accepted Answer

A)  =DATEDIF(C2, $AE$2, "yr") 
B)  =DATEDIF($AE$2, C2, "year") 
C)  =DATEDIF($AE$2, C2, "yr") 
D)  =DATEDIF(C2, $AE$2, "y") 
A)  =DATEDIF(C2, $AE$2, "yr") 
B)  =DATEDIF($AE$2, C2, "year") 
C)  =DATEDIF($AE$2, C2, "yr") 
D)  =DATEDIF(C2, $AE$2, "y")

Question 11

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

Accepted Answer

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

Question 12

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 13

The _____ function calculates the number of cells in a range that match criteria you specify.

Accepted Answer

A)  NUMBERIF 
B)  COUNTIF 
C)  NUMBERAS 
D)  COUNTAS 
A)  NUMBERIF 
B)  COUNTIF 
C)  NUMBERAS 
D)  COUNTAS

Question 14

To change the background fill color of duplicate values,in the _____ group on the Home tab,click the Conditional Formatting button,and then click Manage Rules.

Accepted Answer

A)  Format 
B)  Options 
C)  Styles 
D)  Tools 
A)  Format 
B)  Options 
C)  Styles 
D)  Tools

Question 15

If any logical condition listed in the function is true,the AND function returns a TRUE value._________________________

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

With the DATEDIF function,the _____ interval code means months.

Accepted Answer

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

Question 18

The ORERROR function can determine if a cell contains an error value and then display the message you choose.

Accepted Answer

A) True 
 B)False

Question 19

The ____________________ function adds the values in a range that meet criteria you specify.

Accepted Answer

The answer of The ____________________ function adds the values in...

Question 20

Two common categories of formula errors in Excel are syntax errors and logic errors.

Accepted Answer

A) True 
 B)False

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

A(n)____________________ match lookup occurs when the lookup value is found within a range of numbers in the first column (or row)of the lookup table.

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

Case 8-1 Evaluate the formula =AND(G2="FT",M2>=1)based upon the information provided. -What value is returned assuming that G2 contains the value FT and M2 contains the value 2?

In the DATEDIF function,the first date argument is the latest date._________________________

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

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

An error value begins with a(n)number sign followed by an error name,which indicates the type of error._________________________

You can use a _____ function to return a value from a table that is based on an approximate match lookup.

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

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

The _____ function calculates the number of cells in a range that match criteria you specify.

To change the background fill color of duplicate values,in the _____ group on the Home tab,click the Conditional Formatting button,and then click Manage Rules.

If any logical condition listed in the function is true,the AND function returns a TRUE value._________________________

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

With the DATEDIF function,the _____ interval code means months.

The ORERROR function can determine if a cell contains an error value and then display the message you choose.

The ____________________ function adds the values in a range that meet criteria you specify.

Two common categories of formula errors in Excel are syntax errors and logic errors.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Exploring Financial Tools and Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Working With Text Functions

Filters

Exam 8: Working With Advanced Functions

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

A(n)____________________ match lookup occurs when the lookup value is found within a range of numbers in the first column (or row)of the lookup table.

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

Case 8-1 Evaluate the formula =AND(G2="FT",M2>=1)based upon the information provided. -What value is returned assuming that G2 contains the value FT and M2 contains the value 2?

In the DATEDIF function,the first date argument is the latest date._________________________

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

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

An error value begins with a(n)number sign followed by an error name,which indicates the type of error._________________________

You can use a _____ function to return a value from a table that is based on an approximate match lookup.

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

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

The _____ function calculates the number of cells in a range that match criteria you specify.

To change the background fill color of duplicate values,in the _____ group on the Home tab,click the Conditional Formatting button,and then click Manage Rules.

If any logical condition listed in the function is true,the AND function returns a TRUE value._________________________

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

With the DATEDIF function,the _____ interval code means months.

The ORERROR function can determine if a cell contains an error value and then display the message you choose.

The ____________________ function adds the values in a range that meet criteria you specify.

Two common categories of formula errors in Excel are syntax errors and logic errors.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Exploring Financial Tools and Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Working With Text Functions

Filters