Question 1

The syntax of the VLOOKUP function is as follows: =VLOOKUP(lookup_value,table_array,col_index_num,____).

Accepted Answer

A)  lookup_range 
B)  range_lookup 
C)  row_index_num 
D)  table_value 
A)  lookup_range 
B)  range_lookup 
C)  row_index_num 
D)  table_value

Question 2

The V in VLOOKUP stands for velocity. _________________________

Accepted Answer

A) True 
 B)False

Question 3

In a VLOOKUP function, the argument ____ refers to the type of lookup you want to perform-TRUE or FALSE.

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 4

The function =____________________(index_num,value1,value2,…) can return up to 254 values.

Accepted Answer

The answer of The function =____________________(index_num,value1,value2,…) can return up to...

Question 5

If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP opens up the Lookup Wizard.

Accepted Answer

A) True 
 B)False

Question 6

When using a VLOOKUP function, it's not always obvious when a returned value is incorrect.

Accepted Answer

A) True 
 B)False

Question 7

The ____ function looks up the greatest value that does not exceed a specified value anywhere in a table or range.

Accepted Answer

A)  HLOOKUP 
B)  VLOOKUP 
C)  LOOKUP 
D)  all of the above 
A)  HLOOKUP 
B)  VLOOKUP 
C)  LOOKUP 
D)  all of the above

Question 8

The data you are looking up is also called the ____ data.

Accepted Answer

A)  key 
B)  look 
C)  important 
D)  clean 
A)  key 
B)  look 
C)  important 
D)  clean

Question 9

MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-Looks up the greatest value that does not exceed a specified value anywhere in a table or range

Accepted Answer

A) vertical lookup table 
B) horizontal lookup table 
C) LOOKUP function 
D) INDEX function 
E) MATCH function
F)CHOOSE function
G)IFERROR 
A) vertical lookup table 
B) horizontal lookup table 
C) LOOKUP function 
D) INDEX function 
E) MATCH function
F)CHOOSE function
G)IFERROR

Question 10

Internal values are those pieces of data that you know, such as customer names, quantities, or product descriptions. _________________________

Accepted Answer

A) True 
 B)False

Question 11

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.
-Violet now wants to send any orders for more than 30 toys to Warehouse 2. She is looking for the position where the smallest value is greater than 30. She will send the orders starting from that position on to Warehouse 2. The correct formula would be ____.

Accepted Answer

A) =MATCH(31,A1:E1,-1) B) =MATCH(31,A1:E1,0) C) =MATCH(31>=A1:E1,-1) D) =MATCH(31<=A1:E1,0) A) =MATCH(31,A1:E1,-1) B) =MATCH(31,A1:E1,0) C) =MATCH(31>=A1:E1,-1) D) =MATCH(31<=A1:E1,0)

Question 12

If the values you want to look up are in column B and the values you want to retrieve are in column A, you can use the ____ function.

Accepted Answer

A)  VLOOKUP 
B)  LOOKUP 
C)  either a or b 
D)  neither a nor b 
A)  VLOOKUP 
B)  LOOKUP 
C)  either a or b 
D)  neither a nor b

Question 13

In an INDEX function, the argument ____ refers to the column in the range referenced in the first argument.

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

You can only use a LOOKUP function when you want to retrieve a value that is stored to the ____ of a key data column in a vertical lookup table.

Accepted Answer

A)  left 
B)  right 
C)  either a or b 
D)  neither a nor b 
A)  left 
B)  right 
C)  either a or b 
D)  neither a nor b

Question 15

The syntax of the CHOOSE function is ____.

Accepted Answer

A)  =CHOOSE(index_num,value1,value2,…) 
B)  =CHOOSE(num_index,value1,value2,...) 
C)  =CHOOSE(value1,value2,...) 
D)  =CHOOSE(range_num,value1,value2,...) 
A)  =CHOOSE(index_num,value1,value2,…) 
B)  =CHOOSE(num_index,value1,value2,...) 
C)  =CHOOSE(value1,value2,...) 
D)  =CHOOSE(range_num,value1,value2,...)

Question 16

You cannot use VLOOKUP, HLOOKUP, or LOOKUP functions with a two-dimensional table.

Accepted Answer

A) True 
 B)False

Question 17

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.
-Violet wants to send any orders for 30 toys or fewer to Warehouse 1 to ship out. To do this, she locates the position in the chart where the greatest value does not exceed 30. The formula is ____.

Accepted Answer

A) =MATCH(30,A1:E1,0) B) =MATCH(30,A1:E1,1) C) =MATCH(30>,A1:E1,1) D) =MATCH(30,A1:E1,1) D) =MATCH(30

Question 18

Write the correct syntax for the LOOKUP function. Give a brief explanation of each of the three arguments that are included in LOOKUP.

Accepted Answer

Correct syntax:=LOOKUP(lookup_value,look

Question 19

In a VLOOKUP function, the argument ____ refers to the data you want to look up.

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 20

In the VLOOKUP function, if a type ____________________ is specified, an exact or approximate match is returned.

Accepted Answer

The answer of In the VLOOKUP function, if a type...

The syntax of the VLOOKUP function is as follows: =VLOOKUP(lookup_value,table_array,col_index_num,____).

The V in VLOOKUP stands for velocity. _________________________

In a VLOOKUP function, the argument ____ refers to the type of lookup you want to perform-TRUE or FALSE.

The function =____________________(index_num,value1,value2,…) can return up to 254 values.

If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP opens up the Lookup Wizard.

When using a VLOOKUP function, it's not always obvious when a returned value is incorrect.

The ____ function looks up the greatest value that does not exceed a specified value anywhere in a table or range.

The data you are looking up is also called the ____ data.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Looks up the greatest value that does not exceed a specified value anywhere in a table or range

Internal values are those pieces of data that you know, such as customer names, quantities, or product descriptions. _________________________

If the values you want to look up are in column B and the values you want to retrieve are in column A, you can use the ____ function.

In an INDEX function, the argument ____ refers to the column in the range referenced in the first argument.

You can only use a LOOKUP function when you want to retrieve a value that is stored to the ____ of a key data column in a vertical lookup table.

The syntax of the CHOOSE function is ____.

You cannot use VLOOKUP, HLOOKUP, or LOOKUP functions with a two-dimensional table.

Write the correct syntax for the LOOKUP function. Give a brief explanation of each of the three arguments that are included in LOOKUP.

In a VLOOKUP function, the argument ____ refers to the data you want to look up.

In the VLOOKUP function, if a type ____________________ is specified, an exact or approximate match is returned.

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

The syntax of the VLOOKUP function is as follows: =VLOOKUP(lookup_value,table_array,col_index_num,____).

The V in VLOOKUP stands for velocity. _________________________

In a VLOOKUP function, the argument ____ refers to the type of lookup you want to perform-TRUE or FALSE.

The function =____________________(index_num,value1,value2,…) can return up to 254 values.

If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP opens up the Lookup Wizard.

When using a VLOOKUP function, it's not always obvious when a returned value is incorrect.

The ____ function looks up the greatest value that does not exceed a specified value anywhere in a table or range.

The data you are looking up is also called the ____ data.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Looks up the greatest value that does not exceed a specified value anywhere in a table or range

Internal values are those pieces of data that you know, such as customer names, quantities, or product descriptions. _________________________

If the values you want to look up are in column B and the values you want to retrieve are in column A, you can use the ____ function.

In an INDEX function, the argument ____ refers to the column in the range referenced in the first argument.

You can only use a LOOKUP function when you want to retrieve a value that is stored to the ____ of a key data column in a vertical lookup table.

The syntax of the CHOOSE function is ____.

You cannot use VLOOKUP, HLOOKUP, or LOOKUP functions with a two-dimensional table.

Write the correct syntax for the LOOKUP function. Give a brief explanation of each of the three arguments that are included in LOOKUP.

In a VLOOKUP function, the argument ____ refers to the data you want to look up.

In the VLOOKUP function, if a type ____________________ is specified, an exact or approximate match is returned.

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