Question 1

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 2

VLOOKUP searches for a matching value in the leftmost column of the table, and then retrieves the value ____.

Accepted Answer

A)  in the same row but in another column that you specify 
B)  in the same column but in another row that you specify 
C)  anywhere in the table 
D)  in the same row, in the very next column 
A)  in the same row but in another column that you specify 
B)  in the same column but in another row that you specify 
C)  anywhere in the table 
D)  in the same row, in the very next column

Question 3

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 ce

Question 4

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 5

A ____ at the beginning of the formula indicates that Excel should display the results as a negative value.

Accepted Answer

A)  negative sign 
B)  double negative sign 
C)  (0) 
D)  none of the above 
A)  negative sign 
B)  double negative sign 
C)  (0) 
D)  none of the above

Question 6

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 7

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 8

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.
-In the formula Mark is discussing with his co-worker, =VLOOKUP(Z10,H$1:I10,1,FALSE), the lookup_value is ____.

Accepted Answer

A)  Z10 
B)  H$1:I$10 
C)  1 
D)  FALSE 
A)  Z10 
B)  H$1:I$10 
C)  1 
D)  FALSE

Question 9

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 10

You can use a VLOOKUP formula and an HLOOKUP formula to retrieve data stored in lookup tables on the same worksheet.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

You could write a formula using the ____________________ function to check whether cell A5 contains text.

Accepted Answer

The answer of You could write a formula using the...

Question 16

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 17

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 18

The syntax of the HLOOKUP function is as follows: =HLOOKUP(lookup_value,____,row_index_num,range_lookup).

Accepted Answer

A)  table_index 
B)  table_array 
C)  table_range 
D)  table_row 
A)  table_index 
B)  table_array 
C)  table_range 
D)  table_row

Question 19

When you use the HLOOKUP function, you specify the row_index_num. _________________________

Accepted Answer

A) True 
 B)False

Question 20

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

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

VLOOKUP searches for a matching value in the leftmost column of the table, and then retrieves the value ____.

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

A ____ at the beginning of the formula indicates that Excel should display the results as a negative value.

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

The INDEX function can solve for ____.

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. -In the formula Mark is discussing with his co-worker, =VLOOKUP(Z10,H$1:I10,1,FALSE), the lookup_value is ____.

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.

You can use a VLOOKUP formula and an HLOOKUP formula to retrieve data stored in lookup tables on the same worksheet.

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

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

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

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

You could write a formula using the ____________________ function to check whether cell A5 contains text.

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

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

The syntax of the HLOOKUP function is as follows: =HLOOKUP(lookup_value,____,row_index_num,range_lookup).

When you use the HLOOKUP function, you specify the row_index_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.

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

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

VLOOKUP searches for a matching value in the leftmost column of the table, and then retrieves the value ____.

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

A ____ at the beginning of the formula indicates that Excel should display the results as a negative value.

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

The INDEX function can solve for ____.

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. -In the formula Mark is discussing with his co-worker, =VLOOKUP(Z10,H$1:I10,1,FALSE), the lookup_value is ____.

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.

You can use a VLOOKUP formula and an HLOOKUP formula to retrieve data stored in lookup tables on the same worksheet.

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

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

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

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

You could write a formula using the ____________________ function to check whether cell A5 contains text.

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

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

The syntax of the HLOOKUP function is as follows: =HLOOKUP(lookup_value,____,row_index_num,range_lookup).

When you use the HLOOKUP function, you specify the row_index_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.

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