Translations:Basic Excel Trainer/111/en
- Copy the date 11/06/2012 to all H. Muhtar and Ruslan samples (B2:B243).
- Copy the date 13/06/2012 to all H.M. Yasmin samples (B244:B363).
- Copy the date 12/06/2012 to all remaining rows (B364:B543).
- Unmerge each of the merged entities in column E (Kandung), and then copy the shed identifier to each of the cells that had been part of the merge.
- For example, E2:E16 contained '2200 (shed 1)'.
- Each cell in E2:E16 needs to contain 'Shed 1'.
- Watch out for (and correct!) the incorrect shed number in cells E77:E91. Listed as 7, but should be 6.
- Make sure to discuss how data entry errors should be documented and handled.
- Be careful to 'Salin sel', not 'Isi seri', when copying items containing numbers.
- Make a copy of the worksheet, place it at the end, and name the copy STEP4.
- Save the workbook.