Page 38 - TP_Pluse_V2.2_Class_6
P. 38
DIFFERENT WAYS TO ENTER A FORMULA
There are mainly two ways to enter a formula in a
worksheet:
Typing the formula directly in the Cell: In this way, the
formula is directly typed in the cell after typing an equal
sign as shown here.
After entering the formula in the cell, press the Enter key.
Formula in cell
When the Enter key is pressed, the result of the formula
appears in the cell.
Typing the formula in the Formula bar: In this way, we can
type the formula in the Formula bar after selecting the cell
Output
as shown here.
After entering the formula, when we press the Enter key
from the keyboard. The result will appear.
UNDERSTANDING CELL RANGE
Formula in Formula bar
A group of selected cells is called a cell range. The selected cells should be in continuation to form
a range. When a range is selected in a worksheet, a rectangular shape is formed. We can use a cell
range to perform a calculation on multiple cells. The address of a range is created by using the starting
and the ending cell addresses separated by a colon (:) sign. For example, if we have selected the cells
from B2 to E3, then the address of the range will be B2:E3.
Selecting a Range in a Worksheet
We can select a range by using the mouse and by using the Keyboard.
By using the Mouse
Perform the following steps to select a range by using the mouse:
Step 1: Click on the first cell from which you want to
start the range.
Step 2: Press and hold the left mouse button and drag
the mouse diagonally to select the desired range.
Step 3: Release the mouse button on the cell up to which
you want to select the range. The range gets Cell range selected by mouse
selected.
By using the Shift Key
Perform the following steps to select a range by using the Shift key:
Step 1: Click on the first cell from which you want to start the range.
36 Plus (Ver. 2.2)-VI

