|
MOUS Exam Objectives
|
 |
Exam objectives are categories of examination
tasks, identified by subject-matter experts, that certify an ability to
productively use Microsoft Office applications. These categories are
organized into skill sets representing the more basic functions of each
Office application.
Exam objectives and skill sets for the
Microsoft Excel 2000 Core Exam are provided below to assist in your exam
preparation. Training centers and courseware providers authorized by the
Microsoft Office User Specialist (MOUS) program tailor their instruction
to these criteria.
Working with Cells
 | Use Undo and Redo
| Clear cell content
| Enter text, dates, and numbers
| Edit cell content
| Go to a specific cell
| Insert and delete selected cells
| Cut, copy, paste, paste special, and move
selected cells
| Use the Office Clipboard
| Use Find and Replace
| Clear cell formats
| Work with series (AutoFill)
| Create hyperlinks |
| | | | | | | | | | |
Working with Files
| Use Save
| Use Save As (different name, location, and
format)
| Locate and open an existing workbook
| Create a folder
| Use templates to create a new workbook
| Save a worksheet/workbook as a Web Page
| Send a workbook via e-mail
| Use the Microsoft Office Assistant |
| | | | | | |
Formatting Worksheets
| Apply font styles (typeface, size, color,
and styles)
| Apply number formats (currency, percent,
dates, and commas)
| Modify row and column size
| Modify alignment of cell content
| Adjust decimal places
| Use the Format Painter
| Apply autoformat
| Apply cell borders and shading
| Merge cells
| Rotate text and change indents
| Define, apply, and remove a style |
| | | | | | | | | |
Page Setup and Printing
| Preview and print worksheets and workbooks
| Use Web Page Preview
| Print a selection
| Change page orientation and scaling
| Set page margins and centering
| Insert and remove a page break
| Set print, and clear a print area
| Set up headers and footers
| Set print titles and options (gridlines,
print quality, and headings for rows and columns) |
| | | | | | | |
Working with Worksheets and Workbooks
| Insert and delete rows and columns
| Hide and unhide rows and columns
| Freeze and unfreeze rows and columns
| Change the zoom setting
| Move between worksheets in a workbook
| Check spelling
| Rename a worksheet
| Insert and delete worksheets
| Move and copy worksheets
| Link worksheets and consolidate data using
3-D references |
| | | | | | | | |
Working with Formulas and Functions
| Enter a range within a formula in a
drag-and-drop operation
| Enter formulas in a cell and use the formula
bar
| Revise formulas
| Use references (absolute and relative)
| Use AutoSum
| Use the Paste Function to insert a function
| Use basic functions (AVERAGE, SUM, COUNT,
MIN, and MAX)
| Enter functions using the Formula Palette
| Use date functions (NOW and DATE)
| Use financial functions (FV and PMT)
| Use logical functions (IF) |
| | | | | | | | | |
Using Charts and Objects
| Preview and print charts
| Use the Chart Wizard to create a chart
| Modify charts
| Insert, move, and delete an object (graphic)
| Create and modify lines and objects |
| |
| | | |
|
