Question 1

When you write a VLOOKUP formula, you indicate the value you want to look up in a ____.

Accepted Answer

A)  table 
B)  chart 
C)  graph 
D)  list 
A)  table 
B)  chart 
C)  graph 
D)  list A

Question 2

The syntax of the LOOKUP function is as follows: =LOOKUP(____,lookup_vector,result_vector).

Accepted Answer

A)  lookup_value 
B)  lookup_reference 
C)  lookup_range 
D)  lookup_index 
A)  lookup_value 
B)  lookup_reference 
C)  lookup_range 
D)  lookup_index A

Question 3

When using the MATCH function, the lookup_array must be enclosed in ____________________ if the values are not contiguous.

Accepted Answer

curly braces
braces
curly brackets
{}

Question 4

In the formula =IF(ISBLANK(A9)," ",VLOOKUP(A9,Products,2,FALSE)), if cell A9 is blank, Excel displays ____.

Accepted Answer

A)  a string of empty characters 
B)  the word "products" 
C)  the word "FALSE" 
D)  the error "#VALUE" 
A)  a string of empty characters 
B)  the word "products" 
C)  the word "FALSE" 
D)  the error "#VALUE"

Question 5

The table_array argument must contain ____ cell references so that the row values will not change when the formula is copied down the column.

Accepted Answer

A)  absolute 
B)  relative 
C)  simple 
D)  complex 
A)  absolute 
B)  relative 
C)  simple 
D)  complex

Question 6

When using an INDEX function, you can use a row_num of ____ to retrieve all the values in a specified column.

Accepted Answer

A)  0 
B)  .01 
C)  10 
D)  100 
A)  0 
B)  .01 
C)  10 
D)  100

Question 7

The LOOKUP function uses only a TRUE lookup type, so the column or row containing the lookup values must be in ____________________ order.

Accepted Answer

The answer of The LOOKUP function uses only a TRUE...

Question 8

You use VLOOKUP when ____ of the lookup table contains the data you are looking up.

Accepted Answer

A)  the first column 
B)  the last column 
C)  any column 
D)  all columns 
A)  the first column 
B)  the last column 
C)  any column 
D)  all columns

Question 9

The INDEX function allows you to specify a list of nonadjacent ranges as the reference argument, and then specify which of these ranges to use in the area_num argument.

Accepted Answer

A) True 
 B)False

Question 10

In a(n) ____ table, Excel can search a row or column to find key data, and then use that data to locate the correct value.

Accepted Answer

A)  one-dimensional 
B)  two-dimensional 
C)  three-dimensional 
D)  none of the above 
A)  one-dimensional 
B)  two-dimensional 
C)  three-dimensional 
D)  none of the above

Question 11

For a VLOOKUP table, list the key values in ____.

Accepted Answer

A)  the last column 
B)  any column 
C)  the first column 
D)  the first row 
A)  the last column 
B)  any column 
C)  the first column 
D)  the first row

Question 12

You can use the ISEMPTY function to test a cell reference. _________________________

Accepted Answer

A) True 
 B)False

Question 13

In an INDEX function, the argument ____ refers to the range containing the data you want to find.

Accepted Answer

A)  reference 
B)  row_num 
C)  column_num 
D)  area_num 
A)  reference 
B)  row_num 
C)  column_num 
D)  area_num

Question 14

A data list that categorizes values you want to retrieve is called a(n) ____________________ table.

Accepted Answer

The answer of A data list that categorizes values you...

Question 15

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 16

The Lookup function argument called lookup_vector is the location of the data you want to look up. _________________________

Accepted Answer

A) True 
 B)False

Question 17

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 18

The CHOOSE function can return a value or a range for up to ____ different values.

Accepted Answer

A)  12 
B)  157 
C)  202 
D)  254 
A)  12 
B)  157 
C)  202 
D)  254

Question 19

With the INDEX function, you can use a column_num of ____________________ to retrieve all the values in a specified row.

Accepted Answer

The answer of With the INDEX function, you can use...

Question 20

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

Accepted Answer

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

When you write a VLOOKUP formula, you indicate the value you want to look up in a ____.

The syntax of the LOOKUP function is as follows: =LOOKUP(____,lookup_vector,result_vector).

When using the MATCH function, the lookup_array must be enclosed in ____________________ if the values are not contiguous.

In the formula =IF(ISBLANK(A9)," ",VLOOKUP(A9,Products,2,FALSE)), if cell A9 is blank, Excel displays ____.

The table_array argument must contain ____ cell references so that the row values will not change when the formula is copied down the column.

When using an INDEX function, you can use a row_num of ____ to retrieve all the values in a specified column.

The LOOKUP function uses only a TRUE lookup type, so the column or row containing the lookup values must be in ____________________ order.

You use VLOOKUP when ____ of the lookup table contains the data you are looking up.

The INDEX function allows you to specify a list of nonadjacent ranges as the reference argument, and then specify which of these ranges to use in the area_num argument.

In a(n) ____ table, Excel can search a row or column to find key data, and then use that data to locate the correct value.

For a VLOOKUP table, list the key values in ____.

You can use the ISEMPTY function to test a cell reference. _________________________

In an INDEX function, the argument ____ refers to the range containing the data you want to find.

A data list that categorizes values you want to retrieve is called a(n) ____________________ table.

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

The Lookup function argument called lookup_vector is the location of the data you want to look up. _________________________

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

The CHOOSE function can return a value or a range for up to ____ different values.

With the INDEX function, you can use a column_num of ____________________ to retrieve all the values in a specified row.

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

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

When you write a VLOOKUP formula, you indicate the value you want to look up in a ____.

The syntax of the LOOKUP function is as follows: =LOOKUP(____,lookup_vector,result_vector).

When using the MATCH function, the lookup_array must be enclosed in ____________________ if the values are not contiguous.

In the formula =IF(ISBLANK(A9)," ",VLOOKUP(A9,Products,2,FALSE)), if cell A9 is blank, Excel displays ____.

The table_array argument must contain ____ cell references so that the row values will not change when the formula is copied down the column.

When using an INDEX function, you can use a row_num of ____ to retrieve all the values in a specified column.

The LOOKUP function uses only a TRUE lookup type, so the column or row containing the lookup values must be in ____________________ order.

You use VLOOKUP when ____ of the lookup table contains the data you are looking up.

The INDEX function allows you to specify a list of nonadjacent ranges as the reference argument, and then specify which of these ranges to use in the area_num argument.

In a(n) ____ table, Excel can search a row or column to find key data, and then use that data to locate the correct value.

For a VLOOKUP table, list the key values in ____.

You can use the ISEMPTY function to test a cell reference. _________________________

In an INDEX function, the argument ____ refers to the range containing the data you want to find.

A data list that categorizes values you want to retrieve is called a(n) ____________________ table.

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

The Lookup function argument called lookup_vector is the location of the data you want to look up. _________________________

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

The CHOOSE function can return a value or a range for up to ____ different values.

With the INDEX function, you can use a column_num of ____________________ to retrieve all the values in a specified row.

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

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