Monday, February 8, 2016

Praktek TIK kelas VIII Excel 2

Silahkan Donwload file berikut PRAKTEK EXCEL II KELAS VIII
  1. Rangking =RANK(G6;$G$6:$G$15;0)
  2. lulus tidak lulus =IF(H6>=7;"lulus";"tidak lulus") 
  3.  jumlah lulus =COUNTIF(I6:I15;I7)
  4.  Jumlah tidak lulus =COUNTIF(I6:I15;I6)

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)