开始使用免费开始使用

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.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习