Know 5 Useful Terms In MS Excel - 1 (Cell, Active Cell, Cell Reference, Input Cell, Merged Cell)

My intention is very clear by starting Know 5 Useful Terms in MS Excel series that everyone should know the meanings of Important Excel terms.

I will try my level best to give you at least one post in this series, in every month. So that by next year you will be in a position to learn 60 Excel Important terms (not only meaning but also some interesting things)

So, lets opening the door for Know 5 Useful Terms In MS Excel series...!!!!

The 5 important terms in this article are

SUM Formula in Excel - (SUM Series)

This article is part of SUM series. Know more about SUM series here.

In this SUM formula series, the first and important formula is SUM. All other SUM related formulas are derived from SUM formula only.

SUM is one of the basic function in MS Excel. May be basic, but more important in all the calculations.

What is SUM?

SUM is mathematical word. SUM means an amount or value obtained as a result of adding one or more numbers.

Relative Reference Vs Absolute Reference In MS Excel

Use Dollar Symbol..
Use Dollar Symbol..
You may not know about Relative Reference and Absolute Reference in Excel but you might heard that "using dollar ($) symbol in excel..". The name of using dollar ($) symbol in reference is nothing but Relative Reference and Absolute Reference.


What is Cell Reference ?


A Cell Reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Excel can find the values or data that you want that formula to calculate.