Match the following terms with their description
I. Relative cell reference A. The column or row of a cell reference does not change when the formula is filled or moved
II. Absolute cell reference B. The number of years it takes to recover the cost of an investment
III. Mixed cell reference C. Applied if a criterion is met
IV. Conditional formatting D. Cell reference changes when the formula is filled or moved
V. Simple payback period E. Cell reference does not change when the formula is filled or moved
D, E, A, C, B
You might also like to view...
The INNER JOIN clause returns all rows from at least one of the tables within the FROM clause, as long as those rows meet any WHERE or HAVING search conditions
Indicate whether the statement is true or false
When creating a business letter, there should be no blank lines between the complimentary closing and the signature line
Indicate whether the statement is true or false