Page 51 - COMPUTER

➢ Count (Value1,Value2..) :- It Returns The Number Of Cells That Contain Number
In The Range

Example :- = Count ( C5:C10)

=Count (A2,A5,A7)

➢ Counta(Value1,Value2..):- It Counts The Number Of Cells That Are Not Empty In
The Range
Example :- =Counta(C5:C10)
=Counta(A2,A5,A7)

➢ Countblank(Range) :- It Count Empty Cells In The Range
Example :- = Countblank(C5:C10)

=Countblank(A2,A5,A7)

➢ Fact (Range) :- It Returns The Factorial Of A Number
=Fact (5) 5x4x3x2x1=120
=Fact(F2)
F2= 6

➢ Mod (Number, Divisor) :- It Returns The Reminder After Dividing
Example :- = Mod(21,2)
= Mod(B2,C2)
B2=15
C2=5
➢ Product (Range):- It Returns The Product/Multiplication Of The Given Range.
Example :- = Product (B2:B7)
=Product (B2,B4,B6)
➢ Sqrt (Number) :- It Returns The Square Root Of The Number .
Example :- = Sqrt (25)
= Sqrt(49)

 TEXT FUNCTION 

➢ Left (String,Number):- It Returns The Specific Number Of Character From The Left Side
Of A Text String.
Example :- =Left(“Aarohan”,4)

=Left(D5,3)

D5= Furkan

50