File | Edit | View | Insert | Format | Tools | Data | Window |
SUM
It is mathematical function used to add the numeric value in a range of cells.
Syntax: =SUM (range)
Example=SUM (C5:C10)
AVERAGE
It returns the average (arithmetic mean) of the numeric values in the range of cells.
Syntax: =AVERAGE (range)
Example=AVERAGE (C5:C10)
MAX
It returns the largest value in the range.
Example=MAX (C5:C10)
MIN
It returns the lowest value in the range.
Syntax:=MIN(range)
Example=MIN(C5:C10)
COUNT:
It counts the numbers of cell that contain numbers in the specified range.
Syntax: =COUNT (range)
Example: =COUNT(C5:C10)
COUNTA:
It counts the numbers of cells that are not empty in the specified range.
Syntax: =COUNTA (range)
Example: = COUNT A(C5:C10)
NOW:
It returns the serial numbers of the current date and time.
=NOW()
IF FUNCTION
It checks the condition and returns the answer according to the true or false condition.
==IF(A1>=33,"Pass","Fail")
STRING FUNCTIONS
LEFT
It returns the number of characters from the left side of a text string.
Syntax – =LEFT (String, number)
eg - = LEFT(B1.5)
RIGHT
It returns the number of characters from the right side of a text string.
Syntax – =RIGHT (String, number)
eg - = RIGHT(B1.5)
MID
It returns the number of characters from the specified position of the numbers.
Syntax - =MID (string, start number, number of characters)
Example: =MID (B1, 3, 4) MPUT.
LEN
Returns the length of a text string Space are counted as characters.
Syntax:= LEN(string)
Example: =LEN (B1)
EXAMPLE: =LEN (“NAME”)
PROPER
Converts the fist letter of each word in a text string to upper case and remaining letters to lower case.
Syntax: =PROPER (String)
Example: = PROPER (B1)
=PROPER (“CLEAN ME”)
REPT
Repeats the given text a specified numbers of times.
Syntax: REPT (String, number)
Example: =Rept(“*”,6)
=PROPER (“ME”, 3)
UPPER
Converts all lower case letters in a text strings to upper case.
Syntax: UPPER (String)
Example: =UPPER (B1)
=UPPER (“Clean Me”)
LOWER
Converts all uppercase letters in a text to lowers.
Syntax: LOWER (String)
Example: =LOWER (B1).
=LOWER (“CLEAN ME)
To see time with keyboard
Ctrl + shift + :
To see date with keyboard
Ctrl+;