Question: what formulas to use in excel?
Answer: SUM. The SUM function. The function will sum up cells that are supplied as multiple arguments. ... 
AVERAGE. The AVERAGE function. ... 
COUNT. The COUNT function. ... 
COUNTA. Like the COUNT function, COUNTA. ... 
IF. The IF function. ... 
TRIM. The TRIM function. ... 
MAX & MIN. The MAX.