Task List for the CoBE Computer Competency Exam

SAM 2003 Version

Also see the SAM 2007 Version of the Task List.

Excel Tasks

• Merge cells
• Split cells
• Use the fill handle to copy a cell
• Use the fill handle to create a series
• Apply number formats (dates and comma)
• Sort a list on multiple fields
• Filter lists using AutoFilter
• Use Advanced Filter
• Add borders
• Set cell color
• Right align cells
• Indent text
• Wrap text
• Hide rows and columns
• Unhide columns
• Freeze rows and columns
• Modify row heights
• Modify column widths
• Modify worksheet orientation
• Add headers to worksheets
• Change margins in Page Setup
• Control page breaks
• Fit to Print
• Split a window into panes
• Center Across Selection using Alignment tab in Format Cells dialog box
• Insert worksheets into a workbook
• Delete a worksheet from a workbook
• Modify worksheet names
• Create formulas using the formula bar
• Edit a formula
• Use absolute references
• Use relative references
• Create formulas using the SUM function
• Create formulas using the MIN function
• Create formulas using the MAX function
• Create formulas using the DATE function
• Use the AVERAGE function
• Use the ROUND function
• Create charts using the pie chart types
• Create charts using column chart types
• Format charts
• Edit a chart
• Position a chart
• Bring information into Excel from external sources
• Import Access files into a worksheet
• Export structured data from Excel
• Name a range
• Use a named range reference in one or more formulas
• Add subtotals to worksheets
• Remove subtotals
• Create a PivotTable Report
• Create a trendline
• Formatting a PivotTable
• Use OLE to embed an Excel chart into a Word document
• Link an Excel worksheet to a Word document

Access Tasks

• Create a new database
• Open an existing database
• Use Access Help
• Delete records from a table using a datasheet
• Create one or more tables in Design View
• Define text fields
• Define number and currency fields
• Define Date/Time and Yes/No fields
• Specify the Primary Key
• Switch between form view and datasheet view
• Modify field properties for one or more tables in Table Design view
• Change the format property of a field in Table Design View
• Create Select queries using the Simple Query Wizard
• Create forms using the form Wizard
• Modify the properties of a form
• Move a field in a table structure
• Add a field to a table structure
• Create a summary report using Report Wizard
• Add a field to a report
• Add calculated controls to a report section
• Preview a report