Page 70 - Full Handbook ICT
P. 70

Microsoft Office Excel

            5.ບຸຉຝຶກຣັຉ


























                    H9=G9+F9+E9+D9+C9

                    I9=H9/5

                    J9=IF(I9>=5,"ເຆ ຄໄຉົ້", IF(I9<5,"ເຆ ຄຊົກ"))
                    K9=RANK(I9,$I$9:$I11)

                    H12=MAX(H9:H11)

                    H13=MIN(H9:H11)
                    H14=COUNTIF(E9:E11,"<=6")

                    H15=COUNTIF(F9:F11,"<5")


















                                                             61                                   by Lakhonekham Choumphachane
   65   66   67   68   69   70   71   72   73   74   75