|
LC4 Objectives Word (Blue)
Excel
(Green)
PowerPoint (Red) |
|
Word |
2-25 |
Creating a table and Inserting Data |
|
2-26 |
Working with a table and Editing Data |
|
2-27 |
Inserting and Deleting Rows and Columns |
|
2-28 |
Adjusting Column width |
|
2-29 |
Adjusting Row Height |
|
2-30 |
Merging and Splitting Cells |
|
2-31 |
Orienting, Aligning, and Spacing Cell Contents |
|
2-32 |
Modifying Borders |
|
2-33 |
Adding Shading and Patterns |
|
2-34 |
Sorting Data in a Table |
|
2-35 |
Using AutoFormat |
| |
3-1 |
Selecting a Cell and Entering Labels |
|
3-2 |
Selecting a Range of Cells and Entering Values |
|
3-3 |
Selecting the Entire Worksheet and Entering
Dates |
|
Excel |
3-4 |
Editing, Clearing, and Replacing Cell Contents |
|
3-5 |
Cutting, Copying, and Pasting Cells |
|
3-6 |
Selecting, Inserting, and Deleting Cells, Rows,
and Columns |
|
3-7 |
Modify Column Widths and Row Heights |
|
3-8 |
Inserting and Deleting Worksheets |
|
3-9 |
Creating a Custom Number Format |
|
3-10 |
Changing Cell Alignment and Merging Cells |
|
3-11 |
Adding Borders |
|
3-12 |
Applying Colors and Patterns |
|
3-13 |
Using AutoFormat |
|
3-14 |
Sorting Data |
|
3-15 |
Working with Absolute and Relative Cell
References |
|
3-16 |
Entering Formulas |
|
3-17 |
Fixing Errors in Your Formulas |
|
3-18 |
Calculating Value Totals with AutoSum |
|
3-19 |
Creating a Chart |
|
3-20 |
Formatting and Editing Objects in a Chart |
|
3-21 |
Changing a Chart Type and Working with Pie
Charts |
|
3-22 |
Adding Titles, Gridlines, and a Data Table |
|
PowerPoint |
4-1 |
Inserting Slides and Changing Slide Layout |
|
4-2 |
Duplicating, Moving, and Deleting Slides in
Slide Sorter View |
|
4-3 |
Adding Text in Outline View |
|
4-4 |
Editing Text |
|
4-5 |
Formatting Text |
|
4-6 |
Working with Bulleted and Numbered Lists |
|
4-7 |
Inserting and Resizing an Image |
|
4-8 |
Inserting and Resizing Pictures |
|
4-9 |
Creating a Chart |
|
4-10 |
Applying Colors and Shadow |
|
4-11 |
Applying a Design Template |
|
4-12 |
Changing Slide View |
|
4-13 |
Changing Background Color |
|
4-14 |
Using Slide Transitions |
|
4-15 |
Adding Notes to Your Slides |
|
4-16 |
Page Setup for Handouts and Transparencies |
|
4-17 |
Delivering a Presentation on a Computer |