write some common excel formulas which is used in daily basis
Answers
Explanation:
Top 10 Most Useful Excel Formulas
SUM, COUNT, AVERAGE. SUM allows you to sum any number of columns or rows by selecting them or typing them in, for example, =SUM(A1:A8) would sum all values in between A1 and A8 and so on. ...
IF STATEMENTS.
SUMIF, COUNTIF, AVERAGEIF.
VLOOKUP. ...
CONCATENATE. ...
MAX & MIN. ...
AND. ...
PROPER.
Seven Basic Excel Formulas
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.
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