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.