#3 Ms Excel | Microsoft Office

The following are different method to select a rang of cells .

* Click on a cell and hold down the left mouse button drag the mouse pointer
across different cells and release the mouse button .

* Click on a cell place the mouse pointer on the last of the rang and press
shift key on the keyboard and click on the left mouse button .

* To block non continuous cells . Press ctrl key drag from the center of cells .

* To block the cell or a row . Click on the row number to the lift side of
worksheet .

* To b lock the cell in a column , click on the column header at the top of
the worksheet .

* To select entire worksheet press ctrl + A or click on select alt button . A place above the first row number and before the first column letter [ Top left corner of the worksheet ] .

Select All Button

* Cell References :-
A formula represents certain cell relationship . Which generates a result when typing the cell address in the formula three types of cell references can be used . A cell reference specifies when the formula is copied to other cells . Its column or row number is to change or net .

* Relative Reference :-
If a formula with relative reference is copied the cell reference used in the formula will automatically change in the copied cell .

For example :- When the formula = B3*x3 in cell D3 is copied to D4 the formula will be = B4*C4 in the cell D4 .

Mixed Reference :-
If a formula with mixed reference is copied the cell reference used in the
formula will change either the column letter or row number but not both of
them . To achieve this use symbol before the column letter or the row number

For example :- When the is copied to D4 . It will be = &B&3 * C4 .

Absolute Reference :-
If the formula with absolute reference is copied the cell reference used in the formula remain unchanged ( no change in column or row number ) . To achieve this use symbol before the column letter and row number for example , When the formula = &B&3 * &C&3 in cell D3 is copied .

* FUNCTIONS *

* Function shortens a formula for example to add the values in the cells c1 to c10 the formula is = c1 +c2 +c3+c4+c5+c6+c7+c8+c9+c10.If the function is used we need to type only = sum(c1:c10)

* Complex formula can be create using functions and sum tasks can be accomplished only by using the functions for example to display the current date and time using today()and now () functions.

How many types of functions?

There are five types of functions.

(1) mathematical and statistical function.
(2) Date and time function
(3) Text function
(4) Logical function
(5) Financial function

(1) Mathematical and statistical function:-

Sum ():-
it is a mathematical function used to add the numeric value in a range of cells.