Microsoft Word
Chapter One
-Enter text in a word document
-Check spelling as you type -Format paragraphs -Format text -Undo and redo commands or actions -Change theme colors |
-Insert digital pictures in a Word document
-Format pictures -Add a page border -Correct errors and revise a document -Change document properties -Print a document |
Chapter Two
-Describe the MLA documentation style for research papers
- Change line and paragraph spacing in a document - Modify a style -Use a header to number pages of a document -Apply formatting using shortcut keys -Modify paragraph indentation |
-Insert and edit citations and their sources
-Add a footnote to a document -Insert a manual page break -Create a bibliographical list of sources -Cut, Copy, and paste text -Find text and replace text -Find a synonym -Use the Research task pane to look up information |
Chapter Three
-Change margins
-Insert and format a shape -Change text wrapping -Insert and format a clip art image -Insert a symbol -Add a border to a paragraph -Clear formatting -Convert a hyperlink to regular text |
-Create a file from an existing file
-Apply a Quick Style -Set and use tab stops -Insert the current date -Create, insert, and modify a building block -Insert a Word table, enter data in the table, and format the table -Address and print an envelope |
Microsoft Excel
Chapter One
-Describe the Excel worksheet
-Enter text and numbers -Use the Sum button to sum a range of cells -Copy the contents of a cell to a range of cells using teh fill handle -Apply cell styles -Format cells in a worksheet |
-Create a Clustered Cylinder chart
-Change a worksheet name and worksheet tab color -Change document properties -Preview and print a worksheet -Use the AutoCalculate area to display statistics -Correct errors on a worksheet |
Chapter Two
-Enter formulas using the keyboard
-Enter formulas using Point mode -Apply the AVERAGE, MAX, and MIN functions -Verify a formula using Range Finder -Apply a theme to a workbook -Apply a date format to a cell or range |
-Add conditional formatting to cells
-Change column width and row height -Check the spelling in a worksheet -Set margins, headers, and footers in Page Layout view -Preview and print versions of a worksheet |
Chapter Three
-Rotate text in a cell
-Create a series of month names -Copy, paste, insert, and delete cells -Format numbers using format symbols -Freeze and unfreeze rows and columns -Show and format the system date -Use absolute and mixed cell references in a formula -Use the lF function to perform a logical test |
-Create Sparkline charts
-Use the Format Painter button to format cells -Create a 3-D Pie chart on a separate chart sheet -Rearrange worksheet tabs -Change the worksheet view -Answer what-if questions -Goal seek to answer what-if questions |
Microsoft Access
Chapter One
-Design a database to satisfy a collection of requirements
-Describe the features of the Access window -Create a database -Create tables in Datasheet and Design views -Add records to a table |
-Close a database
-Open a database -Print the contents of a table -Create and use a query -Create and use a form -Create and print custom reports -Modify a report in Layout view |
Chapter Two
-Add, change, and delete records
-Search for records -Filter records -Update a table design -Use action queries to update records -Use delete queries to delete records -Specify validation rules, default values, and formats |
-Create and use single-valued lookup fields
-Create and use multivalued lookup fields -Add new fields to an existing report -Format a datasheet -Specify referential integrity -Use a subdatasheet -Sort records |
Chapter Three
-Add, change, and delete records
-Search for records -Filter records -Update a table design -Use action queries to update records -Use delete queries to delete records -Specify validation rules, default values, and formats |
-Create and use single-valued lookup fields
-Create and use multivalued lookup fields -Add new fields to an existing report -Format a datasheet -Specify referential integrity -Use a subdatasheet -Sort records |
Microsoft PowerPoint
Chapter One
-Select a document theme
-Create a title slide and a text slide with a multi-level bulleted list -Add new slides and change slide layouts -Insert clips and pictures into a slide with and without a content placeholder -Move and size clip art |
-Change font size and color
-Bold and italicize text -Duplicate a slide -Arrange slides -Select slide transitions -View a presentation in Slide Show view -Print a presentation |
Chapter Two
-Change theme colors
-Insert a picture to create a background -Format slide backgrounds -Insert and size a shape -Add text to a shape |
-Apply effects to a shape
-Change the font and add a shadow -Format pictures -Apply a WordArt style -Format WordArt -Format text using the Format Painter |
Chapter Three
-Color a picture
-Add an artistic effect to a picture -Delete and move placeholders -Align paragraph text -Copy a slide element from one slide to another |
-Ungroup, change the color, and regroup a clip
-Insert and edit a video clip -Insert audio -Control audio and video clips -Check for spelling errors -Print a presentation as a handout |