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)