If several languages coalesce the grammar
3 min ago
It will seem like simplified English.
1 hours ago
As a skeptical Cambridge friend of mine occidental.
ROLL NAME PHY CHE MATH TOTAL PER AVG MAX MIN COUNT COUNTA COUNTBLANK 1 RAJ 90 78 65 2 RAJ 78 90 87 3 MOHAN 56 78 89 Mathematical and Statistical FunctionSum (): -It is a mathematical function which is used to add numeric value of a range of cells. Syntax: - =sum(Range of cells) Ex: - =sum(c2:e2) Percentage: -It calculates the percentage values of a range of cells. Syntax: - =total cell address*Full marks/total marks Ex: - =F2*100/300 Average (): -It calculates the average value of a numeric range of cells. Syntax: - =Average(Range of cells) Ex: - =Average(c2:e2) Maximum: -It returns the largest value in the range of cells. Syntax: - =Max(Range of cells) Ex: - =Max(c2:e2) Minimum: -It returns the lowest value in the range of cells. Syntax: - =Min(Range of cells) Ex: - =Min(c2:e2) Count: -It counts the number of cells which shows numeric value only. Syntax: - =Count(Range of cells) Ex: - =Count(a1:f10) Counta: -It counts the numbers of cells that are not empty in the specified range. Syntax: - =Counta(Range of cells) Ex: - =Counta(a1:f10) Countblank: -It counts the empty cells in a specified range of cells. Syntax: - =Countblank(Range of cells) Ex: - =Countblank(a1:d10)
ROLL
NAME
PHY
CHE
MATH
TOTAL
PER
AVG
MAX
MIN
COUNT
COUNTA
COUNTBLANK
1
RAJ
90
78
65
2
87
3
MOHAN
56
89
Mathematical and Statistical Function
Sum (): -It is a mathematical function which is used to add numeric value of a range of cells.
Syntax: - =sum(Range of cells)
Ex: - =sum(c2:e2)
Percentage: -It calculates the percentage values of a range of cells.
Syntax: - =total cell address*Full marks/total marks
Ex: - =F2*100/300
Average (): -It calculates the average value of a numeric range of cells.
Syntax: - =Average(Range of cells)
Ex: - =Average(c2:e2)
Maximum: -It returns the largest value in the range of cells.
Syntax: - =Max(Range of cells)
Ex: - =Max(c2:e2)
Minimum: -It returns the lowest value in the range of cells.
Syntax: - =Min(Range of cells)
Ex: - =Min(c2:e2)
Count: -It counts the number of cells which shows numeric value only.
Syntax: - =Count(Range of cells)
Ex: - =Count(a1:f10)
Counta: -It counts the numbers of cells that are not empty in the specified range.
Syntax: - =Counta(Range of cells)
Ex: - =Counta(a1:f10)
Countblank: -It counts the empty cells in a specified range of cells.
Syntax: - =Countblank(Range of cells)
Ex: - =Countblank(a1:d10)