1.

0. =SUM(C4:E4) is an example ofcell reference.​

Answer»

tion:When a formula appears =$A$4 the COLUMN is fixed and the row is fixed. ABSOLUTE cell references do not CHANGE when a formula is COPIED from one cell to another. Placing a dollar sign before either the row or column fixes the row or column so it will not be changed in the formula.



Discussion

No Comment Found

Related InterviewSolutions