Question 1

The INDEX function allows you to retrieve data from multidimensional tables.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

In a one-dimensional 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) True 
 B)False

Question 4

You can use the INDEX function to look up data stored in a single row, such as B3:E3, or a single column, such as B3:B7. In this case, you enter the range as the ____ argument.

Accepted Answer

A)  first 
B)  second 
C)  third 
D)  fourth 
A)  first 
B)  second 
C)  third 
D)  fourth

Question 5

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 6

Briefly describe five of the nine IS functions. The options are: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, and ISTEXT.

Accepted Answer

•ISBLANK: The value refers to an empty c

Question 7

MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-Designed to return the relative position (such as 1, 2, or 3) of an item in a list

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 8

When testing a worksheet, it's best to use numbers like ____.

Accepted Answer

A)  10, 100, 1000 
B)  12, 124, 248 
C)  13, 27, 88 
D)  1, 77, 129 
A)  10, 100, 1000 
B)  12, 124, 248 
C)  13, 27, 88 
D)  1, 77, 129

Question 9

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 shipping manager asks Violet to send any orders for 100 toys over immediately because they are testing a new box that will hold exactly 100 toys. In order to determine the position in the chart for the order with 100 toys, she writes the formula ____.

Accepted Answer

A)  =MATCH(4,A1:E1,0) 
B)  =MATCH(100,A1:E1,0) 
C)  =MATCH(100,A1:E1,-1) 
D)  =MATCH(100{A1,E1},-1) 
A)  =MATCH(4,A1:E1,0) 
B)  =MATCH(100,A1:E1,0) 
C)  =MATCH(100,A1:E1,-1) 
D)  =MATCH(100{A1,E1},-1)

Question 10

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 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

To return a negative value, ____ is a correct formula.

Accepted Answer

A)  =-HLOOKUP(F14,I$7:K$9,3,TRU
E) *H14 
B)  =(NEGATIV
E) HLOOKUP(F14,I$7:K$9,3,TRU
E) *H14 
C)  =(0)HLOOKUP(F14,I$7:K$9,3,TRU
E) *H14 
D)  none of the above 
A)  =-HLOOKUP(F14,I$7:K$9,3,TRU
E) *H14 
B)  =(NEGATIV
E) HLOOKUP(F14,I$7:K$9,3,TRU
E) *H14 
C)  =(0)HLOOKUP(F14,I$7:K$9,3,TRU
E) *H14 
D)  none of the above

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 columns

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

A data list that categorizes values you want to retrieve is called a linkup table.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

curly brac

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

You can often use a LOOKUP function instead of a VLOOKUP or HLOOKUP function with a TRUE lookup type.

Accepted Answer

A) True 
 B)False

Question 20

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

The INDEX function allows you to retrieve data from multidimensional tables.

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

In a one-dimensional 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.

You can use the INDEX function to look up data stored in a single row, such as B3:E3, or a single column, such as B3:B7. In this case, you enter the range as the ____ argument.

The syntax of the CHOOSE function is ____.

Briefly describe five of the nine IS functions. The options are: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, and ISTEXT.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Designed to return the relative position (such as 1, 2, or 3) of an item in a list

When testing a worksheet, it's best to use numbers like ____.

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.

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

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

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

To return a negative value, ____ is a correct formula.

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 columns

A data list that categorizes values you want to retrieve is called a linkup table.

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

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

You can often use a LOOKUP function instead of a VLOOKUP or HLOOKUP function with a TRUE lookup type.

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

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 INDEX function allows you to retrieve data from multidimensional tables.

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

In a one-dimensional 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.

You can use the INDEX function to look up data stored in a single row, such as B3:E3, or a single column, such as B3:B7. In this case, you enter the range as the ____ argument.

The syntax of the CHOOSE function is ____.

Briefly describe five of the nine IS functions. The options are: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, and ISTEXT.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Designed to return the relative position (such as 1, 2, or 3) of an item in a list

When testing a worksheet, it's best to use numbers like ____.

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.

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

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

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

To return a negative value, ____ is a correct formula.

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 columns

A data list that categorizes values you want to retrieve is called a linkup table.

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

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

You can often use a LOOKUP function instead of a VLOOKUP or HLOOKUP function with a TRUE lookup type.

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

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