Question 1

The syntax of the IFERROR function is ____.

Accepted Answer

A)  =IFERROR(value_if_error,value) 
B)  =IFERROR(value,value_if_error) 
C)  =IFERROR(value,range) 
D)  =IFERROR(value,vector_lookup) 
A)  =IFERROR(value_if_error,value) 
B)  =IFERROR(value,value_if_error) 
C)  =IFERROR(value,range) 
D)  =IFERROR(value,vector_lookup)

Question 2

Headings at the top of each column should be included as part of the lookup_range in the VLOOKUP formula.

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

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

Question 6

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

Accepted Answer

The correct syntax: =VLOOKUP(lookup_valu

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

In a FALSE VLOOKUP, if an exact match is not found, ____ is returned.

Accepted Answer

A)  an error value 
B)  an approximate match 
C)  the first value in the column 
D)  the last value in the column 
A)  an error value 
B)  an approximate match 
C)  the first value in the column 
D)  the last value in the column

Question 9

If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the ____ error value.

Accepted Answer

A)  #N/A 
B)  ## 
C)  #ERROR# 
D)  @#@# 
A)  #N/A 
B)  ## 
C)  #ERROR# 
D)  @#@#

Question 10

In a LOOKUP function, the argument ____ refers to the location of the data you want to retrieve.

Accepted Answer

A)  lookup_value 
B)  lookup_vector 
C)  result_vector 
D)  lookup_range 
A)  lookup_value 
B)  lookup_vector 
C)  result_vector 
D)  lookup_range

Question 11

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 writes a formula to look up the unit pricing for each order. He starts by writing one for Order #1 and then plans to copy it from E12 to E13:E16. The correct formula would be ____.

Accepted Answer

A)  =VLOOKUP(D12,A$7:B$8,3,TRU
E)  
B)  =VLOOKUP(D12,A$7:B$8,2,TRU
E)  
C)  =VLOOKUP(D12,A$7:B$8,0,TRU
E)  
D)  =VLOOKUP(D12,A$7:B$8,1,TRU
E)  
A)  =VLOOKUP(D12,A$7:B$8,3,TRU
E)  
B)  =VLOOKUP(D12,A$7:B$8,2,TRU
E)  
C)  =VLOOKUP(D12,A$7:B$8,0,TRU
E)  
D)  =VLOOKUP(D12,A$7:B$8,1,TRU
E)

Question 12

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 13

To find and retrieve data from a vertical lookup table in the most efficient way, create a simple worksheet that contains related data, and organize this data in ____ to form the vertical lookup table.

Accepted Answer

A)  columns 
B)  rows 
C)  either a or b 
D)  neither a nor b 
A)  columns 
B)  rows 
C)  either a or b 
D)  neither a nor b

Question 14

The first row (key values) of the lookup table must be sorted in ____ order to use an HLOOKUP function with a TRUE lookup type.

Accepted Answer

A)  ascending 
B)  descending 
C)  alphabetical 
D)  numerical 
A)  ascending 
B)  descending 
C)  alphabetical 
D)  numerical

Question 15

When using the CHOOSE function, if the index_num argument is less than 1 or greater than the last value in the list, the function displays the error ____.

Accepted Answer

A)  #VALUE! 
B)  #NAME 
C)  #REF 
D)  #ERROR 
A)  #VALUE! 
B)  #NAME 
C)  #REF 
D)  #ERROR

Question 16

MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-Allows you to specify your own text when an error is encountered

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 17

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 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 18

When creating a range for use with a type TRUE VLOOKUP table, make sure to sort the values in the first column of table_array in ____ order.

Accepted Answer

A)  descending 
B)  ascending 
C)  alphabetical 
D)  numerical 
A)  descending 
B)  ascending 
C)  alphabetical 
D)  numerical

Question 19

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 20

Unlike VLOOKUP, the RLOOKUP function looks up the greatest value that does not exceed a specified value anywhere in a table or range.

Accepted Answer

A) True 
 B)False

The syntax of the IFERROR function is ____.

Headings at the top of each column should be included as part of the lookup_range in the VLOOKUP formula.

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

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

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

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

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

In a FALSE VLOOKUP, if an exact match is not found, ____ is returned.

If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the ____ error value.

In a LOOKUP function, the argument ____ refers to the location of the data you want to retrieve.

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

To find and retrieve data from a vertical lookup table in the most efficient way, create a simple worksheet that contains related data, and organize this data in ____ to form the vertical lookup table.

The first row (key values) of the lookup table must be sorted in ____ order to use an HLOOKUP function with a TRUE lookup type.

When using the CHOOSE function, if the index_num argument is less than 1 or greater than the last value in the list, the function displays the error ____.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Allows you to specify your own text when an error is encountered

When creating a range for use with a type TRUE VLOOKUP table, make sure to sort the values in the first column of table_array in ____ order.

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

Unlike VLOOKUP, the RLOOKUP function looks up the greatest value that does not exceed a specified value anywhere in a table or range.

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 IFERROR function is ____.

Headings at the top of each column should be included as part of the lookup_range in the VLOOKUP formula.

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

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

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

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

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

In a FALSE VLOOKUP, if an exact match is not found, ____ is returned.

If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the ____ error value.

In a LOOKUP function, the argument ____ refers to the location of the data you want to retrieve.

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

To find and retrieve data from a vertical lookup table in the most efficient way, create a simple worksheet that contains related data, and organize this data in ____ to form the vertical lookup table.

The first row (key values) of the lookup table must be sorted in ____ order to use an HLOOKUP function with a TRUE lookup type.

When using the CHOOSE function, if the index_num argument is less than 1 or greater than the last value in the list, the function displays the error ____.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Allows you to specify your own text when an error is encountered

When creating a range for use with a type TRUE VLOOKUP table, make sure to sort the values in the first column of table_array in ____ order.

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

Unlike VLOOKUP, the RLOOKUP function looks up the greatest value that does not exceed a specified value anywhere in a table or range.

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