cell d1 has a value of 450. if cells a1, b1, ...
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