【单选题】【消耗次数:1】
在Excel中,公式SUM(C2:C6)的作用是()。
求C2到C6这五个单元格数据之和
求C2和C6这两个单元格数据之和
求C2与C6单元格的比值
以上说法都不对
参考答案:
复制
纠错
相关题目
【单选题】 公式=SUM(C2:C6)的作用是( A )。
①  求C2到C6这五个单元格数据之和
②  求C2和C6这两个单元格数据之和
③  求C2和C6这两个单元格的比值
④  以上说法都不对
【单选题】 已知C2:C6输入数据为8、2、4、10、6,函数AVERAGE(C2:C6)= ( )。
①  10
②  4
③  30
④  6
【单选题】 已知C2:C6输入数据8、2、3、5、6,函数AVERAGE(C2:C5)= ( )。
①  24
②  12
③  6
④  4、5
【单选题】 已知C2:C6输入数据8、2、3、5、6,函数AVERAGE(C2:C5)= ( )。
①  24
②  12
③  6
④  4、5
【单选题】 将Excel工作表的A1单元格中的公式“=F5+$G$9”复制到C2单元格中,则C2单元格中的公式是( )
①  =H6+$G$9
②  =H6+$I$10
③  =F5+$G$9
④  =F5+$I$10
【单选题】 Excel2010的C4:C6单元格区域的数据依次为5、9和4,则公式=AVERAGE(C4:C6)的值为________。
①  6
②  5
③  4
④  9
【判断题】 A7单元格的内容为“Microsoft”,B7单元格的内容为“Excel”,如果希望C6单元格的内容为“Microsoft Excel”,则在C6单元格中输入的公式为=A7B7。
①  正确
②  错误
【判断题】 A7单元格的内容为“Microsoft”,B7单元格的内容为“Excel”,如果希望C6单元格的内容为“Microsoft Excel”,则在C6单元格中输入的公式为=A7&B7。
①  正确
②  错误
【单选题】 在Excel工作表中,已知C2、C3单元格的值均为0,在C4单元格中输入“C4=C2+C3”,则C4单元格显示的内容为____。
①  C4=C2+C3
②  TRUE
③  1
④  0
【单选题】 在Excel工作表中,已知C2、C3单元格的值均为0,在C4单元格中输入“C4=C2+C3”,则C4单元格显示的内容为___。
①  C4=C2+C3
②  TRUE
③  1
④  0
随机题目
【单选题】 A: Congratulations!You won the first prize in the English speech contest. B: [填空].
①  Yes, I beat the others
②  Thank you
③  No, no, I didnt do it well
④  Its a pleasure
【单选题】 A: Hows everything with you? B: [填空], and how are you?
①  Thanks
②  Dont mention it
③  Not too bad
④  Pretty fast
【单选题】 A: Will you be free tomorrow evening? B: [填空]
①  No,Ill be busy.
②  What is the matter?
③  Im sorry I wont be free then.
④  No,Ill have no time.
【单选题】 A: Have you ever been to Huangshan? B:[填空].
①  No. Twice
②  I went there twice
③  Yes. Twice
④  Yes. Ill go there next month
【单选题】 A: Is there a bank near here? B: [填空].
①  Its very far
②  Its here
③  Yes, there is a big one
④  Its very crowded
【单选题】 A: David injured his leg playing football yesterday. B: Really? [填空]
①  Who did that?
②  hats wrong with him
③  How did that happen
④  Why was he so careless?
【单选题】 A: How are you doing?B: [填空].
①  Good night
②  Not so bad. And you?
③  I m pleased.
④  How do you do?
【单选题】 A: Would you like me to feed your cats while youre on your holiday? B: [填空].
①  I appreciate it, but Ive already fed them
②  No problem, I was more than glad to do it
③  Thanks for offering your help, but my sisters going to do it
④  Certainly, feeding cats is my favorite pastime
【单选题】 A: I missed yesterdays basketball final. B: [填空]
①  What a pity!
②  Its a good idea.
③  Remember to bring it next time.
④  Im glad to hear that.
【单选题】 A: May I use your dictionary for a moment? B: [填空].
①  Its well
②  It doesnt matter
③  By all means
④  Here you are