Skip to content Skip to sidebar Skip to footer

[ADS]Tips-if_Bagian_Atas

Objective 3.2 Practice Task Excel 2016 Microsoft Office Specialist

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.

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