A-to-Z Index

Tech Level I - Skills by Exam

Word Processing Skills

(Word)

Graphics Presentation Skills (PowerPoint)

Spreadsheet Presentation Skills (Excel)

Insert a page number

Apply a theme

Manage worksheets

Add a cover page and revise page numbers

Add pictures and modify a caption

 Adjust column width and row height

Insert pictures from a file

Entering presentation text and saving a presentation 

Merge and center the title

Check Spelling and Grammar

Inserting a new slide

Wrap and align text

Create and modify footnotes

Increasing and decreasing list levels

Apply number formats and decimal places

Set document margins

Adding speaker's notes to a presentation

Use the SUM function

Find and replace text

 Inserting headers and footers

Create a clustered column chart

Create a bulleted and numbered lists

Modifying slide layouts

Freeze and unfreeze panes

 Indent Text

Deleting slide sin slide sorter view

Set and clear a print area

Create columns

Moving slides in slide sorter view

Sort individual columns

Set tab stops

Inserting a video

Inserting and deleting rows and columns

Create tables

Creating a table

Construct and copy formulas containing absolute value

Add citations

Creating a column chart and applying a style

 Change values and display formulas

Modify line and paragraph spacing

Start a slide show

Move a row

Format text using format painter

 Use outline view

Navigating a worksheet and a workbook

Add rows and columns to tables

 Import a rich text format outline

Enter a date and clear cell contents

Wrapping text around a picture

Save as a PowerPoint show

Create and correct a circular reference

Use print features

Annotate a slide

 Use the MIN, MAX and COUNT functions

Format text and page numbers in a research paper

 Identifying parts of the PowerPoint window

Construct multiplication and division formulas

Adding text to a table

Applying a style to a picture

Create an Excel table

Last updated Fall 2011