【单选题】【消耗次数：1】
Excel2010的D5单元格中公式为=SUM（D1：D4），删除第2行后，原单元格的公式将调整为_____。
①
#VALUF！
②
=SUM（D1：D4）
③
=SUM（D2：D4）
④
=SUM（D1：D3）
参考答案：
复制
纠错
相关题目
【单选题】
在Excel操作中,假设在B5单元格中存有一公式为SUM(B2:B4),将其复制到D2后,公式将变成（ ）。
①
SUM(D2:D4)
②
SUM(B2:D4)
③
SUM(D2:B4)
④
SUM(B2:B4)
【单选题】
在Excel中，已知C1单元格的值为6、D1单元格的值为2。在单元格中输入的公式，错误的是____。
①
=C1*D1
②
=C1/D1
③
=C1“OR”D1
④
=OR（C1，D1）
【单选题】
在Excel工作表中，单元格E5中有公式“=$C$2+D4”，删除第B列后E5单元格中的公式为（ ）。
①
=$B$2+C4
②
=$C$2+C4
③
=$C$2+D4
④
=$B$2+D4
【单选题】
当向Excel2010工作表单元格输入公式时，使用单元格地址D$2引用D列2行单元格，该单元格的引用称为________。
①
交叉地址引用
②
混合地址引用
③
相对地址引用
④
绝对地址引用
【单选题】
在Excel中，当前工作表的B1：C5单元格区域已经填入数值型数据，如果要计算这10个单元格的平均值并把结果保存在D1单元格中，则要在D1单元格中输入____。
①
=COUNT(B1:C5)
②
=AVERAGE(B1:C5)
③
=MAX(B1:C5)
④
=SUM(B1:C5)
随机题目
【单选题】
A:Happy birthday! Heres a gift for you. B: [填空].
①
Thats good. How much is it?
②
Wow, it is great! Thank you.
③
It must be very expensive.
④
You shouldnt have bought it.
【单选题】
A: Are you following me? B: [填空]
①
Can you walk slowly, please?
②
Let me think of it.
③
Im afraid not.
④
Who knows?
【单选题】
A: This meal is on me. [填空]. B: Thanks, but isnt it my turn to treat you?
①
Its none of your business
②
Ill treat you
③
My pleasure
④
I invite you
【单选题】
A: If things go on like this, we shall destroy ourselves. B: [填空]
①
Really? Congratulations!
②
Come on. Its not that bad.
③
Yes, you are good at it.
④
Its none of my business.
【单选题】
A: I got a job from Dell B: Thats great news. Im very happy for you. A: Thanks. I feel like celebrating. Lets go have a beer. [填空].
①
Its on me
②
Its so fine today
③
Its your turn
④
It is rather expensive
【单选题】
A: Richard, class begins at 9, and you are late. B: I know, but I missed my bus, Im sorry. B: [填空]. You have to be here on time.
①
Thats no excuse
②
Dont mention it
③
You neednt be
④
No problem
【单选题】
A: Dont tell me youve got a headache again. B: [填空].
①
Sorry, I wont be late next time
②
Youre right, Im just joking
③
All right, I wont say it
④
OK, youve made your point
【单选题】
A: Im sorry. Those shoes are not available in your size. B: [填空].
①
No use saying sorry. Thats a real let down
②
Im truly grateful for your help
③
Its just as Ive expected
④
Thats a pity. Thank you anyway
【单选题】
A: [填空]? B: Yes, Id like to open a savings account.
①
What do you want to do, sir
②
Why have you come here
③
Do you have anything to do here
④
Can I help you, sir
【单选题】
A: Bill told me he could not come here because his father was ill. B: [填空]
①
Its good.
②
Thats bad.
③
He is impolite.
④
What a pity!