Formulas Of MS Excel

Views:
 
Category: Education
     
 

Presentation Description

PPT Presentation in ms office

Comments

Presentation Transcript

Formulas Of MS Excel:

F ormulas O f MS E xcel Presented by :- Surender Singh

Ms Excel:-:

Ms Excel:- Ms Excel is a software. It is a calculating program. It is a main part of Ms Office Package. We can use many types of calculation in it. It is used in many places like hospitals, hotels, school and companies etc. There are 1048576 rows and 16384 columns in sheet of Ms Excel 2007.

To open the Ms Excel:-:

To open the Ms Excel:- 1 2 3 4

Sheet of Ms Excel:-:

Sheet of Ms Excel:- Office button Tabs Quick Access Toolbar Formula Bar Title Bar Columns Rows Sheet tabs

To open formulas in Ms Excel:-:

T o open formulas in Ms Excel:- Click on the formula tab in Ms Excel sheet

Formulas:-:

Auto Sum Formulas:- F ormulas:- Recently Used Formulas:-

Formulas:-:

Financial Formulas:- Formulas:- Logical Formulas:-

Formulas:-:

Text Formulas:- Formulas:- Date & Time Formulas:-

Formulas:-:

Lookup & Reference Formulas:- Formulas:- Maths & Trigonometry Formulas:-

Formulas:-:

Statistical Formulas:- Formulas:- Engineering Formulas:-

Formulas:-:

Cubical Formulas:- Formulas:- Informational Formulas:-

Formulas:-:

Trace Precedents:- Formulas:- Trace Dependents:-

Formulas:-:

Remove Arrows:- Formulas:-

How to use formulas?:

Sum:- H ow to use formulas? Count Number

How to use formulas?:

Maximum:- How to use formulas? Minimum:-

For help in formulas:-:

F or help in formulas:- 1 2 3 Click For Getting Help Type Word To Search Search Excel Help

To Save The Excel Account:-:

T o Save The Excel Account:- 1 Click To The Office Button 2 Click To The Save Button

To Save The Excel Account:-:

To Save The Excel Account:- 1 Type The File Name 2 Click To The Save Button

To Close The Excel Account:- :

T o Close The Excel Account:- Click To Close The File

The End:

T he End

authorStream Live Help