Course: Use of LibreOffice for an office automation environment , Topic: U13 - Calc - Formulas and Functions

Topic outline

General
- Forum
  
  Announcements Forum
- File
  
  Intro to the Course File
- Feedback
  
  Prior knowledge survey Feedback
- Glossary
  
  Glossary
- Forum
  
  Forum
- Resources
- URL
  
  LibreOffice Getting Started Guide URL
- URL
  
  LibreOffice.org main website URL
- URL
  
  LibreOffice Documentation URL

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
- Page
  
  Formulas Page
  
  View
- Page
  
  Functions Page
  
  View
- File
  
  Formulas and Functions sample file
- Page
  
  Basic Functions Page
  
  View
- Assignment
  
  Monthly budget calculator Assignment
  
  View Make a submission Receive a grade
- Assignment
  
  Business Invoice Assignment
  
  View Make a submission Receive a grade
- Page
  
  IF Function Page
  
  View
- Page
  
  Relative and Absolute Reference Page
  
  View
- Assignment
  
  Teacher's Gradebook Assignment
  
  View Make a submission Receive a grade
- Quiz
  
  Formulas and Functions Quiz
  
  View Receive a grade Receive a passing grade
- Checklist
  
  U13 Self-evaluation Checklist
- Resources
- URL
  
  Online Calc Functions Reference URL