Microsoft Word
Chapter Four
-Border a paragraph
-Change paragraph indentation -Insert and format a SmartArt graphic -Apply character effects -Insert a section break -Insert a Word document in an open document -Change theme fonts |
-Insert formatted headers and footers
-Sort lists and tables -Use the format painter -Add picture bullets to a list -Create a multilevel list -Modify and format Word tables -Sum columns in a table -Create a watermark |
Chapter Five
-Use a template to create a document
-Change a document theme -Fill in a document template -Indent a paragraph -Insert a building block -Customize theme fonts -Create a Quick Style |
-Modify a style
-Save a Word document as a PDF or XPS document -Send a Word document using email -Save a Word document as a Web page -Format text as a hyperlink -Add a background |
Chapter Six
-Explain the merge process
-Use the Mail Merge task pane and the Mailings tab on the Ribbon -Use a letter template as the main document for a mail merge -Create and edit a data source -Insert merge fields in a main document -Use an IF field in a main document |
-Merge and print form letters
-Select records to merge -Sort data records -Address and print mailing labels and envelopes -Change page orientation -Merge all data records to a directory -Convert text to a table |
Chapter Seven
-Insert and format WordArt
-Set custom margins -Crop a graphic -Rotate a graphic -Format a document in multiple columns -Justify a paragraph -Hyphenate a document |
-Format a character as a drop cap
-Insert a column break -Insert and format a text box -Copy and paste using a split window -Balance columns -Modify and format a SmartArt graphic -Copy and paste using the Office Clipboard |
Microsoft Excel
Chapter Four
-Control the color and thickness of outlines and borders
-Assign a name to a cell and refer to the cell in a formula using the assigned name -Determine the monthly payment of a loan using the financial function PMT -Use the financial functions PV (present value) and FV (future value) -Create a data table to analyze data in a worksheet -Add a pointer to a data table |
-Create an amortization schedule
-Analyze worksheet data by changing values -Use names and print sections of a worksheet -Set print options -Protect and unprotect cells in a worksheet -Use the formula checking features in Excel -Hide and unhide cell gridlines, rows, columns, sheets, and workbooks |
Chapter Five
-Create and manipulate a table
-Delete sheets in a workbook -Add calculated columns to a table -Use icon sets with conditional formatting -Use the VLOOKUP function to look up a value in a table -Print a table -Add and delete records and change field values in a table |
-Sort a table on one field or multiple fields
-Query a table -Apply database functions, the SUMIF function, and the COUNTIF function -Use the MATCH and INDEX functions to look up a value in a table -Display automatic subtotals -Use Group and Outline features to hide and unhide data |
Chapter Six
-Use the ROUND function
-Use custom format codes -Define, apply, and remove a style -Add a worksheet to a workbook -Create formulas that use 3-D cell references -Add data to multiple worksheets at the same time |
-Add a header or footer and change margins
-Insert and move a page break -Save a workbook as a PDF or XPS file -Create a workspace file -Consolidate data by linking workbooks |
Chapter Seven
-Create and use a template
-Import data from a text file, an Access database, a Web page, and a Word doc -Transpose data while pasting it -Convert text to columns -Use Fine and Replace commands |
-Draw a Clustered Cone chart
-Use WordArt to create a title and to create and modify shapes -Insert and modify shapes -Insert and modify a SmartArt graphic -Insert a screen shot |
Microsoft Access
Chapter Four
-Create reports and forms using wizards
-Modify reports and forms in Layout view -Group and sort in a report -Add totals and subtotals to a report -Conditionally format controls -Resize columns -Filter records in reports and forms |
-Print reports and forms
-Apply themes -Add a field to a report or form -Include gridlines -Add a data -Change the format of a control -Move controls -Create and print mailing labels |
Chapter Five
-Add Yes/No, Date/Time, Memo, OLE Object, and Attachment fields
-Use the Input Mask Wizard -Update fields and enter data -Change row and column size -Create a form with a subform in Design view -Modify a subform and form design |
-Enhance the form title
-Change tab stops and tab order -Use the form to view data and attachments -View object dependencies -Use Date/Time, Memo, and Yes/No fields in a query -Create a form with a datasheet |
Chapter Six
-Create and relate additional tables
-Create queries for reports -Create reports in Design view -Add fields and text boxes to a report -Format report controls -Group and ungroup report controls -Update multiple report controls |
-Add and modify a subreport
-Modify section properties -Add a title, page number, and date -Preview, print, and publish a report -Add totals and subtotals -Include a conditional value in a report |
Chapter Seven
-Change the font or font size for SQL queries
-Create SQL queries -Include fields in SQL queries -Include simple and compound criteria in SQL queries -Sort the results in SQL queries |
-Use aggregate functions in SQL queries
-Group the results in SQL queries -Join tables in SQL queries -Use subqueries -Compare SQL queries with Access-generate SQL -Use INSERT, UPDATE, and DELETE queries to update a database |
Microsoft PowerPoint
Chapter Four
-Insert a SmartArt graphic
-Insert images from a file into a SmartArt graphic -Convert text to a SmartArt graphic -Format a SmartArt graphic -Create and format a chart -Change the chart slice outline weight and color |
-Rotate a chart
-Change the chart title and legend -Crate and format a table -Change table text alignment and orientation -Add an image to a table -Insert a symbol |
Chapter Five
-Combine slide shows
-Accept and reject a reviewer's proposed changes -Insert, modify, and delete comments -Reuse slides from an existing presentation -Capture part of a slide using screen clipping -Insert slide footer content |
-Set slide and presentation resolution
-Save a file as a PowerPoint show -Package a presentation for storage on a compac disc -Save a presentation in a previous PowerPoint format -Inspect and protect files -Annotate slide shows with a pen and highlighter |
Chapter Six
-Create a presentation from a Microsoft Word outline
-Add hyperlinks to slides and objects -Hyperlink to other Microsoft Office documents -Add action buttons and action settings -Display guides to position slide elements |
-Set placeholder margins
-Create columns in a placeholder -Change paragraph line spacing -Format bullet size and color -Change bullet characters to pictures and numbers -Hide slides |
Chapter Seven
-Remove a picture background
-Crop and compress a picture -Insert entrance, emphases, and exit effects -Add and adjust motion paths -Reorder animation sequences -Associate sounds with animations |
-Control animation timing
-Animate SmartArt graphics and charts -Insert and animate a text bok -Animate bulleted lists -Rehearse timings -Set slide show timings manually |