More advanced calculations can often be performed using one of the pre-defined, built-in functions in Excel. You will find that a there are a number of built-in functions within Excel that perform quite a range of calculations.
We would like to calculate the sum of the numbers in column A and column B using the "SUM" function in Excel. You insert a function into a cell by selecting a cell and clicking the function button, which is found right above the column letters Once you click on the function button, the "Insert Function" window appears. You can search for the function you want to use, or you can select from the various categories of functions that are available. We searched for the word "SUM. Select the SUM functions from the "Insert Function" window. The "Function Arguments" window is more commonly known as the function wizard. The function wizard (1) allows you to enter or select the inputs, (called arguments) for the function, (2) provides a description of the function and each argument, and (3) lists the function result based on the inputs you enter. The arguments of the "SUM" function are the set of numbers you want to add together. We want to add the numbers stored in the range A1:A7. When you click "OK," the SUM function will be inserted into cell A8
Basic Statistical Functions
In addition to the SUM function, we will examine other basic statistical functions:
COUNT(value1, [value2], . . . ) – counts the number of cells in a range of cells that contain numbers COUNTA(value1, [value2], . . . ) – counts the number of cells in a range of cells that are not blank AVERAGE(number1, [number2], . . . ) – calculates the simple average of a set of numbers MAX(number1, [number2], . . . ) – returns the largest value in a set of numbers MIN(number1, [number2], . . . ) – returns the smallest value in a set of numbers 
3.2 Summary Statistics Functions
