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.