Question 1

With a ____ type of VLOOKUP, the function returns the greatest value that does not exceed the lookup value.

Accepted Answer

A)  FALSE 
B)  TRUE 
C)  complex 
D)  simple 
A)  FALSE 
B)  TRUE 
C)  complex 
D)  simple B

Question 2

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 A

Question 3

If you want to use the INDEX function to retrieve data stored in more than one range, be certain to store all the lookup ranges on the same computer. _________________________

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

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

Question 5

When creating a vertical lookup table with the TRUE type, be certain to start with the lowest possible value, such as 0, so that the table covers all the possible data.

Accepted Answer

A) True 
 B)False

Question 6

As with the VLOOKUP and HLOOKUP functions with the TRUE lookup type, the ____ function looks for a value that matches the criterion by comparing values based on their position in the lookup table.

Accepted Answer

A)  POSITION 
B)  LOOKUP 
C)  LINK 
D)  LIST 
A)  POSITION 
B)  LOOKUP 
C)  LINK 
D)  LIST

Question 7

In a(n) ____ table, Excel searches one dimension, such as the columns, and then searches another dimension, such as the rows, to find the value at the intersection of a single row and column.

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 8

The H in HLOOKUP stands for ____.

Accepted Answer

A)  help 
B)  horizontal 
C)  historic 
D)  hit 
A)  help 
B)  horizontal 
C)  historic 
D)  hit

Question 9

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 10

A vertical lookup table is a lookup table in which the data to be searched is organized in columns.

Accepted Answer

A) True 
 B)False

Question 11

You can use the ____________________ function to test a cell reference. If the cell is blank, or empty, the function returns the value TRUE.

Accepted Answer

The answer of You can use the ____________________ function to...

Question 12

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

Accepted Answer

A)  IS 
B)  IF 
C)  OR 
D)  OF 
A)  IS 
B)  IF 
C)  OR 
D)  OF

Question 13

Use ____________________ when the first column of the lookup table contains the key data, and the information you want to retrieve is in one of the columns to the right of the key data column.

Accepted Answer

The answer of Use ____________________ when the first column of...

Question 14

A lookup table can have only one ____________________ in each cell of its first column.

Accepted Answer

The answer of A lookup table can have only one...

Question 15

MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-A lookup table in which the data to be searched is organized in rows

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 16

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 17

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

Question 18

The LOOKUP function has the ____ lookup type.

Accepted Answer

A)  TRUE 
B)  FALSE 
C)  either a or b 
D)  neither a nor b 
A)  TRUE 
B)  FALSE 
C)  either a or b 
D)  neither a nor b

Question 19

Case 5-2
   
Mark is in charge of determining the unit pricing for each order for robot toys. Please refer to the chart above as you answer the questions below.
-Mark tests the following formula with a FALSE type in the worksheet shown above: =VLOOKUP(D14,A$3:B$8,2,FALSE). The result is ____.

Accepted Answer

A)  a price of $4.75 
B)  a price of $5.00 
C)  the #N/A error message 
D)  a price of $4.50 
A)  a price of $4.75 
B)  a price of $5.00 
C)  the #N/A error message 
D)  a price of $4.50

Question 20

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 Sales department has been mistakenly writing the word "return" in the quantity field for orders that are returned. Violet looks at the chart above and can see that the word "return" is not listed this time. However, to check for this word in future orders, Violet writes the formula ____.

Accepted Answer

A)  =MATCH("return",A1:E1,0) 
B)  =MATCH(return,A1:E1,0) 
C)  =MATCH(A1:E1,0,"return") 
D)  =MATCH("return",0:1000,0) 
A)  =MATCH("return",A1:E1,0) 
B)  =MATCH(return,A1:E1,0) 
C)  =MATCH(A1:E1,0,"return") 
D)  =MATCH("return",0:1000,0)

With a ____ type of VLOOKUP, the function returns the greatest value that does not exceed the lookup value.

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

If you want to use the INDEX function to retrieve data stored in more than one range, be certain to store all the lookup ranges on the same computer. _________________________

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

When creating a vertical lookup table with the TRUE type, be certain to start with the lowest possible value, such as 0, so that the table covers all the possible data.

As with the VLOOKUP and HLOOKUP functions with the TRUE lookup type, the ____ function looks for a value that matches the criterion by comparing values based on their position in the lookup table.

In a(n) ____ table, Excel searches one dimension, such as the columns, and then searches another dimension, such as the rows, to find the value at the intersection of a single row and column.

The H in HLOOKUP stands for ____.

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

A vertical lookup table is a lookup table in which the data to be searched is organized in columns.

You can use the ____________________ function to test a cell reference. If the cell is blank, or empty, the function returns the value TRUE.

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

Use ____________________ when the first column of the lookup table contains the key data, and the information you want to retrieve is in one of the columns to the right of the key data column.

A lookup table can have only one ____________________ in each cell of its first column.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -A lookup table in which the data to be searched is organized in rows

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

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

The LOOKUP function has the ____ lookup type.

Case 5-2 Mark is in charge of determining the unit pricing for each order for robot toys. Please refer to the chart above as you answer the questions below. -Mark tests the following formula with a FALSE type in the worksheet shown above: =VLOOKUP(D14,A$3:B$8,2,FALSE). The result is ____.

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

With a ____ type of VLOOKUP, the function returns the greatest value that does not exceed the lookup value.

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

If you want to use the INDEX function to retrieve data stored in more than one range, be certain to store all the lookup ranges on the same computer. _________________________

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

When creating a vertical lookup table with the TRUE type, be certain to start with the lowest possible value, such as 0, so that the table covers all the possible data.

As with the VLOOKUP and HLOOKUP functions with the TRUE lookup type, the ____ function looks for a value that matches the criterion by comparing values based on their position in the lookup table.

In a(n) ____ table, Excel searches one dimension, such as the columns, and then searches another dimension, such as the rows, to find the value at the intersection of a single row and column.

The H in HLOOKUP stands for ____.

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

A vertical lookup table is a lookup table in which the data to be searched is organized in columns.

You can use the ____________________ function to test a cell reference. If the cell is blank, or empty, the function returns the value TRUE.

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

Use ____________________ when the first column of the lookup table contains the key data, and the information you want to retrieve is in one of the columns to the right of the key data column.

A lookup table can have only one ____________________ in each cell of its first column.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -A lookup table in which the data to be searched is organized in rows

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

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

The LOOKUP function has the ____ lookup type.

Case 5-2 Mark is in charge of determining the unit pricing for each order for robot toys. Please refer to the chart above as you answer the questions below. -Mark tests the following formula with a FALSE type in the worksheet shown above: =VLOOKUP(D14,A$3:B$8,2,FALSE). The result is ____.

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