시작하기무료로 시작하기

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.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작