你可能感兴趣的试题
Thread-0 Thread-1 Thread-0 Thread-1
Thread-1 Thread-0
MAX(A1:A5)=10 MAX(A1:A5,30)=30 MAX(A1:A5,30)=3 MAX(A1:A5,25)=25
A1的值为100,A2:A5的值不变 A1:A5单元格的值均为100 A1:A5单元格的值为100至104的递增数列 A1的值为100,A2:A5的值为空
MAX(A1:A5) 等于 10 MAX(A1:A5,30) 等于 30 MAX(A1:A5,30) 等于 27 MAX(A1:A5,25) 等于 25
Thread-0 Thread-1 Thread-0 Thread-1 Thread-1 Thread-0
A675>A312>A13>A10>A5; A675>A312>A13>A5>A10; A675>A13>A10>A312>A5; A675>A13>A312>A10>A5; A13>A312>A675>A10>A5。
=SUM(A2:A5) =SUMIF(A2:A5,800,B2:B5) =COUNTIF(A2:A5,800) =SUM(B2:B5,800,A2:A5)
A1的值为100,A2:A5的值不变 A1:A5单元格区域的值均为100 A1:A5单元格区域的值为100~104的递增数列 A1的值为100,A2:A5的值为空
=IF(A5<60,不及格,及格) =IF(A5<60,"不及格","及格") =IF(A5<60,及格,不及格) =IF(A5<60,"及格","不及格")
A1的值为100,A2:A5的值不变 A1:A5单元格的值均为100 A1:A5单元格的值为100至104的递增数列 A1的值为100,A2:A5的值为空
=SUM(A1: A5) SUM(A1: A5) =SUM(A1+A5) SUM(A1+A5)
=A5*B4 =A5*B4/5 =A5+B4 A5+B4、C8
增加A5门限1 减小A5门限1 增加A5门限2 减小A5门限2