medium10 pts · first answer countsexcelcell-references

One formula for a whole grid

Row 1 (B1:K1) holds 1–10 and column A (A2:A11) holds 1–10. Which formula in B2 can be copied across and down to fill a multiplication table?

A.=A2*B1B.=$A$2*$B$1C.=A$2*$B1D.=$A2*B$1

Discussion 0

Join free to post in the discussion.