ms excel 6

 

FACT:- TO GET FACTORIAL NUMBER OF ANY NUMBER .

LCM:- TO GET THE LOWEST COMMON NUMBER OF A GROUP OF A NUMBER.

MOD :-TO GET THE  REMAINDER  OF  ANY  DIVISION.

Power :-to raised  a power .

Product:-to multiply all numbers.

Sqrt:-to get the square root of any number.

Defined name :-by this option we can  add the name into the name box.

Formula Auditing:- by this option we can  insert  arrow and also delete it. and show the

Formula  and also check it.

Calculation :by this option we can calculate the value manually or automatically.

DATA  MENU :- GET EXTERNAL DATA :-BY THIS OPTION WE CA N GET EXTERNAL

DATA  FROM ACCESS, TEXT, WEB AND OTHER SERVER.

CONNECTION :-BY THIS OPTION WE CAN REFREASH  ALL CONNECTION ,

SORT & FITLTER :- BY THIS OPTION WE CAN  COPY  THE DATA  WITHOUT FORMULA .

DATA TOOLS:=TEXT TO COLUMN:- BY THIS OPTION WE CAN   DISTRIBUTE THE TEXT  IN TO SEPARATE  COLUMAN ,

REMOVE DUPLICATE :- TO REMOVE OR DELETE DUPLICATE VALUE FROM  THE SHEET.

DATA VALIDATION:- BY THIS OPTION WE CAN PREVANT  TO  INSERT  INVALID DATA  INTO  VALIDATED AREA .

CONSOLIDATE:- TO  SUM  OR  OTHER   FORMULA  INPUT   IN  DIFFERENT  PLACES VALUE.