Exam 5: Retrieving Data for Computation, Analysis, and Reference

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

(Multiple Choice)

4.7/5

(35)

Question 21

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

(Multiple Choice)

4.7/5

(31)

Question 22

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.

(True/False)

5.0/5

(34)

Question 23

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

(Multiple Choice)

4.9/5

(34)

Question 24

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

(Multiple Choice)

4.8/5

(31)

Question 25

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

(True/False)

4.7/5

(25)

Question 26

The syntax of the CHOOSE function is as follows: =CHOOSE(index_num,value1,value2,…). _________________________

(True/False)

4.8/5

(31)

Question 27

When solving an HLOOKUP formula, Excel looks up a value by testing for a criterion across a ____.

(Multiple Choice)

4.8/5

(37)

Question 28

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

(Multiple Choice)

4.8/5

(33)

Question 29

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 Customer Service department tells Violet there is a 25% discount on orders of 500 toys or more. Violet knows there is only one order that large, for 1000 toys, so which of the following formulas does she write to find the position of this order?

(Multiple Choice)

4.7/5

(38)

Question 30

You can only use a LOOKUP function when you want to retrieve a value that is stored ____ a key data row in a horizontal lookup table.

(Multiple Choice)

4.7/5

(32)

Question 31

The ISBLANK function checks whether a specified value refers to an empty cell. The syntax of this function is ____.

(Multiple Choice)

4.9/5

(35)

Question 32

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

(Multiple Choice)

4.9/5

(38)

Question 33

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.

(Multiple Choice)

4.8/5

(33)

Question 34

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

(True/False)

4.9/5

(36)

Question 35

In an INDEX function, the argument ____ refers to the number of the row in the range referenced in the first argument.

(Multiple Choice)

4.8/5

(38)

Question 36

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

(Multiple Choice)

4.9/5

(38)

Question 37

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

(Short Answer)

4.7/5

(43)

Question 38

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

(Multiple Choice)

4.8/5

(35)

Question 39

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

(Short Answer)

4.9/5

(33)

Question 40

Showing 21 - 40 of 150

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

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

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.

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

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

The syntax of the CHOOSE function is as follows: =CHOOSE(index_num,value1,value2,…). _________________________

When solving an HLOOKUP formula, Excel looks up a value by testing for a criterion across a ____.

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

You can only use a LOOKUP function when you want to retrieve a value that is stored ____ a key data row in a horizontal lookup table.

The ISBLANK function checks whether a specified value refers to an empty cell. The syntax of this function is ____.

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.

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

In an INDEX function, the argument ____ refers to the number of the row in the range referenced in the first argument.

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

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

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

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