Translations:Basic Excel Trainer/111/en

  1. Copy the date 11/06/2012 to all H. Muhtar and Ruslan samples (B2:B243).
  2. Copy the date 13/06/2012 to all H.M. Yasmin samples (B244:B363).
  3. Copy the date 12/06/2012 to all remaining rows (B364:B543).
  4. 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.
  5. Make a copy of the worksheet, place it at the end, and name the copy STEP4.
  6. Save the workbook.