始める無料で始める

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.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する