Question

cell d1 has a value of 450. if cells a1, b1, and c1 each contain the formula =$d$1, the value of each cell respectively is which of the following? a 450, 450, 450 b 450, 460, 470 c 550, 650, 750 d 450, 550, 650

Explanation:

Step1: Understand absolute - reference formula

The formula =$D$1 is an absolute - reference formula in spreadsheet. It always refers to the value in cell D1 regardless of where the formula is copied.

Step2: Determine cell values

Since cells A1, B1, and C1 all have the formula =$D$1 and the value of cell D1 is 450, the value of cells A1, B1, and C1 will all be 450.

Answer:

A. 450, 450, 450