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