你可能感兴趣的试题
=AVERAGE(A1:A4) =AVERAGE(A1,A2,A3,A4) =(A1+A2+A3+A4)/4 =AVERAGE(A1+A2+A3+A4)
=(15-A1)/3 = A2/C1 SUM(A2:A4)/2 =A2+A3+D4
V=6/H(A1+ 4A0 +A2) V=4/H(A1+A0 +A2) V=6/H(A 1+A 0 +A2) V=4/H(A 1+ 4A0 +A2)
=(A5-A1)/3 =A2/C1 SUM(A2:A4)/2 =A2+A3+D4
a4,a3,a2,a1 a3,a2,a4,a1 a3,a1,a4,a2 a3,a4,a2,a1
3a2﹣a2=3 (a2)3=a5 a3•a6=a9 (2a2)2=4a2
=SUM(A2:A5) =SUMIF(A2:A5,800,B2:B5) =COUNTIF(A2:A5,800) =SUM(B2:B5,800,A2:A5)
Sheet1,Sheet2,Sheet3的A2:D5区域 Sheet1的A2:D5区域 Sheet1和Sheet3的A2:D5区域 Sheet1和Sheet3中不是A2:D5的其他区域
=SUM(A2:B4) =XX =SUM(XX) =A2+A3+A4+B2+B3+B4
=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)
是无损联结的 是保持函数依赖的 既是无损联结又保持函数依赖 既是有损联结又不保持函数依赖
SUM(A2:A6) A2+A3+A4+A5+A6 =SUM(A2:A6) =SUM(A2,A6)
A1A3 A1A2A3 A1A3A4 A2和A1A3
如果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