Question 1

In a VLOOKUP function, the argument ____ refers to the range containing the data that you want to search to find the lookup value.

Accepted Answer

A)  lookup_value 
B)  table_array 
C)  col_index_num 
D)  range_lookup 
A)  lookup_value 
B)  table_array 
C)  col_index_num 
D)  range_lookup

Question 2

The ISBLANK function checks whether a specified value refers to an empty cell. The syntax of this function is as follows: =ISBLANK(____________________).

Accepted Answer

The answer of The ISBLANK function checks whether a specified...

Question 3

If a product or company has more than three or four pricing structures, a relational database, such as Microsoft ____________________, might be a better choice than using a spreadsheet program.

Accepted Answer

The answer of If a product or company has more...

Question 4

The ISBLANK function tests for a(n) ____.

Accepted Answer

A)  blank cell 
B)  error message resulting from the use of a blank cell in your formula 
C)  both a and b 
D)  neither a nor b 
A)  blank cell 
B)  error message resulting from the use of a blank cell in your formula 
C)  both a and b 
D)  neither a nor b

Question 5

Identify the letter of the choice that best matches the function definition and arguments.
-area_num

Accepted Answer

A) #1 
B) #2 
C) #3 
D) #4 
E) #5 
A) #1 
B) #2 
C) #3 
D) #4 
E) #5

Question 6

When solving an HLOOKUP formula, Excel looks up a value by testing for a criterion across a ____.

Accepted Answer

A)  row 
B)  column 
C)  table 
D)  worksheet 
A)  row 
B)  column 
C)  table 
D)  worksheet

Question 7

When you use a lookup type of TRUE, the VLOOKUP function looks only for an exact match of the lookup value.

Accepted Answer

A) True 
 B)False

Question 8

The ____ function allows you to retrieve data from multidimensional tables.

Accepted Answer

A)  INDEX 
B)  LOOKUP 
C)  VLOOKUP 
D)  HLOOKUP 
A)  INDEX 
B)  LOOKUP 
C)  VLOOKUP 
D)  HLOOKUP

Question 9

If the lookup_value is less than the smallest value in the lookup_vector, LOOKUP displays ____.

Accepted Answer

A)  an error symbol 
B)  the LOOKUP wizard 
C)  the number 0 
D)  the number 100 
A)  an error symbol 
B)  the LOOKUP wizard 
C)  the number 0 
D)  the number 100

Question 10

Range names copy absolutely.

Accepted Answer

A) True 
 B)False

Question 11

Case 5-1
   
Violet is learning how to use the MATCH function and is testing several different formulas. The chart above shows orders for small robot toys from five different customers. The amount "0" in column A is for a customer who changed his mind. Please answer the questions below using the data in the figure above.
-The Customer Service department tells Violet there is a 25% discount on orders of 500 toys or more. Violet knows there is only one order that large, for 1000 toys, so which of the following formulas does she write to find the position of this order?

Accepted Answer

A)  =MATCH(1000,25%,A1:E1,1) 
B)  =MATCH(1000,A1:E1,0) 
C)  =MATCH(1000,{1000,100,50,25,0},0) 
D)  =MATCH(A1:E1,0,1000) 
A)  =MATCH(1000,25%,A1:E1,1) 
B)  =MATCH(1000,A1:E1,0) 
C)  =MATCH(1000,{1000,100,50,25,0},0) 
D)  =MATCH(A1:E1,0,1000)

Question 12

You could write a formula using the ____________________ function to check whether cell A5 contains text.

Accepted Answer

The answer of You could write a formula using the...

Question 13

The function named IFERROR combines aspects of the IF function and the ____ function.

Accepted Answer

A)  OFERROR 
B)  ISERROR 
C)  ISBLANK 
D)  VLOOKUP 
A)  OFERROR 
B)  ISERROR 
C)  ISBLANK 
D)  VLOOKUP

Question 14

Identify the letter of the choice that best matches the function definition and arguments.
-row_num

Accepted Answer

A) #1 
B) #2 
C) #3 
D) #4 
E) #5 
A) #1 
B) #2 
C) #3 
D) #4 
E) #5

Question 15

The INDEX function argument ____________________ refers to the number of the row in the range referenced in the first argument.

Accepted Answer

The answer of The INDEX function argument ____________________ refers to...

Question 16

A VLOOKUP table can have ____ key value(s) in each cell of its first column.

Accepted Answer

A)  one 
B)  two 
C)  three 
D)  four or more 
A)  one 
B)  two 
C)  three 
D)  four or more

Question 17

When using an INDEX function, if you enter a row_num, column_num, or area_num outside of the range you referenced in the first argument, Excel displays ____.

Accepted Answer

A)  an error message 
B)  the INDEX wizard 
C)  the next nearest column or row 
D)  none of the above 
A)  an error message 
B)  the INDEX wizard 
C)  the next nearest column or row 
D)  none of the above

Question 18

With ____________________, you can specify your own text (or even a blank cell) when an error is encountered rather than the standard Excel message.

Accepted Answer

The answer of With ____________________, you can specify your own...

Question 19

The ____ function is designed to return the relative position (such as 1, 2, or 3) of an item in a list.

Accepted Answer

A)  MATCH 
B)  RELATIVE 
C)  POSITION 
D)  LIST 
A)  MATCH 
B)  RELATIVE 
C)  POSITION 
D)  LIST

Question 20

Excel provides nine functions, called the OF functions, that test a value or cell reference, and then return a TRUE or FALSE value depending on the results. _________________________

Accepted Answer

A) True 
 B)False

In a VLOOKUP function, the argument ____ refers to the range containing the data that you want to search to find the lookup value.

The ISBLANK function checks whether a specified value refers to an empty cell. The syntax of this function is as follows: =ISBLANK(____________________).

If a product or company has more than three or four pricing structures, a relational database, such as Microsoft ____________________, might be a better choice than using a spreadsheet program.

The ISBLANK function tests for a(n) ____.

Identify the letter of the choice that best matches the function definition and arguments. -area_num

When solving an HLOOKUP formula, Excel looks up a value by testing for a criterion across a ____.

When you use a lookup type of TRUE, the VLOOKUP function looks only for an exact match of the lookup value.

The ____ function allows you to retrieve data from multidimensional tables.

If the lookup_value is less than the smallest value in the lookup_vector, LOOKUP displays ____.

Range names copy absolutely.

You could write a formula using the ____________________ function to check whether cell A5 contains text.

The function named IFERROR combines aspects of the IF function and the ____ function.

Identify the letter of the choice that best matches the function definition and arguments. -row_num

The INDEX function argument ____________________ refers to the number of the row in the range referenced in the first argument.

A VLOOKUP table can have ____ key value(s) in each cell of its first column.

When using an INDEX function, if you enter a row_num, column_num, or area_num outside of the range you referenced in the first argument, Excel displays ____.

With ____________________, you can specify your own text (or even a blank cell) when an error is encountered rather than the standard Excel message.

The ____ function is designed to return the relative position (such as 1, 2, or 3) of an item in a list.

Excel provides nine functions, called the OF functions, that test a value or cell reference, and then return a TRUE or FALSE value depending on the results. _________________________

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters

Exam 5: Retrieving Data for Computation, Analysis, and Reference

In a VLOOKUP function, the argument ____ refers to the range containing the data that you want to search to find the lookup value.

The ISBLANK function checks whether a specified value refers to an empty cell. The syntax of this function is as follows: =ISBLANK(____________________).

If a product or company has more than three or four pricing structures, a relational database, such as Microsoft ____________________, might be a better choice than using a spreadsheet program.

The ISBLANK function tests for a(n) ____.

Identify the letter of the choice that best matches the function definition and arguments. -area_num

When solving an HLOOKUP formula, Excel looks up a value by testing for a criterion across a ____.

When you use a lookup type of TRUE, the VLOOKUP function looks only for an exact match of the lookup value.

The ____ function allows you to retrieve data from multidimensional tables.

If the lookup_value is less than the smallest value in the lookup_vector, LOOKUP displays ____.

Range names copy absolutely.

You could write a formula using the ____________________ function to check whether cell A5 contains text.

The function named IFERROR combines aspects of the IF function and the ____ function.

Identify the letter of the choice that best matches the function definition and arguments. -row_num

The INDEX function argument ____________________ refers to the number of the row in the range referenced in the first argument.

A VLOOKUP table can have ____ key value(s) in each cell of its first column.

When using an INDEX function, if you enter a row_num, column_num, or area_num outside of the range you referenced in the first argument, Excel displays ____.

With ____________________, you can specify your own text (or even a blank cell) when an error is encountered rather than the standard Excel message.

The ____ function is designed to return the relative position (such as 1, 2, or 3) of an item in a list.

Excel provides nine functions, called the OF functions, that test a value or cell reference, and then return a TRUE or FALSE value depending on the results. _________________________

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters