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.

Respuesta :

Iqta

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:

B is indeed the answer

Explanation: