题目内容
(请给出正确答案)
[单选题]
如果在A1、B1和C1三个单元格分别输入数据1、2和3,再选择单元格D1,然后单击常用工具栏中的按钮"Σ",则在单元格D1显示 ()
A.=SUM(A1:C1)
B.=MAX(A1:C1)
C.=AVERAGE(A1:C1)
D.=MIN(A1:C1)
查看答案
如果结果不匹配,请 联系老师 获取答案
A.=SUM(A1:C1)
B.=MAX(A1:C1)
C.=AVERAGE(A1:C1)
D.=MIN(A1:C1)
A.=A2+A4
B.=SUM(A2+A4)
C.=Al+A2+A3
D.=SUM(A2:A4)
A.A1&VALUE(B1,"00")
B.A1&TEXT(B1,"00")
C.A1&TEXT(B1,00)
D.A1$TEXT(B1,"00")
A. =DATEDIF(A1
B.B1,"
C.d")B、 =DATEDIF(B1,A1,"d")
D.C、 =DAYS360(A1,B1)□D、 =DAYS360(B1,A1)
等号成立的充分要条件是a1:b1:c1=a2:b2:c2=...=an:bn:Cn且a1,a2,...,an;b1,b2,...,bn;c1,c2,...,cn分别同号.
在Excel工作表的A1单元格中输入B0,在B1单元格中输入条件函数=LF(A1>=80,”GooD”,IF(AI>=60,”PASS”,”FAIL”)),则B1单元格中显示()。
A.FAIL
B.PASS
C.GOOD
D.IF(A1>一60,”PASS”,”FAIL”)