Page 266 - Computer - 9(A&B)

Creating Formulas using Cell Address
To create formulas using cell address, follow the given steps:

Step 1: Click in the desired cell and type = (equal to) sign.

Step 2: Click the cell C5.
Step 3: Now, type * and then click the cell D5.
Step 4: Press the Enter key. The result will appear in cell E5.

Types of Formulas
In Calc, each cell may contain a calculation or a formula. When you enter a formula in a cell, Calc calculates
the result of that formula and displays the result of that calculation to you. Calc uses standard operators for
formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a
forward slash for division (/) and a caret (^) for exponents.
All formulas in Calc must begin with an equal sign (=). There are two types of formulas—Simple and Compound
formulas.

Simple Formulas
Basic formulas involve only one operator in a formula. Here is an example to understand this well.
Suppose you want to calculate the total marks of a student. To enter formula, use the given steps:

Step 1: Click in the cell where you want to display the total. For example, B6.
Step 2: Type the formula = B2 + B3 + B4 + B5.
Step 3: Press the Enter key. The total gets displayed in the cell.

128
128