Question 1

In a fully qualified structured reference,the table name follows the column qualifier._________________________

Accepted Answer

A) True 
 B)False

Question 2

The Conditional Formatting button provides access to the _____.

Accepted Answer

A)  Replicate Values conditional format 
B)  Manage Rules option 
C)  Criteria option 
D)  Organize Rules option 
A)  Replicate Values conditional format 
B)  Manage Rules option 
C)  Criteria option 
D)  Organize Rules option

Question 3

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 4

The _____ error value means that a value is not available to a function or formula.

Accepted Answer

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

Question 5

Lookup _____ allow you to use tables of data to "look up" values and insert them in another worksheet location.

Accepted Answer

A)  functions 
B)  formulas 
C)  equations 
D)  calculations 
A)  functions 
B)  formulas 
C)  equations 
D)  calculations

Question 6

The _____ function calculates the average of values in a range that match criteria you specify.

Accepted Answer

A)  AVERAGEAS 
B)  AVERAGEOR 
C)  AVERAGEAND 
D)  AVERAGEIF 
A)  AVERAGEAS 
B)  AVERAGEOR 
C)  AVERAGEAND 
D)  AVERAGEIF

Question 7

The IF function evaluates a(n)single condition._________________________

Accepted Answer

A) True 
 B)False

Question 8

You cannot nest more than one IF function to test for multiple outcomes._________________________

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ function searches horizontally across a lookup table and is used when the compare values are stored in the first row of the lookup table.

Accepted Answer

The answer of The ____________________ function searches horizontally across a...

Question 10

____________________ formatting changes a cell's formatting when its contents match a specified condition.

Accepted Answer

The answer of ____________________ formatting changes a cell's formatting when...

Question 11

If you need to modify the formula in a calculated column,you edit the formula in one cell of the column and then you modify the formulas in the remaining cells in that table column.

Accepted Answer

A) True 
 B)False

Question 12

The ____________________ function searches vertically down a lookup table and is used when the compare values are stored in the first column of the lookup table.

Accepted Answer

The answer of The ____________________ function searches vertically down a...

Question 13

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 14

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 one service recognition program,you need to calculate the length of service in complete months.What is the correct formula?

Accepted Answer

A)  =DATEDIF(C2, $AE$2, "m") 
B)  =DATEDIF($AE$2, C2, "month") 
C)  =DATEDIF($AE$2, C2, "mth") 
D)  =DATEDIF(C2, $AE$2, "mon") 
A)  =DATEDIF(C2, $AE$2, "m") 
B)  =DATEDIF($AE$2, C2, "month") 
C)  =DATEDIF($AE$2, C2, "mth") 
D)  =DATEDIF(C2, $AE$2, "mon")

Question 15

All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.

Accepted Answer

A) True 
 B)False

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

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
-On a lark,for a year-end trivia contest,your boss wants you to calculate the length of service in complete days.What is the correct formula?

Accepted Answer

A)  =DATEDIF(C2, $AE$2, "today") 
B)  =DATEDIF($AE$2, C2, "dy") 
C)  =DATEDIF($AE$2, C2, "day") 
D)  =DATEDIF(C2, $AE$2, "d") 
A)  =DATEDIF(C2, $AE$2, "today") 
B)  =DATEDIF($AE$2, C2, "dy") 
C)  =DATEDIF($AE$2, C2, "day") 
D)  =DATEDIF(C2, $AE$2, "d")

Question 18

The _____ function searches vertically down the first column of the lookup table.

Accepted Answer

A)  VLOOK 
B)  VLOOKUP 
C)  HLOOK 
D)  HLOOKUP 
A)  VLOOK 
B)  VLOOKUP 
C)  HLOOK 
D)  HLOOKUP

Question 19

When Excel automatically fills the rest of a table column with a formula entered into an empty table column,this is referred to as a(n)_____ column.

Accepted Answer

A)  concatenated 
B)  calculated 
C)  autofilled 
D)  custom 
A)  concatenated 
B)  calculated 
C)  autofilled 
D)  custom

Question 20

The _____ function calculates the difference between two dates and shows the result in months,days,or years.

Accepted Answer

A)  nested IF 
B)  CALIF 
C)  DATEDIF 
D)  DATE 
A)  nested IF 
B)  CALIF 
C)  DATEDIF 
D)  DATE

In a fully qualified structured reference,the table name follows the column qualifier._________________________

The Conditional Formatting button provides access to the _____.

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 _____ error value means that a value is not available to a function or formula.

Lookup _____ allow you to use tables of data to "look up" values and insert them in another worksheet location.

The _____ function calculates the average of values in a range that match criteria you specify.

The IF function evaluates a(n)single condition._________________________

You cannot nest more than one IF function to test for multiple outcomes._________________________

The ____________________ function searches horizontally across a lookup table and is used when the compare values are stored in the first row of the lookup table.

____________________ formatting changes a cell's formatting when its contents match a specified condition.

If you need to modify the formula in a calculated column,you edit the formula in one cell of the column and then you modify the formulas in the remaining cells in that table column.

The ____________________ function searches vertically down a lookup table and is used when the compare values are stored in the first column of the lookup table.

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

All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.

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.

The _____ function searches vertically down the first column of the lookup table.

When Excel automatically fills the rest of a table column with a formula entered into an empty table column,this is referred to as a(n)_____ column.

The _____ function calculates the difference between two dates and shows the result in months,days,or years.

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

In a fully qualified structured reference,the table name follows the column qualifier._________________________

The Conditional Formatting button provides access to the _____.

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 _____ error value means that a value is not available to a function or formula.

Lookup _____ allow you to use tables of data to "look up" values and insert them in another worksheet location.

The _____ function calculates the average of values in a range that match criteria you specify.

The IF function evaluates a(n)single condition._________________________

You cannot nest more than one IF function to test for multiple outcomes._________________________

The ____________________ function searches horizontally across a lookup table and is used when the compare values are stored in the first row of the lookup table.

____________________ formatting changes a cell's formatting when its contents match a specified condition.

If you need to modify the formula in a calculated column,you edit the formula in one cell of the column and then you modify the formulas in the remaining cells in that table column.

The ____________________ function searches vertically down a lookup table and is used when the compare values are stored in the first column of the lookup table.

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

All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.

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.

The _____ function searches vertically down the first column of the lookup table.

When Excel automatically fills the rest of a table column with a formula entered into an empty table column,this is referred to as a(n)_____ column.

The _____ function calculates the difference between two dates and shows the result in months,days,or years.

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