Hunter notices that the number in cell 4 of his table has changed even though he only changed the number in cell 2, which is two rows above cell 4. what best describes why this happened? a) cell 4 is part of cell 2’s formula. b) cell 2 is part of cell 4’s formula. c)the cells have been sorted by cell 4. d)the cells have been sorted by cell 2.

B) Cell 2 is part of Cell 4s formula

Because we are changing the value of Cell 2 and the change is being made in Cell 4 automatically. For example

if C4 is our Cell 4 and C2 is our Cell 2

and our formulat is

C4 = C2 + 10

Then whenever we will change the value of C2 the value of C4 will be changed.

In option C and D the change in C2 can effect the value of C4 but that would not happen everytime the value of C2.

answer would be