你可能感兴趣的试题
=AVERAGE(A1:A4) =AVERAGE(A1,A2,A3,A4) =(A1+A2+A3+A4)/4 =AVERAGE(A1+A2+A3+A4)
a1∶a2=1∶2 s1∶s2=1∶2 a1∶a2=1∶2 s1∶s2=2∶1 a1∶a2=1∶2 s1∶s2=1∶4 a1∶a2=4∶1 s1∶s2=2∶1
=A1+A2 <A1×A2 >A1×A2 =A1×A2
=A2-2 =A1-2 =$A$1-2 =$A$2-2
=AVERAGE(A2:H2) =SUM(A2:H2) =SUM(A2:H2)-MAX(A2:H2)-MIN(A2:H2) =(SUM(A2:H2)-MAX(A2:H2)-MIN(A2:H2))/(COUNT(A2:H2)-2)
count(A2、K2,“√”) count(A2,K2) countif(A2、K2,“√”) countif(“√”,A2、K2)
a1,a2=0 a1=0,a2=0 store0toa1,a2 store0,0toa1,a2
如果A1=90、A2=人数、A3=…""、A4=54、A5=36,则公式"=Count(A1:A5)"返回5 如果A1=6.28、A2=3.74,其余单元格为空,则公式"=Counta(A1:A7)"的计算结果等于2 如果A1=90、A2=人数、A3=""、A4=54、A5=36,则公式"=Count(A1:A5)"返回3 如果A1=6.28、A2=3.74,其余单元格为空,则公式"=Counta(A1:A7)"的计算结果等于3