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.
This exercise is part of the course
Introduction to Google Sheets
Exercise instructions
- Display the cell values in the
Weightcolumn to the nearest whole number. - Add the value
21%to cellF2, and force it to have the plain text data type.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise