MICROSOFT EXCEL TUTORIAL - BASIC FORMULA

BASIC FORMULA

MICROSOFT EXCEL TUTORIAL-BASIC FORMULA

Microsoft Excel is an electronic spreadsheet that robotizes manual estimations related with accounting and bookkeeping. After you have formed the crucial substance and number entries in a spreadsheet cell, Excel can play out the math figuring for you. You will make sense of how to make plans and abilities to perform calculations in a spreadsheet.

MATHEMATICAL OPERATORS

By using the below mathematical operators you can create any type of math calculations.

Symbols	Meaning
=	Every calculation in excel is begin with “=” symbol
+	Addition
-	Subtraction
*	Multiplication
/	Division
^	Exponentiation
%	Percentage
(	Used to begin a grouping calculation
)	Used to close a grouping calculation

BASIC STEPS FOR CREATING FORMULA

Step 1:- Type an equal sign on an empty cell which will contain formula.

Step 2 :-  Then type the cell address or click on the cell which contain the first number.

Step 3:- Type any mathematical operator (+, -, *, /, ^, %) as per your requirement.

Step 4:- After that select the second number or continue the above process to calculate more number.

Step 5:- Press Enter key to execute the formula.

Now we are describing addition formula briefly

Steps to enter:-

a) Select cell when you want to calculate.

b) Type equal(=) symbol (the Excel know that you want to enter a formula).

c) For example, write the formula B1+B2

Tips:- You can simply select B1 and cell B2 instead of typing.

i) Change cell value B1 to 25.

 Excel automatically recalculates the value of B3. It is a powerful feature of Excel.

ii) Edit a formula:- When you select a cell where the calculation result show. You can see the result value in cell B3 and the formula show in the Formula Bar.

To edit a formula take the mouse pointer to the formula bar and click on it to change the formula (change addition to substraction).

Press Enter key.

iii) Operator using Parenthesis:-

Excel always use default method which calculations are done. If we input parenthesis in a part of formula. That part will be calculate first then excel calculate the rest of formula through its reminder. See the example given below.

Use formula without parenthesis

Use formula with parenthesis

Copy/ Paste Formula:-

The cell address is automatically adjust when you copy a formula from existing cell to a new cell. Now it’s more easier to understand with appropriate formula below.

1. Select cell B4 by right click on the cell and select copy option or press Ctrl + C.

2. Next select cell C4 and right click on it then select paste option or press Ctrl + V.

3. You can also drag the formula from B4 to C4. Go to the lower right corner of the cell then drag it to the new cell.

The formula in the cell C4 references the values in column C.

The rest mathematical operators given in the table is used by the above process.

CELL ADDRESS: - Alphabets show column address and numbers or numeric shows row address. E.g. B2 (B is column address and 2 is row address).

If you want to add more than two cells then follow the picture given below.

You can add numbers by the above process “=A1+A2+A3+A4+A5+A6+A7”. But this is a lengthy process for a user to calculate more numbers. The easier way to add more numbers is shown in the below picture.

Syntax: =sum(A1:A7) A1 is the starting cell address and A7 is the ending cell address of your calculation range. Enter this symbol (:) in between the cell address.

AUTOSUM:-

It is the very easier process to calculate more numbers in less time. Simply select all numbers which are added then click on the AutoSum option present in the Editing Group in the HOME ribbon. Then the result is shown in the below cell.

OR

Click on the AutoSum button present in the FORMULA ribbon.