Page 53 - Computer Class 07

4 4 4 Formulas and FunctionsFormulas and FunctionsFormulas and Functions

in Spreadsheetsin Spreadsheets
in Spreadsheets

Complete these following algebraic formula. You can take help of your teacher.

2
1. (a + b) =
2
2. (a – b) =
2
2
3. a – b =
2
2
4. a + b =
3
3
5. a + b =
2
6. (a+b+c) =
4
4
7. a + b =
Excel has its immense purposeful applications. 95% of the users apply the basic form.
There are functions and advanced Excel formula that can be used for complex

calculations. The functions are designed for easy lookup and formatting of large pool
of data whereas the advanced Excel formula are implemented to get new information
from a given particular set of data.

Formula must begin with = symbol followed by cell references and operator. It may
contain anyone or more of the following elements.

References : The cell or range of cells that you want to use in your calculation.

Operators : Symbols (+, –, ×, ÷, $, # etc.) that specify the calculation to be
performed.

Constants : Numbers or text values that do not change.
Functions : Predefined formulas in Excel.

Elements of Formulas in Excel
Cell Address

=
+
A2 B2 + C4 – SUM (E3:E5)
Equal to Symbol Mathematical Operators Function

Computer-7 53