Human Resources
University of Arkansas
222 Administration Building
Fayetteville, AR 72701
Tel: (479)-575-5351
Fax: (479) 575-6971
Contact Us
Proficiency Testing
In an effort to assist supervisors and managers in making good hiring decisions, Human Resources provides testing for positions where levels of proficiency in specific office software is imperative to the satisfactory performance of those positions. Below is a listing of the software programs that are available for departments to request as preferred qualifications in the selection and referral of applicants. It included levels of proficiency for certain software programs and general speed or speed for others.
Basic
- Creating Databases and Tables
- Creating Forms
- Entering Records Using a Data Sheet or Form
- Navigating Through Records
- Sorting, Finding and Deleting Records
- Creating and Running Queries
- Creating and Printing Reports
Intermediate
- Setting Primary Keys
- Modifying Data Type and Field Properties
- Adding and Modifying Form Controls
- Modifying Queries
- Moving and Resizing Controls
- Changing Report Control Formatting
Advanced
- Importing Data to a New Table
- Repairing Databases and Printing Database Relationships
- Adding Hyperlinks to Reports and Saving Reports to Web Pages
Tuesday, September 29, 2009 12:34 AM
Basic
- Opening, Saving and Closing Documents
- Cutting and Pasting Text
- Spell Check
- Creating a New Document
- Formatting Text (Centering, Font Size, Selecting)
Intermediate
- Draw a Line
- Format Documents (Margins, Page Numbering, Use Web Pages, Columns)
- Replacing Text
- Macros
- Set File Default Locations
- Creating New Auto Text and Autp Correct Entries
- Creating Styles and Macros
- Inserting Bookmarks and Table of Contents
- Formatting Tables and Converting Text to Tables
Advanced
- Group Objects
- Internet Address
- Using Legal Tools such as Line Numbering, Marking Table of Authorities and Revisions
- Creating Merge Mailing Labels and Adding Fields to a Merge
- Using Email
- Create Form Fields
- Pasting Hyperlinks
- Insert Cross Reference
- Using Formulas in Tables
- Using Master Documents
- Highlighting Changes
Tuesday, September 29, 2009 12:33 AM
Basic
- Opening a New Presentation or Starting an Existing Presentation
- Working with Text (Bolding, Cutting, Changing Fonts)
- Changing Views
- Exit PowerPoint
- Working with Slides (Adding Text, Inserting, Deleting and Going to the Next Slide
Intermediate
- Saving a presentation as HTML
- Printing Slides
- Adding Transitions and Animations
- Demoting Points
- Applying New Presentation Designs, Creating Slide Masters
- Inserting Page Numbers
- Rearranging Slides
- Inserting Clip Art, Organizational Charts, Charts
- Moving and Drawing Objects
- Adding a Subordinate
- Changing Line Color
Advanced
- Hide Slides
- Set Automatic Slide Timings
- Viewing Slide Shows on The Web
Tuesday, September 29, 2009 12:31 AM
Basic
- Setting and Changing Font Styles
- Editing and Clearing Cells
- Cutting and Pasting Cells
- Saving a Worksheet
- Entering Labels
- Selecting a Range of Cells
- Numbering Formatting
- Selecting Columns
- Merging Workbooks
Intermediate
- Working with Charts - Creating Charts, Removing Legends
- Select Non-contigous Cells
- Protect Cells
- Center Across Columns
- Inserting Rows
- Using Borders
- Inserting and Moving Worksheets
- Playing a Macro
- Paste Link
- Protect Cells
- Data Forms
- Use a Named Range in a Formula
- Use AutoFilter
- Using Functions and Formulas (IF/OR)
- Renaming a Worksheet
Advanced
- Web Page Preview
- Naming Cells
- Use Goal Seek
- Consolidate Cells
- Apply Conditional Formatting
- Use Pivot Tables
- Paste Contents on Worksheets
- Import Data from Text Files
- Accept/Reject Changes
Tuesday, September 29, 2009 12:28 AM
Columnar with Decimals - 40 entries
Tuesday, September 29, 2009 12:24 AM
- Spelling
- Recognize Spelling Errors
- Grammar
- Punctuation, Capitalization, Usage
- Sentence Structure
- Usage
Tuesday, September 29, 2009 12:24 AM
5 Minute Timed Test
Tuesday, September 29, 2009 12:22 AM
Basic
- Accessing Help
- My Computer
- Minimizing, Restoring and Closing a Window
- Scrolling
- Customizing Folders
- Running Notepad
- Deleting a Shortcut and Deleting Shortcuts from the Start Menu
- Running Windows Explorer
- Creating and Deleting Folders
- Displaying the Toolbar
- Undo
- Sorting and Copying Files
- Exiting Windows
- Changing Drives
Intermediate
- Changing a Shortcut Name
- Opening a Document from the Start Menu
- Running DOS
- Returning to Windows
- Finding Files
- Emptying the Recycle Bin
Advanced
- Creating a Shortcut on the Desktop
- Adding a Program to the Startup Folder
- Copying Programs
- Adding a Printer
- Installing New Software
Tuesday, September 29, 2009 12:21 AM