- Computer Concepts Tutorial
- Computer Concepts - Home
- Introduction to Computer
- Introduction to GUI based OS
- Elements of Word Processing
- Spread Sheet
- Introduction to Internet, WWW, Browsers
- Communication & Collaboration
- Application of Presentations
- Application of Digital Financial Services
- Computer Concepts Resources
- Computer Concepts - Quick Guide
- Computer Concepts - Useful Resources
- Computer Concepts - Discussion

# 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)