BÀI 4CƠ HỘI LẤY BẰNG ĐẠI HỌC QUỐC TẾCÔNG NGHỆ THÔNG TINBACHELOR OF SCI...
4
-15.42
40
36
5
6
=SQRT(A1)
=ROUND(A3,2)
=COUNT(B1:B4)
7
=SQRT(A2)
=ROUND(A3,-1)
=COUNT(C1:C4)
8
=SQRT(16)
=ROUND(A3,-3)
=COUNTA(B1:B4)
9
=IF(A2>=0,SQRT(A2),"Lỗi") =ROUND(A4,1)
=COUNTA(C1:C4)
10
=INT(A1/7)
=ROUND(A4,-1)
=COUNTBLANK(C1:C4)
11
=MOD(A1,7)
=SUM(B1:B4)
=COUNTIF(B1:B4,">=25")
12
=INT(A3)
=MAX(B1:B4)
=COUNTIF(B1:B4,"<33")
13
=INT(A4)
=MIN(B1:B4)
=RANK(B1,B1:B4,0)
14
=ODD(A3)
=AVERAGE(B1:B4)
=RANK(B1,$B$1:$B$4,0)
15
=ODD(A4)
=PRODUCT(B1:B4)
=RANK(B1,$B$1:$B$4)
16
=ODD(16.2)
=SUMIF(B1:B4,">=25",B1:B4) =RANK(B2,$B$1:$B$4)
17
=SUMIF(B1:B4,">=25")
=RANK(B1,$B$1:$B$4,1)