lmayer@elgin.edu

Formulas and Functions

Tutorial 2 Objectives:

After completing Tutorial 2, students will be able to:

  • Use formulas to calculate values
  • Use predefined Excel functions
  • Copy and Paste Formulas
  • Work with Relative and Absolute References
  • Use the Fill Function
  • Explain how Excel stores and works with dates
  • Use financial functions
  • Work with logical functions
  • Use Order of Precedence correctly

Click Here for key terms.

Click here for presentation.

Homework: Case Problem 1 page EX 87

 

Previous Lecture           Next Lecture