開始使用免費開始

Copying references

Referencing becomes especially useful if you start copying the references around. When you copy formulas containing references to neighboring cells, the references will shift along by the corresponding amount.

本練習屬於課程

Google Sheets 入門

檢視課程

練習說明

  • In E2, create a cell reference to C2.
  • Copy the cell reference in E2 to populate E2:E11 with the Population values.
  • Populate F2:F11 with the Land Area (km2) values by copying references.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習