Computer Concepts - Function and Charts

---

---

We shall learn how to use functions and charts in Microsoft Excel −

Using Formulas

You can use formulas to perform basic mathematical calculations, such as addition, subtraction, multiplication, and division of numbers. The following examples demonstrate how to use formulas to carry out mathematical calculations.

Addition

Addition helps to add two or more values. By using "= SUM(cell1+cell2)" formula, we can calculate the sum of values.

Examples

• Open a new worksheet.

• Move the cursor to cell A1.

• Write one value in cell A1 and another value in cell B1.

• Write "= SUM(A1 + B1)" in cell C1 which will automatically get displayed in formula bar.

• Press Enter.

• Note that cell A1 has been added to cell B1 and the result is shown in cell C1.

Subtraction

Subtraction helps to subtract two or more values. By using "= SUM(cell1 - cell2)" formula, we can calculate the difference between the values of cell 1 and cell 2.

Example

• Open a new worksheet.

• Move the cursor to cell A1.

• Write one value in cell A1 and another value in cell B1.

• Write "= SUM(A1 - B1)" in cell C1 which will automatically get displayed in the formula bar.

• Press Enter.

• Note that cell B1 has been subtracted from cell A1 and the result is shown in cell C1.

Multiplication

Multiplication helps to multiply two or more values. By using "= SUM(cell1 * cell2)" formula, we can calculate multiplication

Examples

• Open a new worksheet.

• Move the cursor to cell A1.

• Write one value in cell A1 and another value in cell B1.

• Write "= SUM (A1 * B1)" in cell C1 which will automatically get displayed in the formula bar.

• Press Enter.

• Note that cell A1 has been multiplied to cell B1 and the result is shown in cell C1.

Division

• Division helps to divide one value by another value.

• By using "= SUM(cell1 / cell2)", formula we can perform division.

Examples

• Open a new worksheet.

• Move the cursor to cell A1.

• Write one value in A1 and another value in B1.

• Write "= SUM(A1 / B1)" in cell C1 which will automatically get displayed in the formula bar.

• Press Enter.

• Note that cell A1 is divided by cell B1 and the result is shown in cell C1.

Function

• Microsoft Excel has a set of prewritten functions to perform a specific task.

• When using a function, remember the following steps −

• Use an equal ( = ) sign to begin a function.

• Specify the function name.

• Enclose arguments within parenthesis.

• Use a comma to separate arguments.

• Here is an example of a function, = POWER(number,power) or = POWER(cell1,cell2)