How to use basic functions in LibreOffice Calc

https://youtu.be/WKxnmxhzIrE
The sum, average, max and min functions are some of the most commonly used functions in LibreOffice Calc. They allow you to perform basic calculations on a range of cells. Here is how to use them:

– To use the sum function, which adds up all the numbers in a range, type =SUM(range) in a cell, where range is the cell reference of the range you want to sum. For example, =SUM(A1:A10) will add up all the numbers in cells A1 to A10 and display the result in the current cell.
– To use the average function, which calculates the mean of all the numbers in a range, type =AVERAGE(range) in a cell, where range is the cell reference of the range you want to average. For example, =AVERAGE(B1:B10) will calculate the mean of all the numbers in cells B1 to B10 and display the result in the current cell.
– To use the max function, which finds the largest number in a range, type =MAX(range) in a cell, where range is the cell reference of the range you want to find the maximum of. For example, =MAX(C1:C10) will find the largest number in cells C1 to C10 and display it in the current cell.
– To use the min function, which finds the smallest number in a range, type =MIN(range) in a cell, where range is the cell reference of the range you want to find the minimum of. For example, =MIN(D1:D10) will find the smallest number in cells D1 to D10 and display it in the current cell.

You can also use these functions with more than one range as arguments. For example, =SUM(A1:A10,B1:B10) will add up all the numbers in cells A1 to A10 and B1 to B10 and display the result in the current cell.

For more information on how to use these functions, you can refer to this link: https://help.libreoffice.org/latest/en-US/text/scalc/02/06030000.html?DbPAR=CALC

Join this channel to get access to perks:
https://www.youtube.com/channel/UC1c7NBQ7tjBhPGegvCXid_A/join

If you want to support me, check this out: https://www.patreon.com/itseasy

Online training courses:

https://itseasytraining.teachable.com/
https://www.udemy.com/course/microsoft-excel-intermediate-course-z/?referralCode=365DF21869A9F9D2BFCB
Playlists for this channel:

Access: https://www.youtube.com/watch?v=WyFj2eeMfSI&list=PLK99llucAWls71sYcwuXUGuTB33Iz4sFP&ab_channel=ITsEasyTraining1st

Excel: https://www.youtube.com/watch?v=yKobsDbGbyM&list=PLK99llucAWlt5BjHVQwlzFWcqtOR0xMsc&ab_channel=ITsEasyTraining1st

Word: https://www.youtube.com/watch?v=1yB2yP_5LQ0&list=PLK99llucAWlvAvYnQHbuqPzahwXC2GP5T&ab_channel=ITsEasyTraining1st

Visio: https://www.youtube.com/watch?v=ucHD0C4xeBY&list=PLK99llucAWlubxRVLca37R6Jh4jSZyxC3&ab_channel=ITsEasyTraining1st

Project: https://www.youtube.com/watch?v=5Fmgei_PagI&list=PLK99llucAWltWM3-Ohg_V1d6Q0STPAzG7&ab_channel=ITsEasyTraining1st

PowerPoint: https://www.youtube.com/watch?v=fOhiNLAzVAQ&list=PLK99llucAWluWCI4_xLnfbjm5GpAZo9Ye&ab_channel=ITsEasyTraining1st

Publisher: https://www.youtube.com/watch?v=I1-DPJTSvg4&list=PLK99llucAWlvCyOwrQh-OSlPpXWBIEVYq&ab_channel=ITsEasyTraining1st

OneNote: https://www.youtube.com/watch?v=JS5Y_BSEbgg&list=PLK99llucAWlteO7uOpQHz5rOBCdnZ0YMD&ab_channel=ITsEasyTraining1st

Office 365: https://www.youtube.com/watch?v=fphQ0jmv0-8&list=PLK99llucAWlv0L0K0wsLW_S5VkOHFuxli&ab_channel=ITsEasyTraining1st

#itseasytraining

Classroom based courses can be arranged at https://www.itseasy.co.uk/

Courses are available through Microsoft Teams, Online and Face to face in the UK

Online courses at https://itseasytraining.teachable.com/

Udemy Courses https://www.udemy.com/user/stephen-saxton/

Training Guide Books

Excel for New Managers

Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Project-Overview-need-about/dp/1705474632

Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Visio-Basics-Stephen-Saxton/dp/B089CSJBMD

Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv

---