开始使用免费开始使用

Summing using a named range

In addition to being a handy way of keeping track of a range of cells, named ranges can also be used in formulas.

For example, using the formula =AVERAGE(Total) would return the average of the totals contained within the Total named range.

In this task you will remove a blank row and use the named range Total in a formula.

本练习是课程的一部分

Google Sheets 数据可视化

查看课程

练习说明

  • Remove the blank row you inserted in the last exercise.
  • In B10, use the SUM() function to aggregate the Total named range.

动手互动练习

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

开始练习