FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

BASICS OF BIG DATA

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

You’ve copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

A	If it needs an absolute cell reference
B	If it needs a relative cell reference
C	If it needs landscape orientation
D	If it needs a function

Explanation:

Detailed explanation-1: -You’ve copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula? a. If it needs an absolute cell reference.

Detailed explanation-2: -If you want to maintain the original cell reference when you copy it, you “lock” it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same.

Detailed explanation-3: -A relative cell reference in a formula will not change when the formula is copied. By default, when a cell reference is first included in a formula (so that only the column and row reference are included), it is displayed as a relative cell reference.

There is 1 question to complete.