Miss Kallas' Page
Objectives

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


;