Page 39 - Plus_V2.2_C6_Flipbook
P. 39
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 follows:
After entering the formula in the cell, press the Enter Formula in cell
key. When the Enter key is pressed, result of the formula
appears in the cell.
Typing the formula in the Formula bar: In this way, we
can type the formula in Formula bar after selecting the
cell as follows: Output
After entering the formula, when we press the Enter key from
the keyboard. The result will appear.
UNDERSTANDING CELL RANGE
A group of selected cells is called a cell range. The selected Formula in Formula bar
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 Shift key.
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 Cell range selected by mouse
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
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.
Step 2: Press and hold the Shift key down from the keyboard and click on the last cell up to which you
want to make selection.
Step 3: Release the Shift key. The range gets selected.
Formulas and Functions in Excel 2016 37

