Working with currencies and dates
Now that you've got the hang of numerical and text data, time to explore dates and currencies! For any value placed into a cell, the spreadsheet will try to determine the correct data type automatically. For example, a cell value starting with $
will automatically be assigned the currency data type.
Sometimes, the data type assigned to the cell value will be incorrect, so you'll have to manually change it to your data type of choice using the Format menu.
Este ejercicio forma parte del curso
Introducción a Google Sheets
Instrucciones de ejercicio
- Change the format of the dates in
D2:D5
fromYYYY-MM-DD
toM/D/YYYY
. - Change the date type of the currencies in
E2:E5
to the currency (rounded) format.
Ejercicio interactivo práctico
Convierte la teoría en acción con uno de nuestros ejercicios interactivos
