McCombs School of Business
Technology Training Team
Training Team : Tutorials : CPT Skills

CPT Skills Review

The Computer Proficiency Test (CPT) will test your skills in Microsoft Word, PowerPoint, and Excel. The following website demonstrates the basic skills on which you will be tested. It does not contain the exact questions from the test.
For more information about the Computer Proficiency Test go to http://www.mccombs.utexas.edu/udean/admissions/proficiencytest.asp.

Test Taking Tips & Tricks:

  • Don't hit the Back button. On the CPT exam, you will see Back and Next buttons. Pressing the Back button will skip the question you are on and count it wrong. You can press Next - this will move you to the next question but repeat the skipped question later in the test.
  • Only use the menus and icons, not keyboard shortcuts or right-click menus. Many parts of the test do not have keyboard shortcuts and right-click menus enabled, so you should learn the alternate way to complete these skills.
  • Read the question carefully. Does it mention Format? There is an entire format menu - check it out! Does it tell you to insert something? Start with the Insert menu. The question will give you clues. Also, pay attention to the general skill listed in the upper right corner of the testing screen, that may also give you ideas.
  • You can look through the menus, just don't click on a choice till you are certain. Can't remember if Printing is under File or Edit? You can look under both menus, but once you click Print, you're stuck with it.

About the Online Training Modules:

The online training modules allow you to see how to perform the skill and then allow you to practice. During the practices, the modules will automatically type any text for you. When you take the CPT, you will  have to type the text yourself. Make sure you spell things right!

The online modules use Office 2003 whereas the test uses Office XP, so the programs may look slightly different when you take the test, but all functionality and program options are the same.

Online Training Modules
(recommended)

Word
Create a new document
Save the document in the current folder
Change the document orientation
Change the margins
Apply columns to text
Indent first line of paragraph
Apply bullets to a list of items
Add a footer to the document
Format the page numbers
Bold text
Delete text
Center text
Correct spelling
Insert symbols
Insert a table
Find and replace words
Print selected pages

PowerPoint
Create a new presentation
Create a new presentation using the AutoContent Wizard
Create a new presentation using a template
Enter text in the Outline pane
Change the slide layout
Delete slides
Change text fonts
Change bullets and numbering formats
Change the layout of all slides at once
Add the date and time as a footer
Move slides in Slide Sorter
Insert clip art
Insert a chart
Change chart type
Animate WordArt
Print outlines
Print handouts

Excel
Open a saved workbook
Freeze cells
Type functions
Format decimal places
Save workbook in a new folder

 

Instructions Only

Word
Create a new document
Save the document in the current folder
Change the document orientation
Change the margins
Apply columns to text
Indent first line of paragraph
Apply bullets to a list of items
Add a footer to the document
Format the page numbers
Bold text
Delete text
Center text
Correct spelling
Insert symbols
Insert a table
Find and replace words
Print selected pages

PowerPoint
Create a new presentation
Create a new presentation using the AutoContent Wizard
Create a new presentation using a template
Enter text in the Outline pane
Change the slide layout
Delete slides
Change text fonts
Change bullets and numbering formats
Change the layout of all slides at once
Add the date and time as a footer
Move slides in Slide Sorter
Insert clip art
Insert a chart
Change chart type
Animate WordArt
Print outlines
Print handouts

Excel
Open a saved workbook
Freeze cells
Type functions
Format decimal places
Save workbook in a new folder