Objective 3.2 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-2 workbook, on the Sales worksheet, do the following:
  Download filenya disini
• Change the table style to Table Style Medium 19.
  Buka sales worksheet -> Blok tabel yang tersedia -> Klik Table Design -> Pada table style pilih table style medium 19
  
  
  
  
• Configure the table style options to format alternating rows with different fill colors.
  Buka sales worksheet -> Blok tabel yang tersedia -> Klik Table Design -> Pada table style option centang Banded rows
  
  
  
  
• Configure the table style options to emphasize the first and last columns of the table.
  Buka sales worksheet -> Blok tabel yang tersedia -> Klik Table Design -> Pada table style option centang last column
  
  
  
  
• Add a total row to the table.
  Buka sales worksheet -> Blok tabel yang tersedia -> Klik Table Design -> Pada table style option centang Total Row
  
  
  
  
• Change the row name from Total to Average.
  Klik tanda panah pada total row -> Pilih Average
  
  
  
  
• Modify the cells in the row to calculate the average sales for each month and for the year.
  Klik tanda panah di kolom paling bawah -> Pilih Average
  
  
  
  
• On the Bonuses worksheet, do the following:
• Remove the formatting from the table.
  Blok table -> Klik Home -> Pada bagian editing klik clear -> Pilih Clear Formating
  
  
  
  
• Save the Excel_3-2 workbook.
• Open the Excel_3-2_results workbook. Compare the two workbooks to check your work.
• Close the open workbooks.