1/18/11

My Basic Excel Function Exercise

Today I want to share my basic excel function exercise.
Target function: SUM, AVERAGE, COUNT, MAX and MIN.

Function script:
=SUM(number1;[number2];...)
=AVERAGE(number1;[number2];...)
=COUNT(value1;[value2];...)
=MAX(number1;[number2];...)
=MIN( number1;[number2];...)

excel exercise basic


Manual cell fill:
B12  :    =SUM(b2:b11)

B13  :    =COUNT(b2:b11)
B14  :    =AVERAGE(b2:b11)
B15  :    =MAX(b2:b11)
B16  :    =MIN(b2:b11)


Result:


excel exercise function sum average count max min

No comments:

Post a Comment