你可能感兴趣的试题
=SUM(Sheet2! A2:A7) =SUM(Sheet2! A2:Sheet2! A7) =SUM((Sheet2)A2:A7) =SUM((Sheet2)A2:(Sheet2)A7)
A1示数为零,A2示数变大; A2是A.1示数的两倍; A1和A2 的示数仍相等 ; A1示数不变,A2示数变大.
Sheet2!A2:C5 Sheet2!$A2:$C5 Sheet2!$A$2:$C$5 Sheet2!$A2:C5
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
Sheet2 ! A2:C5 Sheet2 !$ A2: $ C5 Sheet2 !$ A $ 2: $ C $ 5 Sheet2 !$ A2:C5
=A1+A2 <A1×A2 >A1×A2 =A1×A2
Sheet2!A2:C5 Sheet2!$A2:$C5 Sheet2!$A$2:$C$5 Sheet2!$A2:C5
Sheet2!A2:C5 Sheet2!$A2: $C5 Sheet2$A$2: $C$5 Sheet2!$A2:C5
)相向运动,a1:a2=1:4 ( )相背运动,a1:a2=2:1( )相向运动,a1:a2=2:1 ( )相背运动,a1:a2=4:1
Sheet1,Sheet2,Sheet3的A2:D5区域 Sheet1的A2:D5区域 Sheet1和Sheet3的A2:D5区域 Sheet1和Sheet3中不是A2:D5的其他区域
A1不变,A2增大; A1和A2的示数都增大; A1和A2的示数都减小; A1减小,A2增大.
=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)
A1和A2均为净截面面积 A1为毛截面面积,A2为净截面面积 A1和A2均为毛截面面积 A1为净截面面积,A2为毛截面面积
4a-a=3 2(2a-b)=4a-b (a+b)2=a2+b2 (a+2)(a-2)=a2-4
count(A2、K2,“√”) count(A2,K2) countif(A2、K2,“√”) countif(“√”,A2、K2)
Sheet1!(A2) Sheet1(A2) Sheet1:A2 Sheet1!A2
a1,a2=0 a1=0,a2=0 store0toa1,a2 store0,0toa1,a2
投中有效,由A2追加罚球一次; 投中无效,由,A2罚球两次; 投中无效,由A2罚球两次和A队一次掷界外球; 投中有效,由A2罚球两次。