For example look up an employees last name by her employee number or find her phone number by looking up her last name just like a telephone book. Just type SUM into a cell then drag the mouse down the column of cells you want to add. In this image the sum function for the cells C2 through C7 is obtained through the formula SUMC2C7 giving you the result of 33161.
Functions perform specific calculations in a particular order based on the specified values called arguments or parameters.
Use this function when you need to find things in a table or a range by row. This example IF formula is checking if B14 cell values is greater than 2000 or not it is printing as Fine as the cell value 2000 is not greater than 2000. In this image the sum function for the cells C2 through C7 is obtained through the formula SUMC2C7 giving you the result of 33161. Heres an example of featuring Excel in the skills section of your resume.