Prentice Hall MOUS Test Preparation Guide: Excel 2000 Table of Contents
Chapter 1	Get Started with Excel
	Start Excel Set up the menus and toolbars Enter text, dates, and numbers Enter functions Save a Document the first time Save another version of a file Create New Folder Print a document using the button New workbook Use the Office Assistant Exit Excel
Chapter 2	Edit Worksheet Contents
	Open an Existing Workbook Edit cell content Enter formulas in a cell and using the formula bar Revise formulas Clear cell content Use Undo and Redo Work with series (AutoFill) Check spelling Use Find and Replace Chapter 3 Modify Worksheet Structure Insert and delete rows and columns Apply number formats (currency, percent, dates, comma) Adjust the decimal place Modify size of rows and columns Insert and delete selected cells Cut, copy, paste, paste special and move selected cells, use the Office Clipboard Freeze and unfreeze rows and columns
Chapter 4	Use Complex Formulas
	Use references (absolute and relative) Move Around in a (navigate w keys & mouse) Enter a range within a formula by dragging Add and delete a named range Use a named range in a formula Work with the Auditing Toolbar Trace errors (find and fix errors) Trace precedents (find cells referred to in a specific formula) Trace dependents (find formulas that refer to a specific cell) Use Goal Seek
Chapter 5	Manage Pages and Printing
	Hide and unhide rows and columns Change the zoom setting Preview and print worksheets & workbooks 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, row & column headings)
Chapter 6	Format Worksheets
	Apply font styles (typeface, size, color and styles) Modify alignment of cell content Clear cell formats Use the Format Painter Apply autoformat Apply cell borders and shading Merging cells Rotate text and change indents Define, apply, and remove a style Apply number formats (accounting, currency, number) Create custom number formats Insert, move, and delete an object (picture) Create and modify lines and objects
Chapter 7	Use Functions
	Use basic functions (AVERAGE, SUM, COUNT, MIN, MAX) Use date functions (NOW and DATE) Use logical functions (IF) Use conditional formatting Use Lookup Functions (Hlookup or Vlookup)
Chapter 8	Use Financial Functions
	Use Paste Function to insert a function Enter functions using the formula palette Use financial functions (FV and PMT)
Chapter 9	Create Charts
	Preview and print charts Use chart wizard to create a chart Modify charts Hide and display toolbars Save a worksheet/workbook as a Web Page Use Web Page Preview Create hyperlinks
Chapter 10	Use Excel with the Web
	Save a worksheet/workbook as a Web Page Use Web Page Preview Create hyperlinks Send a workbook via email
Chapter 11	Handle Multiple Worksheets
	Move between worksheets in a workbook Rename a worksheet Insert and Delete worksheets Move and copy worksheets Link worksheets & consolidate data using 3D References Using a workspace Link workbooks Print and preview multiple worksheets
Chapter 12	Import and Export
	Import data from text files (insert, drag and drop) Import from other applications Import a table from an HTML file (insert, drag and drop - including HTML round tripping) Export to other applications
Chapter 13	Manage Data and Lists
	Apply conditional formats Perform single and multi-level sorts Use grouping and outlines Use data forms Use subtotaling Apply data filters Extract data Query databases Use data validation
Chapter 14	Use Analysis Tools
	Use PivotTable autoformat Create pivot chart reports Work with Scenarios Use Solver Use data analysis and PivotTables Create interactive PivotTables for the Web Add fields to a PivotTable using the Web browser Use the Report Manager
Chapter 15	Work with Templates
	Apply templates Edit templates Create templates Use templates to create a new workbook
Chapter 16	Create Macros and Customize Excel
	Customize a toolbar Assign a macro to a command button Record macros Run macros Edit macros
Chapter 17	Collaborate with Workgroups
	Create, edit and remove a comment Apply and remove worksheet and workbook protection Change workbook properties Apply and remove file passwords Track changes (highlight, accept, and reject) Create a shared workbook Merge workbooks