To select the items for calculation. Type the equation you want to calculate. For example to add up 5 and 7 you type 57 Press the Enter key to complete your calculation.
So like this we can use built-in formulas to work with large data set.
Do the same for the 2nd half. In Excel 2007 click Office button Excel options Formulas Iteration area. Type the equation you want to calculate. We just have to add the formula it will averagejan feb mar apr may jun.