Wiki Sumber Informasi iSIKHNAS

Ranges, name ranges and tables

1. Open the AIpivot.xlsx workbook.
   • This is a subset of the data you were working with in the last activity - you should have ended up with something that looks like this.
2. Take some time to quickly check over the data.
   • You should always do this with every dataset you are given.
   • Use the skills from previous sessions (for example, check the extent of the data, apply an autofilter).
   • Are there any obvious issues with data integrity or the processing that has been done?
3. Make two copies of this worksheet.
   • Name the additional copies 'AIData2' and 'AIData3'.