Given below is a table containing 'Rate/gm' and 'Wt in gm' in columns A and B respectively. Cell D1 contains GST as 5% (i.e. 0.05). The cost (including GST) of each item is to be calculated and stored in the corresponding cells of column C as (Rate/gm) * Wt in gm * GST.

Based on the above case, answer the following questions:

(a) Which of the following represents cell D1 as absolute?

1. $D1$
2. D$1$
3. $D$1
4. D1$

(b) What will happen when cell C1 is absolute and used in the formula to find cost in the cells from C4 to C7?

1. All cell values from C4 to C7 will become 0 (zero).
2. The cell value D1 will be shifted into the cell C1.
3. The cell value D1 will be copied into the cell C1.
4. All the cell values from C4 to C7 will occupy same non-zero values.

(c) What will be the formula to calculate the cost in column C4?

1. A4 * B4 * D1
2. A4 * B4 * $D$1
3. A4 * $B4$ * D1
4. $A4$ * $B4$ * $d4$

(d) What will be the formula to calculate the cost in column C7?

1. $A$7 * B7 * D1
2. A7 * B7 * $D$1
3. A$7$ * B$7$ * D1
4. A7 * B7 * $D1$

(a) $D$1

Reason — We add '$' sign before a column and row to make it absolute.

(b) All cell values from C4 to C7 will become 0 (zero).

Reason — The result is zero because cell C1 is empty and as a result its numeric value will be taken as 0.

(c) A4 * B4 * $D$1

Reason — We add '$' sign before a column and row to make it absolute. Hence the value of GST % in cell D1 remains the same while the cost changes according to cell C4, C5…and so on.

Note — There is a misprint in the options. Cell D1 has been incorrectly referred to as C1. This error has been fixed in the question here.

(d) A7 * B7 * $D$1

Reason — A7 and B7, being relative references will change while $D$1 being absolute reference will remain the same.