Formulas in Microsoft Excel- explanation.pptx

M S excel formulas-introduction to formulas of ms excel.

1. Formulas in MS Excel By, Ashwini K S Lorven Public School< Chandapura 1

2. introduction Formulas in MS-Excel are written differently from those we write in mathematics. In MS-Excel formulas are written into a cell, to perform mathematical calculations. All formulae start a equal to(=) sign. A formulae can contain the following elements. Lorven Public School< Chandapura 2

3. Using formulas Formulas can be entered in cell or formula bar. Lorven Public School< Chandapura 3

4. Lorven Public School< Chandapura 4

5. Text formulas Process of joining text values in a series is called concatenation. Example : “ Lorven”&” Public “& “ School” This example will join all three 3 words and display as “Lorven Public School” & is used to join the words or text values Lorven Public School< Chandapura 5

6. Lorven Public School< Chandapura 6

7. Lorven Public School< Chandapura 7