Page 233 - IT_Play_V1.0 Class9
P. 233
Examples of Basic Formulas
Operator Formula Result
Addition (+) = 15 + 7 22
Subtraction (-) = 30 - 12 18
Multiplication (×) = 8 × 7 56
Division (/) = 84 / 12 7
Exponentiation (^) = 3 ^ 4 81
Using Brackets in Formulas
Brackets can change the order of operations in an equation. The following examples show how brackets
affect the results:
Formula Evaluation Result
= 6 + 8 × 2 = 6 + 16 22
= (6 + 8) × 2 = 14 × 2 28
= 7 * 3 ^ 2 = 7 × 9 63
= (7 × 3) ^ 2 = 21 ^ 2 441
= (12 / 3) ^ 2 = 4 ^ 2 16
= 25 / (5 ^ 2) = 25 / 25 1
Types of functions include Mathematical, Date and Time, Statistical, and Logical functions.
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
Skills
Complete the following and tick the circle.
Start LibreOffice Calc and enter the following data in the cells as given:
Add another column after ‘Quantity’ and give the heading as ‘Price per Piece’ and
fill the required data in it.
Delete the content of 7th row.
Copy the whole content and paste it in ‘Sheet2’ of the spreadsheet.
Delete the 4th row of the given sheet.
Undo the previous work.
‘Redo’ the action taken by the ‘Undo’ command.
Save the file and exit from ‘LibreOffice Calc'.
Applying Formula and Functions in Spreadsheet 231

