What is Excel?
- Microsoft excel is a spreadsheet developed by Microsoft.
- It features calculation, graphing tools, pivot tables, and a macro programming language called Visual basic for applications.
- It has been a very widely applied Spreadsheet.
What is a Cell?
- A cell is the intersection between a row and a column on a spread sheet that starts with cell A1.
Formula for Sum
SUM( num 1, [ num 2..] )
Formula for Count
- COUNT ( Range of values ) is used to count number of cells with numbers
- COUNTBLANK ( Range ) is used to count number of blank cells
- COUNTA ( Range ) is used to count all the existing cells
COUNT( Range of values )
COUNTBLANK( Range of values )
COUNTA( Range of values )
Formula for Average
Some other Formulas
