시작하기무료로 시작하기

Rounding values

You've learned how built-in functions can be used as a shortcut to creating complex formulas in Google Sheets.

Functions take inputs, also known as arguments, and return an output, which is the result of the calculation.

You'll begin working with built-in functions using a dataset containing natural satellites (moons) of solar system planets. The dataset contains four columns:

  • Name: The name of the moon
  • Parent: The planet that the moon orbits
  • Mean radius (km): The average radius of the moon from its physical center
  • Sidereal period (days): The time taken for the moon to orbit its parent planet

이 연습은 강의의 일부입니다

Google Sheets로 하는 데이터 분석

강의 보기

연습 안내

  • In E2:E208, calculate the sidereal period in hours.
  • In F2:F208, round Sidereal period (hrs) to one decimal place.
  • In G2:G208, round Mean radius (km) to the nearest whole number.

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

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

연습 시작