Skip to main content
Side panel
elearn.ellak.gr
English (en)
English (en)
Ελληνικά (el)
You are currently using guest access (
Log in
)
LibreOffice
U01 - Intro to LibreOffice
U02 - Writer - Introduction
U03 - Writer - Text Formatting
U04 - Writer - Graphics and Tables
U05 - Writer - Page formatting
U06 - Writer - Some Other Tools
U07 - Writer - Working with Styles
U08 - Writer - Templates - Math
U09 - Impress 1 (Basics)
U10 - Impress 2 (Advanced)
U11 - Draw
U12 - Calc - Basics
U13 - Calc - Formulas and Functions
U14 - Calc - Working with Data
U15 - Calc Advanced & Mail Merge
U16 - Base
Home
Calendar
Use of LibreOffice for an office automation environment
Home
Courses
Open Courses in English
Digital Skills Courses
LibreOffice
U13 - Calc - Formulas and Functions
General
Announcements
Forum
Intro to the Course
File
Prior knowledge survey
Feedback
Glossary
Forum
Resources
LibreOffice Getting Started Guide
URL
LibreOffice.org main website
URL
LibreOffice Documentation
URL
◄
U12 - Calc - Basics
U14 - Calc - Working with Data
►
U13 - Calc - Formulas and Functions
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
◄
U12 - Calc - Basics
U14 - Calc - Working with Data
►
Jump to...
Main course page
U01 - Intro to LibreOffice
U02 - Writer - Introduction
U03 - Writer - Text Formatting
U04 - Writer - Graphics and Tables
U05 - Writer - Page formatting
U06 - Writer - Some Other Tools
U07 - Writer - Working with Styles
U08 - Writer - Templates - Math
U09 - Impress 1 (Basics)
U10 - Impress 2 (Advanced)
U11 - Draw
U12 - Calc - Basics
U14 - Calc - Working with Data
U15 - Calc Advanced & Mail Merge
U16 - Base