5 Basic Excel Formula for useful

1. Max Function :-

The Excel MAX function returns the largest value from a cell range of numeric values.

Syntax :- =MAX(Cell Range) Enter

Example :- =MAX(F4:F11) Enter 

2.The Excel MIN function returns the smallest value from a Cell Range  of numeric values.

Syntax :- = MIN(Cell Range) Enter

Example :- =MIN( F4:F11) Enter

3.The Excel AVERAGE function returns the  Average value from a Cell Range  of numeric values.

Syntax :- = AVERAGE(Cell Range) Enter

Example :- =AVERAGE( F4:F11) Enter

4.The Excel Time function returns the from  System time in Cell Range shortcut function.

It is  worksheet function, TIME can be entered as part of a formula in a cell range of a worksheet.

  CRTR+SHIFT+COLUMN BUTTON

For Syntax  :-  =TIME(HOURS,MINUTE,SECOND) ENTER

Example  =TIME(K8,L8,M8) Enter

5..The Excel Date function returns the from  System Date in Cell Range shortcut function.

It is  worksheet function, Date can be entered as part of a formula in a cell range of a worksheet.

Syntex :-DATE(YEAR,MONTH,DAY) ENTER

Example :- DATA(J8,K8,L8) ENTER