# Computer Skills and Concepts Requirements

Listed below are the Office 365/2016 skills which will possibly be evaluated on the Computer Assessment. To further aid in your study, please view Microsoft Office Tutorials. Office 365/2016 PC version skills will be evaluated.

Review the material below as well as other Office 365/2016 learning materials prior to taking the Computer Assessment.

## Tools for success

"INFT 110 opened my eyes to ... functions of the computer that I would not have learned on my own. It also opened several doors for me. By embracing the class and working hard, I was prepared for the next level computer class and I was actually able to become the tutor for INFT 110. Taking INFT 110 also prepared me for the tasks that I have to complete in my Biology classes."

-  Jackie Caulfield

## Word

### Plan and create a document

• Enter text
• Save As
• Save
• Create a folder
• Print preview
• Print

### Edit a document

• Spell Check
• Thesaurus
• Grammar check
• Cut and paste
• Copy and paste
• Undo
• Redo
• Find and replace text
• Format painter

### Format a document

• Change margins
• Create tabs using the ruler and dialog box
• Left tab
• Right tab
• Center tab
• Decimal tab
• Bold, underline and italicize text
• Create bullets and numbering
• Change fonts and font sizes
• Change spacing
• Insert breaks
• Insert footnotes/endnotes
• Center text horizontally and vertically
• Create a table
• Sort information in a table
• Format a table
• Create formulas in a table
• Number pages using Quickparts
• Bullet lists in a table
• Merge cells in a table
• Create Borders
• Create a reference page

## Excel

• Start Excel
• Navigate a worksheet
• Insert text
• Delete rows and Columns
• Enter numbers
• Construct a formula
• Copy a formula
• Format cells
• Create charts
• Use the help feature
• Clear the contents of a cell
• Move a cell
• Format a cell
• Print worksheets
• Perform a what-if analysis
• Use functions to total
• Use functions to average
• Autocomplete
• Display, print and hide formulas
• Absolute cell referencing
• Use built in functions
• Freeze and Unfreeze panes

## PowerPoint

• Open a presentation
• Create folders
• Save presentations
• Editing slide text
• Insert new slides
• Check spelling
• Increase and decrease list levels
• Use the Thesaurus
• Change font style and size
• Insert slides