Posts

Important Formulas

=SUM(C1:H1) =MAX(C1:H1) =MIN(C1:H1) =COUNT(C1:H1) =AVERAGE(C1:H1) =ROUND((A1*0.50),0) =AVERAGE(C1:H1) =A1+B1+C1 =A1/6 =A1-H1 =A1*B1 =(A1+B1)*0.50   =RANK(C5,$C$5:$C$10,0) à Descending =RANK(C5,$C$5:$C$10,1) à Ascending =IF(C1>=40,”PASS”,”FAIL”) =IF(MIN(C1:H1)>=40,”PASS”,”FAIL”) =COUNTIF(C1:H1,”>50”) =COUNTIF(C1:H1,”male”) =VLOOKUP(K1,A1:K10,4,0) =SUMIF(A1:C12,B15,C1:C12)  

MS-EXCEL SHORTCUT

  SHORTCUT MS-EXCEL Ctrl+A Select all contents of the worksheet. Ctrl+B Bold highlighted selection. Ctrl+C Copy   the cell Ctrl+D Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press  Ctrl+Shift+Down  to select multiple cells. Then press  Ctrl+D  to fill them with the contents of the original cell. Ctrl+E Ctrl+F Find Ctrl+G Goto Ctrl+H Replace Ctrl+I Italic highlighted selection. Ctrl+J To enter the line break character Ctrl+K Insert link. Ctrl+L Create a table Ctrl+M to activate a "Move" function Ctrl+N Create a new work book Ctrl+O Open a excel