Question

If you copy a formula = Max ($D$1:$D$4) from cell D5 to cell H5 then what will show in

H5?

a) =Max(D1:D4)

c) =Max ($D$1:$D$4)

b) =Max (H1: H4)

d) =Max ($H$1:$H$4)​

Answer 1

Answer:

you put dollar sign so no change in cell reference

answer us c