Chapter 5 - Retrieving Data for Computation, Analysis, and Reference Flashcards Preview

Quantitive Analysis with Excel > Chapter 5 - Retrieving Data for Computation, Analysis, and Reference > Flashcards

Flashcards in Chapter 5 - Retrieving Data for Computation, Analysis, and Reference Deck (57)
Loading flashcards...
1

What contain data that can be used to create worksheets that list items and then perform calculations?

Lookup tables

2

What is the most effective and flexible way to retrieve data organized in columns?

The VLOOKUP function

3

Which function searches a specified part of a worksheet for data starting with the first column?

The VLOOKUP function

4

What is the format of the VLOOKUP function?

=VLOOKUP(lookup_value,table_array, col_index_num,range_lookup)

5

True or False:

You don't have to specify the col_index_num in the VLOOKUP function

False

6

Which argument represents the data that you want to look up?

Lookup_value

7

Which argument represents the range containing the data that you want to search to find the lookup_value?

Table_array

8

Which argument represents the number of the column containing the data you want to retrieve?

Col_index_num

9

Which argument represents the type of lookup you want to perform: TRUE or FALSE?

Range_lookup

10

True or False:

If using the lookup type FALSE, the VLOOKUP function looks only for an exact match of the lookup value

True

11

What does the VLOOKUP function display in a cell if an exact match isn't found?

#N/A

12

Which function looks up a value by testing for a criterion across a row?

The HLOOKUP function

13

What is the format of the HLOOKUP function?

=HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

14

Which argument represents the number of the row containing the data you want to retrieve?

Row_index_num

15

True or False:

The first row of the HLOOKUP table must be sorted in ascending order

True

16

What do you use when the first column of the lookup table contains the key data and information you want to retrieve is in a column to the right of the key data column?

The VLOOKUP function

17

What do you use when the first row of the lookup table contains the key data and information you want to retrieve is in a column to the right of the key data row?

The HLOOKUP function

18

What 2 functions should you use to retrieve data from multiple worksheets?

VLOOKUP and HLOOKUP

19

Which function looks up the greatest value that does not exceed a specified value anywhere in a table or range?

The LOOKUP function

20

What is the format of the LOOKUP function?

=LOOKUP(lookup_value,lookup_vector,result_vector)

21

True or False:

The LOOKUP function can retrieve data from a lookup table with a vertical or horizontal orientation

True

22

Which argument represents the location of the data that you want to look up?

Lookup_vector

23

Which argument represents the location of the data that you want to retrieve?

Result_vector

24

Which function should you use with two- or three-dimensional tables?

The INDEX function

25

Which function returns the value in a table based on the row and column numbers that you specify?

The INDEX function

26

What is the format of the INDEX function?

=INDEX(reference,row_num,column_num,area_num)

27

Which argument represents the range containing the data that you want to find?

Reference

28

Which argument represents the number of the row in the range referenced in the first agreement of the INDEX function?

Row_num

29

Which argument represents the number of the column in the range referenced in the first agreement of the INDEX function?

Column_num

30

Which argument represents the part of the nonadjacent range referenced in the first agreement of the INDEX function?

Area_num