Chapter 1: Creating a Worksheet and an Embedded Chart
Objectives:You will have mastered the material in this chapter when you can:
- Start and quit Excel
- 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 the fill handle
- Save a workbook
- Format cells in a worksheet
- Create a 3-D Clustered Column chart
- Change document properties
- Save a workbook a second time using the same file name
- Print a worksheet
- Open a workbook
- Use the AutoCalculate area to determine statistics
- Correct errors on a worksheet
- Use Excel Help to answer questions
Chapter 2: Formulas, Functions, Formatting, and Web Queries
Objectives: You will have mastered the material in this chapter when you can:
- 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 3: What-If Analysis, Charting, and Working with Large Worksheets
Objectives: You will have mastered the material in this chapter when you can:
- 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 IF 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
----------------------------------------------------------------------------------------------
Word Lesson 1: Creating and Editing a Word Document
You will have mastered the material for each day when you can:
- Start and quit Word
- Describe the Word Window
- Enter text in a document
- Check spelling as you type
- Save a document
- Format text, paragraphs, and document elements
- Undo and redo commands or actions
- Insert a picture and format it
- Print a document
- Change document properties
- Open a document
- Correct errors in a document
Word Lesson 2: Creating a Research Paper
You will have mastered the material for each day when you can:
- Describe the MLA documentation style for research papers.
- Change line and paragraph spacing in a document
- Use a header to number pages of a document
- Apply formatting using shortcut keys
- Modify paragraph indentation
- Create and modify styles
- Insert and edit citations and their sources
- Add a footnote to a document
- Insert a manual page break
- Create a bibliographical list of sources
- Move text
- Find and replace text
- Use the Research task pane to look up information
Word Lesson 2: Creating a Research Paper
You will have mastered the material for each day when you can:
- 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