Setting up your data
In this task, you are going to use data from the ASX for a Company that sells shark repellent systems and prepare it for charting. The first step is to tidy up and format the data.
Este ejercicio forma parte del curso
Data Visualization in Google Sheets
Instrucciones del ejercicio
- Remove the blank row and standardize your decimal places such that the numbers in columns
B:Ehave three decimal places. - Change the format of the date in
I1so that it has the same format as the dates inColumn A.- To do so you will need to select 'Format', and then 'Number' from the menu bar (or alternatively, you can use the '123' dropdown menu from the toolbar).
- Depending on options available to you, you may need to select additional date formats by selecting 'More Formats', and then 'More date and time formats'. This menu will provide you with advanced formatting options.
- Your new format should have the month, day, and year as an integer, separated by a hypthen!
Ejercicio interactivo práctico
Pon en práctica la teoría con uno de nuestros ejercicios interactivos
Empezar ejercicio