Spreadsheet Multiple Choice Questions and Answers - 3

Question: 11

If name “profit” is assigned to cell D5, then

(A) Formula D5/2 may be written as “profit”/2

(B) Value of D5 is “profit”

(C) Both (a) and (b)

(D) None of these

Question: 12

If a cell stores a formula, then it displays the

(A) Result of computing the formula only it is the active cell

(B) Formula

(C) Result of computing the formula

(D) None of these

Question: 13

If a formula should not be adjusted after it is copied, use

(A) Absolute cell references

(B) Mixed cell references

(C) Relative cell references

(D) None of these