Question 1

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 2

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 3

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.
-One of Mark's co-workers asks what would happen if he changed the formula to one having a FALSE type. As an example for discussion, Mark writes: =VLOOKUP(Z10,H$1:I10,1,FALSE). How does the FALSE type affect this formula?

Accepted Answer

A)  The VLOOKUP function looks only for an exact match of the lookup_value. 
B)  The VLOOKUP function looks only for negative values in the lookup_value. 
C)  The VLOOKUP function looks for the first value that is greater than the lookup_value. 
D)  The VLOOKUP function looks for the first value that is less than the lookup_value. 
A)  The VLOOKUP function looks only for an exact match of the lookup_value. 
B)  The VLOOKUP function looks only for negative values in the lookup_value. 
C)  The VLOOKUP function looks for the first value that is greater than the lookup_value. 
D)  The VLOOKUP function looks for the first value that is less than the lookup_value.

Question 4

In a VLOOKUP function, the argument ____ refers to the number of the column containing the data you want to retrieve.

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 5

When using the CHOOSE function, if the index_num argument is 2, the function returns ____.

Accepted Answer

A)  the first value from the list 
B)  the second value from the list 
C)  an error message 
D)  the first value that equals "2" 
A)  the first value from the list 
B)  the second value from the list 
C)  an error message 
D)  the first value that equals "2"

Question 6

When solving a(n) ____________________ formula, Excel looks up a value by testing for a criterion across a row, instead of down a column.

Accepted Answer

The answer of When solving a(n) ____________________ formula, Excel looks...

Question 7

When using the CHOOSE function, if the index_num is a fraction, it is truncated to ____ before being used.

Accepted Answer

A)  an integer 
B)  zero 
C)  the first decimal place 
D)  the second decimal place 
A)  an integer 
B)  zero 
C)  the first decimal place 
D)  the second decimal place

Question 8

The IS function called ISLOGICAL is for values that refer to a logical value. _________________________

Accepted Answer

A) True 
 B)False

Question 9

If you use an INDEX formula that refers to ranges on separate worksheets, Excel displays the ____ error message.

Accepted Answer

A)  #VALUE 
B)  #REF! 
C)  #ERROR 
D)  none of the above 
A)  #VALUE 
B)  #REF! 
C)  #ERROR 
D)  none of the above

Question 10

The INDEX function can solve for ____.

Accepted Answer

A)  no variables 
B)  one variable only 
C)  one or two variables only 
D)  two or more variables 
A)  no variables 
B)  one variable only 
C)  one or two variables only 
D)  two or more variables

Question 11

A function named IFWRONG can be used in combination with the VLOOKUP function to simplify error checking. _________________________

Accepted Answer

A) True 
 B)False

Question 12

If you have a valid range that is not in ascending order, you can sort it using the ____ commands in the Editing group on the HOME tab on the ribbon.

Accepted Answer

A)  Sort 
B)  Order 
C)  Range 
D)  Data 
A)  Sort 
B)  Order 
C)  Range 
D)  Data

Question 13

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 14

With the INDEX function, if you specify ____ contiguous range(s), you can omit the area_num argument.

Accepted Answer

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

Question 15

The final argument of the VLOOKUP function is the ____________________ type, which can be TRUE or FALSE.

Accepted Answer

The answer of The final argument of the VLOOKUP function...

Question 16

In VLOOKUP, if a type FALSE is specified, an exact or approximate match is returned. _________________________

Accepted Answer

A) True 
 B)False

Question 17

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 18

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.
-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 19

With a ____ type of VLOOKUP, the function would look only for the exact match.

Accepted Answer

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

Question 20

MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-Can return a value or a range for up to 254 different values

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

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

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

In a VLOOKUP function, the argument ____ refers to the number of the column containing the data you want to retrieve.

When using the CHOOSE function, if the index_num argument is 2, the function returns ____.

When solving a(n) ____________________ formula, Excel looks up a value by testing for a criterion across a row, instead of down a column.

When using the CHOOSE function, if the index_num is a fraction, it is truncated to ____ before being used.

The IS function called ISLOGICAL is for values that refer to a logical value. _________________________

If you use an INDEX formula that refers to ranges on separate worksheets, Excel displays the ____ error message.

The INDEX function can solve for ____.

A function named IFWRONG can be used in combination with the VLOOKUP function to simplify error checking. _________________________

If you have a valid range that is not in ascending order, you can sort it using the ____ commands in the Editing group on the HOME tab on the ribbon.

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.

With the INDEX function, if you specify ____ contiguous range(s), you can omit the area_num argument.

The final argument of the VLOOKUP function is the ____________________ type, which can be TRUE or FALSE.

In VLOOKUP, if a type FALSE is specified, an exact or approximate match is returned. _________________________

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

With a ____ type of VLOOKUP, the function would look only for the exact match.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Can return a value or a range for up to 254 different values

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 data you are looking up is also called the ____ data.

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

In a VLOOKUP function, the argument ____ refers to the number of the column containing the data you want to retrieve.

When using the CHOOSE function, if the index_num argument is 2, the function returns ____.

When solving a(n) ____________________ formula, Excel looks up a value by testing for a criterion across a row, instead of down a column.

When using the CHOOSE function, if the index_num is a fraction, it is truncated to ____ before being used.

The IS function called ISLOGICAL is for values that refer to a logical value. _________________________

If you use an INDEX formula that refers to ranges on separate worksheets, Excel displays the ____ error message.

The INDEX function can solve for ____.

A function named IFWRONG can be used in combination with the VLOOKUP function to simplify error checking. _________________________

If you have a valid range that is not in ascending order, you can sort it using the ____ commands in the Editing group on the HOME tab on the ribbon.

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.

With the INDEX function, if you specify ____ contiguous range(s), you can omit the area_num argument.

The final argument of the VLOOKUP function is the ____________________ type, which can be TRUE or FALSE.

In VLOOKUP, if a type FALSE is specified, an exact or approximate match is returned. _________________________

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

With a ____ type of VLOOKUP, the function would look only for the exact match.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Can return a value or a range for up to 254 different values

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