Question 1

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 2

Case-Based Critical Thinking Questions 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")

Question 3

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

Question 4

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

Question 5

In the Edit Formatting Rule dialog box, click the _____ button to open the Format Cells dialog box.

Accepted Answer

A) Format Cells 
B) Options 
C) Format 
D) Cell Tools

Question 6

For conditional formatting, a formula must be in the form of a(n)_____ test that results in a true or false value.

Accepted Answer

A) conditional 
B) hypothetical 
C) logical 
D) approximate

Question 7

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 8

Case-Based Critical Thinking Questions Case 8-3 You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use. ​ Which of the following is an effective alternative for the use of extensive nested IF functions?

Accepted Answer

A) compare table 
B) function table 
C) lookup table 
D) case table

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Question 12

Nesting IF functions will allow for three or more outcomes.

Accepted Answer

A) True 
 B)False

Question 13

You can edit existing conditional formatting rules from the Conditional Formatting _____ dialog box. Click the Edit Rule button and make the appropriate changes.

Accepted Answer

A) Rules Editor 
B) Rules Manager 
C) Editor 
D) Manager

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Case-Based Critical Thinking Questions 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 PT and M2 contains the value 2?

Accepted Answer

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

Exam 8: Excel 4: Working With Advanced Functions

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 calculates the number of cells in a range that match criteria you specify.

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

In the Edit Formatting Rule dialog box, click the _____ button to open the Format Cells dialog box.

For conditional formatting, a formula must be in the form of a(n) _____ test that results in a true or false value.

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 any logical condition listed in the function is true, the AND function returns a TRUE value. _________________________

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

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

Nesting IF functions will allow for three or more outcomes.

You can edit existing conditional formatting rules from the Conditional Formatting _____ dialog box. Click the Edit Rule button and make the appropriate changes.

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

Case-Based Critical Thinking Questions 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 PT and M2 contains the value 2?

Exam 8: Excel 4: Working With Advanced Functions

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 calculates the number of cells in a range that match criteria you specify.

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

In the Edit Formatting Rule dialog box, click the _____ button to open the Format Cells dialog box.

For conditional formatting, a formula must be in the form of a(n) _____ test that results in a true or false value.

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 any logical condition listed in the function is true, the AND function returns a TRUE value. _________________________

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

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

Nesting IF functions will allow for three or more outcomes.

You can edit existing conditional formatting rules from the Conditional Formatting _____ dialog box. Click the Edit Rule button and make the appropriate changes.

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

Case-Based Critical Thinking Questions 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 PT and M2 contains the value 2?

Case-Based Critical Thinking Questions 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 PT and M2 contains the value 2?