【单选题】【消耗次数：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)
随机题目
【单选题】
The article ______ in French were impossible for me to read.
①
written
②
writing
③
write
④
wrote
【单选题】
According to the author, in order to have a good command of English one must ____.
①
employ as many learning strategies as possible
②
expect to gain an easier task
③
exert oneself constantly
④
sustain oneself
【单选题】
Mr. Brown had hardly said a word since supper,___ had his wife.
①
either
②
or
③
nor
④
so
【单选题】
______ bad cold she spent the entire day in bed.
①
As if
②
Even though
③
In addition
④
Due to
【单选题】
Modesty helps one to go forward, ______ conceit makes one lag behind.
①
whenever
②
only if
③
whereas
④
consequently
【单选题】
A pen pal provides good motivation for your writing because he or she ____.
①
lives far away from you
②
knows China a lot so that you can have a lot to talk about
③
also keeps a diary
④
may inform you of many interesting things in his or her culture
【单选题】
As for words which do not often occur in everyday situation, you just need to be able to ____.
①
recognize them
②
nod at them
③
concentrate much on them
④
practice using them constantly
【单选题】
According to the text, which of the following is NOT one of the possible activities for you to practice speaking English at school?
①
To talk to native speakers on campus.
②
To speak English to the waitress in English as you pay for a meal in a restaurant.
③
To rehearse aloud by yourself.
④
To talk with your classmates in English.