Page 63 - TechPluse_C6_Flipbook
P. 63
5 Formulas, Functions and
Charts in Calc
Your Aim
to learn about:
Formula Basics Order of Operation
Functions Charts in Calc
Sorting Data Filtering Data
Conditional Formatting Printing a Worksheet
In this chapter, you will learn how to create a basic formula in Calc. One of the Calc’s most
useful feature is that it allows users to create formulas in order to perform calculations on data.
Calc also contains built-in formulas called functions that make it easy to perform common
calculations on data.
FORMULA BASICS
Formulas in LibreOffice Calc begin with an equal (=) sign. When the contents of a cell begin with
equal to sign, LibreOffice Calc understands that user has given a formula here. If you don’t enter
the equal sign, Calc will treat your entry as text and the calculation will fail. To show how formulas
work, we'll begin with a simple exercise by selecting blank cell A1.
Then type = 10 + 4, and press Enter key. As you press the Enter key, Calc performs the calculation
and produces the result as 14 in cell A1. Enter some more formula in other cells and see what
results are shown by Calc. For example:
1. =10 – 4 2. =10 * 4 3. =10/4 4. =10 ^ 4
The results will be 6, 40, 2.5 and 10000 respectively. Some formulas based on BEDMAS rule can
be entered as:
1. =(10 + 4) – (3 + 5) ^ 3 2. =(16/8) * (5 ^ 2) – 7
Clickipedia
LibreOffice Calc follows BEDMAS rule for doing mathematical calculations, where B stands
for Brackets, E for Exponentiation, D for Division, M for Multiplication, A for Addition and
S for Subtraction.
Formulas, Functions and Charts in Calc 61

