Page 31 - Touchpad_Plus_V3.2_Class 7
P. 31
Restart
LibreOffice Calc allows users to create custom formulas to perform calculations on their
data.
Formulas in LibreOffice Calc begin with an equal sign.
When performing calculations using a formula, Calc follows certain rules of precedence.
Calc also contains built-in formulas called functions that make it easy to perform common
calculations on data.
Charts make it easier to draw comparisons, analyse growth and relationship among the
values.
Checkpoint
A. Tick ( ) the correct option.
1. Which of the following cell references can be included in absolute reference?
a. K13 b. $K$13
c. K$13 d. $K13
2. Which one of these functions is used to calculate the average of a range of values?
a. AVERAGE ( ) b. SUM ( )
c. AVG ( ) d. None of these
3. The cell address in the formula is known as .......................
a. Range b. Cell reference
c. Mixed reference d. Average
4. Which of the following functions is used to find remainder after dividing two numbers?
a. LEN() b. MOD()
c. CONCATENATE() d. MAX()
5. In the ...................... chart, bars are placed horizontally.
a. Bar b. Column
c. Area d. Line
6. Function name must be followed by opening and closing .......................
a. Parenthesis b. Curly Brackets
c. Angular Brackets d. Square Brackets
Formulas, Functions and Charts in Calc 29

