a. Format cells : Used to setting the place, size, font, aligment of word, size of cell or range.
b. Sum : used to total the number in the range of cell
c. Count Number: used to total the number in the range, of cells
d. Max : used to find the maximum in the range of cells
e. Min : used to find the minimum in the range of cells
f. COUNTIF : used to total number of data which agree with the logically formula’ settings.
g. VLOOKUP : used to read the table vertically
h. HLOOKUP : used to read the table Horizontally
i. MID : used to find text on the cell as from the middle
j. ROUND 0, ROUND 1, ROUND 2 : to make to fraction in data