开始使用免费开始使用

Counting cells

There are a few different built-in functions for counting cells in Google Sheets, with each counting cells differently based on the type of data in the cell. These counting functions can not only be used to initially explore your data, but also identify data quality issues, such as columns containing lots of missing values.

In this exercise, you'll utilize the different counting functions to count numerical data, text data, and blank cells in the natural satellites dataset.

本练习是课程的一部分

Google Sheets 数据分析

查看课程

练习说明

  • In F6:I6, count the number of cells containing numerical data in each column.
  • In F7:I7, count the number of cells in each column that contain data of any type.
  • In F8:I8, count the number of blank cells in each column.

动手互动练习

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

开始练习