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