微軟office認(rèn)證考試大綱

評(píng)量項(xiàng)目名稱

管理工作表環(huán)境

Managing the Worksheet Environment

1．瀏覽工作表

1．Navigate through a worksheet

2．打印工作表或工作簿

2．Print a worksheet or workbook

3．利用后臺(tái)個(gè)性化環(huán)境設(shè)置

3．Personalize environment by using Backstage

創(chuàng)建單元格數(shù)據(jù)

Creating Cell Data

1．構(gòu)造單元格的數(shù)據(jù)

1．Construct cell data

2．應(yīng)用自動(dòng)填充柄

2．Apply AutoFill

3．應(yīng)用和處理超鏈接

3．Apply and manipulate hyperlinks

格式化單元格和工作表

Formatting Cells and Worksheets

1．應(yīng)用和修改單元格的格式

1．Apply and modify cell formats

2．合并或拆分單元

2．合并或拆分單元格

3．創(chuàng)建行和列標(biāo)題

3．Create row and column titles

4．隱藏和取消隱藏行和列

4．Hide and unhide rows and columns

5．處理工作表的頁(yè)面設(shè)置選項(xiàng)

5．Manipulate Page Setup options for worksheets

6．創(chuàng)建和應(yīng)用單元格樣式

6．Create and apply cell styles

管理工作表和工作簿

Managing Worksheets and Workbooks

1．創(chuàng)建和格式化工作表

1．Create and format worksheets

2．操作窗口的視窗

2．Manipulate window views

3．操作工作簿的視窗

3．Manipulate workbook views

應(yīng)用公式和函數(shù)

Applying Formulas and Functions

1．創(chuàng)建公式

1．Create formulas

2．強(qiáng)制優(yōu)先級(jí)

2．Enforce precedence

3．在公式中應(yīng)用單元格引用

3．Apply cell references in formulas

4．公式中應(yīng)用條件邏輯

4．Apply conditional logic in a formula

5．公式中應(yīng)用名稱定義

5．Apply named ranges in formulas

6．公式中應(yīng)用單元格區(qū)域

6．Apply cell ranges in formulas

呈現(xiàn)可視化數(shù)據(jù)

Presenting Data Visually

1．創(chuàng)建基于工作表數(shù)據(jù)的圖表

1．Create charts based on worksheet data

2．應(yīng)用和操作插圖

2．Apply and manipulate illustrations

3．應(yīng)用Sparklines圖示工具

3．Apply Sparklines

與其他用戶共享工作表數(shù)據(jù)

Sharing worksheet data with other users

1．通過使用后臺(tái)共享電子表格

1．Share spreadsheets by using Backstage

2．管理批注

2．Manage comments

分析和組織數(shù)據(jù)

Analyzing and Organizing Data

1．篩選數(shù)據(jù)

1．Filter data

2．排序數(shù)據(jù)

2．Filter data

3．應(yīng)用條件格式

3．Apply conditional formatting