Sum Function Sales (Part A)

Accounts
PART A
Answer 1
The three excel functions that I have used and found them useful has been described here-in-
below:
(a) Sum: The tool is one of the most common used function in Microsoft excel used for
adding the rows and column as defined. The tool serve as a calculator and used for
adding number in Microsoft Excel. A sample use of this tool has been detailed here-in-
below
Sample of Sum Function
Sl. No Sales (year wise) Amount
1 2000 10,00,000
2 2001 10,11,000
3 2002 10,22,000
4 2003 10,33,000
5 2004 10,44,000
6 2005 10,55,000
7 2006 10,66,000
8 2007 10,77,000
9 2008 10,88,000
10 2009 10,99,000
11 2010 11,10,000
12 2011 11,21,000
13 2012 11,32,000
14 2013 11,43,000
15 2014 11,54,000
16 2015 11,65,000
17 2016 11,76,000
Sum Total 1,84,96,000
The function is designed in the following manner: SUM ( C1: C17)
Sample of Sum Function
Sl. No Sales (year wise) Amount
1 2000 1000000
=A3+1 =B3+1 =+C3+11000
=A4+1 =B4+1 =+C4+11000
=A5+1 =B5+1 =+C5+11000
=A6+1 =B6+1 =+C6+11000
=A7+1 =B7+1 =+C7+11000
=A8+1 =B8+1 =+C8+11000
=A9+1 =B9+1 =+C9+11000

Sample of Sum Function
Sl. No Sales (year wise) Amount
=A10+1 =B10+1 =+C10+11000
=A11+1 =B11+1 =+C11+11000
=A12+1 =B12+1 =+C12+11000
=A13+1 =B13+1 =+C13+11000
=A14+1 =B14+1 =+C14+11000
=A15+1 =B15+1 =+C15+11000
=A16+1 =B16+1 =+C16+11000
=A17+1 =B17+1 =+C17+11000
=A18+1 =B18+1 =+C18+11000
Sum Total =SUM(C3:C19)
(b) Count Function: This function is one of the significant function in excel used for
counting the elements in Microsoft excel. This tool is used for counting the entries and is
used very often. A sample use of this tool has been detailed here-in-below
Sample of Count Function
Sl. No Sales (year wise) Amount
1 2000 10,00,000
2 2001 10,11,000
3 2002 10,22,000
4 2003 10,33,000
5 2004 10,44,000
6 2005 10,55,000
7 2006 10,66,000
8 2007 10,77,000
9 2008 10,88,000
10 2009 10,99,000
11 2010 11,10,000
12 2011 11,21,000
13 2012 11,32,000
14 2013 11,43,000
15 2014 11,54,000
16 2015 11,65,000
17 2016 11,76,000
Count Total 17
The function is designed in the following manner: Count ( C1: C17)

Sample of Count Function
Sl. No Sales (year wise) Amount
1 2000 1000000
=A3+1 =B3+1 =+C3+11000
=A4+1 =B4+1 =+C4+11000
=A5+1 =B5+1 =+C5+11000
=A6+1 =B6+1 =+C6+11000
=A7+1 =B7+1 =+C7+11000
=A8+1 =B8+1 =+C8+11000
=A9+1 =B9+1 =+C9+11000
=A10+1 =B10+1 =+C10+11000
=A11+1 =B11+1 =+C11+11000
=A12+1 =B12+1 =+C12+11000
=A13+1 =B13+1 =+C13+11000
=A14+1 =B14+1 =+C14+11000
=A15+1 =B15+1 =+C15+11000
=A16+1 =B16+1 =+C16+11000
=A17+1 =B17+1 =+C17+11000
=A18+1 =B18+1 =+C18+11000
Count Total =COUNT(C3:C19)
(c) Average: It is also one of the most widely used tool in excel which is used for the
purpose of computing the average of the given entries. It is used in business for the
purpose of computing average profit of sales during a period of time. A sample use of
this tool has been detailed here-in-below:
Sample of Average Function
Sl. No Sales (year wise) Amount
1 2000 10,00,000
2 2001 10,11,000
3 2002 10,22,000
4 2003 10,33,000
5 2004 10,44,000
6 2005 10,55,000
7 2006 10,66,000
8 2007 10,77,000
9 2008 10,88,000
10 2009 10,99,000
11 2010 11,10,000
12 2011 11,21,000
13 2012 11,32,000
14 2013 11,43,000
15 2014 11,54,000
16 2015 11,65,000