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

Computer Science & Information Technology

You might also like to view...

To help human readers understand why a method's statements are there, good programmers insert explanatory ____ into their methods.

A. conditions B. behaviors C. actions D. comments

Computer Science & Information Technology

____ can attach themselves to a legitimate computer file, replicate to other programs, and deliver various payloads.

A. Snakes B. Viruses C. Bacteria D. Worms

Computer Science & Information Technology

How does a project manager assess the risk of things going wrong and take that into consideration of the time needed to complete the project?

What will be an ideal response?

Computer Science & Information Technology

The decision that controls every loop is always based on a ____ comparison.

A. Boolean B. logical C. standard D. regular

Computer Science & Information Technology