Skip to content Skip to sidebar Skip to footer

[ADS]Tips-if_Bagian_Atas

Objective 3.3 Practice Task Excel 2016 Microsoft Office Specialist

Objective 3.3 Practice Task Excel 2016 Microsoft Office Specialist


The practice files for these tasks are located in the practice file folder. The folder also contains a subfolder of result files that you can use to check your work.

  • Open the Excel_3-3 workbook, display the Bonuses worksheet, and do the following:
    Download filenya disini
    • Apply a filter to display only the bonuses that were less than $2,500.00.
      Klik tanda panah pada kolom bonus ->  klik filter -> klik less then


      Pada kolom less then masukkan 2500


  • Display the Products worksheet and do the following:
    • Sort the data in ascending order by category and, within each category, by unit price.
      Blok table yang tersedia -> Klik ribbon home ->  klik sort & filter -> klik custom sort
      Pilih category pada sort by -> Pilih order A to Z pada
      Klik Add level -> Pilih unit price pada then by -> Pilih low to high pada order


    • Sort the data in descending order by category and, within each category, alphabetically by product name.
      Blok table yang tersedia -> Klik ribbon home ->  klik sort & filter -> klik custom sort


      Pilih category pada sort by -> Pilih order Z to A pada
      Klik Add level -> Pilih product name pada then by -> Pilih A to Z pada order

    • Remove duplicates so that there is only one entry for each supplier.
      Klik ribbon Data -> pada bagian Data tools klik Remove Duplicates

      Ceklis supplier -> klik OK


  • Save the Excel_3-3 workbook.
  • Open the Excel_3-3_results workbook. Compare the two workbooks to check your work.

Post a Comment for "Objective 3.3 Practice Task Excel 2016 Microsoft Office Specialist"