• IF Function: IF(logical_test, [value_if_true], [value_if_false])

• IFS Function: IFS(logical_test1, value_if_true1, ………..)

• SUM Function: SUM(number1, [number2], ………).

• SUMIF Function: SUMIF(range, criteria, [sum_range])

• SUMIFS Function: SUMIFS(sum_range, criteria_range1, criteria1, ………..)

• OR Function: OR(logical1, [logical2], …….)

• AND Function: AND(logical1, [logical2], …….)

• Subtract Function: Value1-Value2

• Multiply Function: PRODUCT(number1, [number2], ….)

• Division Function: number1/number2

• Percentage Function: (Sum of marks obtained/ Total marks)*100

• Date Function: DATE(year, month, day)

• Datedif Function: DATEDIF(Initial date, Final Date, “d/m/y”)

• Datevalue Function: DATEVALUE(date_text)

• Day Function: DAY(serial_number)

• Days Function: DAYS(end_date, start_date)

• Edate Function: EDATE(start_date, months)

• Month Function: MONTH(serial_number)

• Now Function: NOW()

• Time Function: TIME(hour, minute, second)

• Today Function: TODAY()

• Year Function: YEAR(serial_number)

• Text Function: TEXT(value, format_text)