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.
Latihan ini adalah bagian dari kursus
Data Visualization in Google Sheets
Petunjuk latihan
- 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!
Latihan interaktif praktis
Ubah teori menjadi tindakan dengan salah satu latihan interaktif kami.
Mulai berolahraga