【单选题】【消耗次数：1】
在下列Excel 2010选项中，属于对“单元格”绝对引用的是
①
D4
②
D4
③
$D4
④
$D$4
参考答案：
复制
纠错
相关题目
【单选题】
Excel2010的D5单元格中公式为=SUM（D1：D4），删除第2行后，原单元格的公式将调整为_____。
①
#VALUF！
②
=SUM（D1：D4）
③
=SUM（D2：D4）
④
=SUM（D1：D3）
【单选题】
当向Excel2010工作表单元格输入公式时，使用单元格地址D$2引用D列2行单元格，该单元格的引用称为________。
①
交叉地址引用
②
混合地址引用
③
相对地址引用
④
绝对地址引用
【单选题】
在Excel工作表中，单元格E5中有公式“=$C$2+D4”，删除第B列后E5单元格中的公式为（ ）。
①
=$B$2+C4
②
=$C$2+C4
③
=$C$2+D4
④
=$B$2+D4
【单选题】
在Excel中，假定单元格D3中的公式为“=B3+C3”，若把它移动到E4中，则E4中的公式为( )。
①
=C4+D4
②
=B3+C3
③
C3+D3
④
B4+C4
随机题目
【单选题】
What do the following examples indicate? Big, huge; enormous, immense; male, masculine .
①
synonyms
②
antonyms
③
hyponyms
④
collocations.
【单选题】
What is referred to if we say “see a movie, watch a play, look at a picture”?
①
denotative meaning
②
connotative meaning
③
collocations
④
synonyms.
【单选题】
What are two categories of vocabulary?
①
Receptive vocabulary and productive vocabulary
②
innate vocabulary and learned vocabulary
③
familiar vocabulary and unfamiliar vocabulary
④
new vocabulary and old vocabulary.
【单选题】
What are two grammar practice activities?
①
Mechanical practice and meaningful practice
②
Volume practice and communicative practice
③
Interest practice and meaningful practice
④
Mechanical practice and success oriented practice.
【单选题】
What are two broad categories of knowledge?
①
Implicit knowledge and explicit knowledge
②
Obvious knowledge and unobvious knowledge
③
Inductive knowledge and deductive knowledge
④
Refereed knowledge and inferred knowledge.
【单选题】
Which of the following steps are typical for the deductive grammar teaching method?
①
Give examples→explain rules→students do practice activities
②
Authentic language data is provided→induces learners to realize grammar rules→apply the new structure to produce sentences (the inductive method)
③
Explicit rules are give to students→Authentic language data is provided→apply the new structure to produce sentences (the guided discovery method)
④
All of the above.
【单选题】
Which of the following statement is not true?
①
Grammatical competence is essential for communication
②
There is a positive role of instruction for grammar learning
③
Grammar teaching can enhance learner proficiency
④
Grammar learning is completely useless for children.
【单选题】
Which of the following is not grammar presentation method?
①
Deductive method
②
Inductive method
③
Guided discovery method
④
Communicative teaching method.
【单选题】
What is the realistic goal of teaching pronunciation?
①
Consistency
②
Intellegibility
③
Communicative efficiency
④
All of the above.
【单选题】
Which type does the following production practice belong to? She sells sea shells on the seashore.
①
Make up sentences
②
Using meaningful context
③
Using pictures
④
Using tongue twisters.