Compare the specialized and statistical functions in excel

Specialized functions are functions that require a range argument to specify the range of values to evaluate and a criteria argument that specifies the condition for the range. Statistical functions apply a mathematical process to a group of cells in a worksheet. W hen you use this function, you can highlight all the cells that contain values you wish to sum in just one step.