Use of LibreOffice for an office automation environment

U13 - Calc - Formulas and Functions

• Learning outcomes

  After the completion of the unit the students will be able to:

  • Create formulas using arithmetic operators and cell references
  • Describe function syntax
  • Employ function wizard to insert functions in formulas
  • Clarify the difference between relative and absolute cell reference
  • Combine formulas and functions to create simple spreadsheet applications
• Formulas Page
• Functions Page
• Formulas and Functions sample file
• Basic Functions Page
• Monthly budget calculator Assignment
• Business Invoice Assignment
• IF Function Page
• Relative and Absolute Reference Page
• Teacher's Gradebook Assignment
• Formulas and Functions Quiz
• U13 Self-evaluation Checklist
• Resources

• Online Calc Functions Reference URL