cell d1 has a value of 450. if cells a1, b1, and c1 each contain the formula =$d$1, the value of each cell…

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 following? a 450, 460, 470 b 450, 450, 450 c 450, 550, 650 d 550, 650, 750

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 following? a 450, 460, 470 b 450, 450, 450 c 450, 550, 650 d 550, 650, 750

Answer

Explanation:

Step1: Understand absolute reference

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

Step2: Determine values in A1, B1, C1

Since A1, B1, and C1 all have the formula =$D$1 and the value in D1 is 450, the value in A1 = 450, the value in B1 = 450, and the value in C1 = 450.

Answer:

B. 450, 450, 450