chapter 2

Question 1

relative cell reference

Answer 1

copied references are updated to new locations

Question 2

absolute cell reference

Answer 2

copied references do not change

Question 3

what is the shortcut for an absolute cell reference

Answer 3

F4 key

Question 4

mixed cell reference

Answer 4

only the row or column will change when copied

Question 5

3D cell reference

Answer 5

a cell located in another worksheet(it can be absolute, mixed, or relative)

Question 6

trace precedents

Answer 6

displays lines with arrows to identify all cells referenced in the formula in the active cell

Question 7

trace dependents

Answer 7

display lines with arrows to all cells that use the active cell directly or indirectly in a formula

Question 8

COUNT (count numbers)

Answer 8

counts the cells that contain values with a range

Question 9

COUNTA

Answer 9

counts the cells that contain any data type within a range

Question 10

COUNTBLANK

Answer 10

counts empty cells in a range

Question 11

COUNTIF

Answer 11

counts the cells that meet the criteria argument within a range

Question 12

COUNTIFS

Answer 12

counts the cells in one or more criteria ranges that meet respective criteria arguments

Question 13

PMT function

Answer 13

calculates a constant loan payment amount for a period of time at a stated interest rate

Question 14

What are the five arguments of the PMT function?

Answer 14

• Rate: yearly
• Nper: total number of periods till repayment
• Pv: present value
• Fv: any amount still owed at end of the loan
• Type: payment at beg. or end of a period?

Question 15

IF function

Answer 15

logical_test, value_if_true, value_if_false

Question 16

VLOOKUP function

Answer 16

displays a piece of data from a range of cells in another part of the workbook

Question 17

what are the four arguments of a VLOOPUP function?

Answer 17

• lookup_value: the data to be found or matched
• table_array: a range of cells
• col_index_num: sets which column in the table_array contains the data to display in the result

Question 18

what are the four arguments of an HLOOKUP function?

Answer 18

• lookup_value: the data to be found or matched
• table_array: a range of cells
• row_index_num: sets which row in the table_array contains the data to display in the result

Question 19

what are the two arguments of the round function?

Answer 19

• number: cell or value to be adjusted

- num_digits: # of decimal places for rounding

Question 20

what are the three arguments of a SUMIF function?

Answer 20

• range: the range of cells to be evaluated
• criteria: argument defines which cells from the range should be included in the sum

Question 21

SUMPRODUCT function

Answer 21

it multiplies the cell identified in its array arguments and then it totals those individual products

Question 22

what is the syntax for a SUMPRODUCT function?

Answer 22

=SUMPRODUCT(array 1, array 2)