题目内容
(请给出正确答案)
[单选题]
设在B5单元格存有一公式为SUM(B2:B4),将其复制到D5后,公式变为:
A.SUM(B2:B4)
B.SUM(B2:D5)
C.5UM(D5:B2)
D.SUM(D2:D4)
查看答案
如果结果不匹配,请 联系老师 获取答案
A.SUM(B2:B4)
B.SUM(B2:D5)
C.5UM(D5:B2)
D.SUM(D2:D4)
A.sumif(A1:A10,”>=60”)
B. countif(A1:A10,”>=60”)
C. countif(A1:A10,”>=60”)/count(A1:A10)
D. sumif(A1:A10,”>=60”)/ sum(A1:A10)
A.按住鼠标右键拖动到E6单元格
B. 按住鼠标左键拖动到E6单元格
C. 按住Shift键并按向下向右光标键,直到E6单元格
D. 按住Ctrl键并按向下向右光标键,直到E6单元格
A.The result is:16 The result is:8.0
B.The result is:8.0 The result is:16
C.The result is:8 The result is:16.0
D.The result is:16.0 The result is:8