Skills

SKILL 1

Create and Save a New Workbook

SKILL 2

Enter Worksheet Data and Merge and Center Titles

SKILL 3

Adjust Column Widths and Format Cells

SKILL 4

Use the SUM function

SKILL 5

Copy Formulas and Insert Columns

SKILL 6

Format, Edit, and Check Spelling of Data

SKILL 7

Create a Column Chart

SKILL 8

Format a Column Chart

SKILL 9

Create a Footer Containing a Graphic

SKILL 10

Display and Print Formulas and Scale a Worksheet for Printing

Omit SKILL 11

Create a New Workbook by Using a Template

Omit SKILL 12

Create a Chart Type

Omit SKILL 13

Change the Office Theme in an Excel Workbook

Omit SKILL 14

Manage Document Properties in an Excel Workbook

Skills

SKILL 1

Create a New Workbook from an Existing Workbook and Align Text

SKILL 2

Construct Formulas for Mathematical Operations

SKILL 3

Format Numbers

SKILL 4

Construct and Copy Formulas Containing Absolute Cell References

SKILL 5

Format Percentages and Insert Rows in a Worksheet Containing Formulas

SKILL 6

Create a Pie Chart and a Chart Sheet

SKILL 7

Format a Pie Chart with 3-D and Rotate Slices

SKILL 8

Explode and Color a Pie Slice, Format the Chart Area, and Insert a Text Box

SKILL 9

Edit a Workbook, Update a Chart, and Insert WordArt

SKILL 10

Prepare a Chart Sheet for Printing

SKILL 11

Add and Edit Comments

Omit SKILL 12

Use Range Names in a Formula

Omit SKILL 13

Use the Payment (PMT) Function

Omit SKILL 14

Use Goal Seek

Skills

SKILL 1

Navigate, Rename, and Change the Tab Color of Worksheets

SKILL 2

Enter and Format Dates

SKILL 3

Clear Cells of Contents and Formats

SKILL 4

Move, Copy, and Paste Cell Contents

Skills

SKILL 1

Use the SUM and AVERAGE Functions

SKILL 2

Use the MEDIAN, MIN, and MAX Functions

SKILL 3

Move Data, Add Borders, and Rotate Text