MOS - Nội dung bài thi MOS Excel phiên bản 2010

Cập nhật 08/05/2017 - 09:35:05 (GMT+7)
Chia sẻ
Nội dung bài thi MOS bám sát nội dung của quyển giáo trình MOS 2010 Study Guide for Microsoft Word, Excel, PowerPoint and Outlook. Để đạt được chứng chỉ MOS Specialist ở nội dung Excel 2010 thì người học cần nắng vững các nội dung của bài thi theo dàn ý dưới đây:


 

  • Managing the worksheet environment
  1.  Navigate through a worksheet
  2. Print a worksheet or workbook
  3. Personalise environment by using Backstage

  •   Creating cell data

  1.  Construct cell data
  2. Apply AutoFill
  3. Apply and manipulate hyperlinks

  •  Formatting cells and worksheets

  1.  Apply and modify cell formats
  2. Merge or split cells
  3. Create row and column titles
  4. Hide and unhide rows and columns
  5. Manipulate page setup options for worksheets
  6. Create and apply cell styles

  •  Managing worksheets and workbooks

  1.  Create and format worksheets
  2. Manipulate window views
  3. Manipulate workbook views

  •  Applying formulas and functions

  1.  Create formulas
  2. Enforce precedence
  3. Apply cell references in formulas
  4. Apply conditional logic in a formula
  5. Apply named ranges in formulas
  6. Apply cell ranges in formulas

  •  Presenting data visually

  1. Create charts based on worksheet data
  2. Apply and manipulate illustrations
  3. Create and modify images by using the Image Editor
  4. Apply Sparklines

  •  Sharing worksheet data with other users

  1.  Share spreadsheets by using Backstage
  2. Manage comments

  •  Analysing and organising data

  1.  Filter data
  2. Sort data
  3. Apply conditional formatting

 

Tham khảo thêm tại https://www.microsoft.com/learning/en-sa/exam-77-882.aspx