CommencerCommencer gratuitement

Working with text and numbers

Each cell value in a spreadsheet has a data type, which affects the operations that can be performed on the cell and the way the value is displayed in the spreadsheet.

In this exercise, you'll format the numerical data in the Weight column to decrease the number of decimal places displayed, and store percentages as plain text.

Cet exercice fait partie du cours

Introduction to Google Sheets

Afficher le cours

Instructions

  • Display the cell values in the Weight column to the nearest whole number.
  • Add the value 21% to cell F2, and force it to have the plain text data type.

Exercice interactif pratique

Passez de la théorie à la pratique avec l’un de nos exercices interactifs

Commencer l’exercice