【单选题】【消耗次数:1】
Excel中引用绝对单元格,需在工作表地址前加上()符号。
@
#
$
参考答案:
复制
纠错
相关题目
【单选题】 Excel中,单元格地址的绝对引用是在列标,行号之前都加上( )符号
①  :
②  $
③  =
【单选题】 在Excel中的一个单元格的行地址或列地址钱,为表示绝地地址引用应该加上符号是 。
①  @#
②  $
③  %
【单选题】 在Excel中的一个单元格的行地址或列地址钱,为表示绝地地址引用应该加上符号是()。
①  @#
②  $
③  %
【单选题】 当向Excel2010工作表单元格输入公式时,使用单元格地址D$2引用D列2行单元格,该单元格的引用称为________。
①  交叉地址引用
②  混合地址引用
③  相对地址引用
④  绝对地址引用
【单选题】 在Excel工作表中,每个单元格都有唯一的编号叫地址,单元格地址的命名方法是____。
①  字母+字母
②  列标+行标
③  数字+数字
④  行标+列标
【判断题】 在Excel中单元格的引用只有相对引用和绝对引用两种形式。
①  正确
②  错误
【单选题】 在Excel中,绝对地址在被复制或移动到其他单元格时,其单元格地址( )。
①  不会改变
②  部分改变
③  发生改变
④  不能复制
【单选题】 在Excel 2010的表中,第二行第三列单元格的绝对引用名是()。
①  C2
②  $C$2
③  B3
④  $B$3
【单选题】 下列Excel 2010选项中,属于对单元格“绝对引用”的是?
①  D4
②  &D&4
③  $D4
④  $D$4
【单选题】 在Excel的工作表中,每个单元格都有其固定的地址,如“A5”表示( )。
①  “A”代表“A”列,“5”代表第“5”行
②  “A”代表“A”行,“5”代表第“5”列
③  “A5”代表单元格的数据
④  以上都不是
随机题目
【单选题】 English ____ in Canada.
①  speaks
②  are spoken
③  is speaking
④  is spoken
【单选题】 The key ___ on the table when I leave.
①  was left
②  will be left
③  is left
④  has been left
【单选题】 阅读理解:阅读下列短文,回答文后问题,选择最佳答案Trees mainly serve man in three important ways: They provide him with wood and other products; they provide him shade; and they help to prevent droughts and floods.Unfortunately, in many parts of the world, man has not realized that the third of these services is the most important.In his eagerness to make money from trees, he has cut them down in large numbers, only to find that without them he has lost the best friends he had. And besides, he is usually too careless to plant and look after new trees. So the forests slowly disappear.This does not only mean that man will have fewer trees. The results are even more serious: for where there are trees, their roots break up soil allowing the rain to sink in and also bind(固定) the soil, thus preventing it from being washed away easily;but where there are no trees, the rain falls on hard ground and flows away, causing floods and carrying away the rich top-soil. When the top-soil is gone, nothing remains but worthless desert.Two thousand years ago,a rich and powerful country cut down its trees to build warships, with which to gain itself an empire.It set up the empire, but, without its trees, its soil became poor and grew weak. When the empire fell to pieces, the home country found itself faced by floods and starvation(饥荒).5. Which title best fits the passage?
①  A. Trees and Man
②  B. The Function of Tree Wood
③  C. How do People do with Trees?
④  D. The Usage of Tree Roots
【单选题】 Doctors ___ in every part of the world.
①  need
②  are needing
③  are needed
④  will need
【单选题】 The Peoples Republic of China ___ on October 1, 1949.
①  found
②  was founded
③  is founded
④  was found
【单选题】 A new house ___ at the corner of the road.
①  is building
②  is being built
③  been built
④  be building
【单选题】 Our room must ___ clean.
①  keep
②  be kept
③  to be kept
④  to keep
【单选题】 阅读理解:阅读下列短文,回答文后问题,选择最佳答案Trees mainly serve man in three important ways: They provide him with wood and other products; they provide him shade; and they help to prevent droughts and floods.Unfortunately, in many parts of the world, man has not realized that the third of these services is the most important.In his eagerness to make money from trees, he has cut them down in large numbers, only to find that without them he has lost the best friends he had. And besides, he is usually too careless to plant and look after new trees. So the forests slowly disappear.This does not only mean that man will have fewer trees. The results are even more serious: for where there are trees, their roots break up soil allowing the rain to sink in and also bind(固定) the soil, thus preventing it from being washed away easily;but where there are no trees, the rain falls on hard ground and flows away, causing floods and carrying away the rich top-soil. When the top-soil is gone, nothing remains but worthless desert.Two thousand years ago,a rich and powerful country cut down its trees to build warships, with which to gain itself an empire.It set up the empire, but, without its trees, its soil became poor and grew weak. When the empire fell to pieces, the home country found itself faced by floods and starvation(饥荒).4. Why did the country mentioned in the passage suffer from floods and starvations?
①  A. Because it set up an empire.
②  B. Because it fell to pieces.
③  C. Because it turned its trees into warships.
④  D. Because it spent too much money on wars.
【单选题】 阅读理解:阅读下列短文,回答文后问题,选择最佳答案Trees mainly serve man in three important ways: They provide him with wood and other products; they provide him shade; and they help to prevent droughts and floods.Unfortunately, in many parts of the world, man has not realized that the third of these services is the most important.In his eagerness to make money from trees, he has cut them down in large numbers, only to find that without them he has lost the best friends he had. And besides, he is usually too careless to plant and look after new trees. So the forests slowly disappear.This does not only mean that man will have fewer trees. The results are even more serious: for where there are trees, their roots break up soil allowing the rain to sink in and also bind(固定) the soil, thus preventing it from being washed away easily;but where there are no trees, the rain falls on hard ground and flows away, causing floods and carrying away the rich top-soil. When the top-soil is gone, nothing remains but worthless desert.Two thousand years ago,a rich and powerful country cut down its trees to build warships, with which to gain itself an empire.It set up the empire, but, without its trees, its soil became poor and grew weak. When the empire fell to pieces, the home country found itself faced by floods and starvation(饥荒).3. Land becomes desert after all trees are cut down because __________.
①  A. roots of trees break up the soil
②  B. no tree keeps the rain and protects the top-soil
③  C. strong winds bring a lot of sand
④  D. there are too many rainfalls to make it
【单选题】 阅读理解:阅读下列短文,回答文后问题,选择最佳答案Trees mainly serve man in three important ways: They provide him with wood and other products; they provide him shade; and they help to prevent droughts and floods.Unfortunately, in many parts of the world, man has not realized that the third of these services is the most important.In his eagerness to make money from trees, he has cut them down in large numbers, only to find that without them he has lost the best friends he had. And besides, he is usually too careless to plant and look after new trees. So the forests slowly disappear.This does not only mean that man will have fewer trees. The results are even more serious: for where there are trees, their roots break up soil allowing the rain to sink in and also bind(固定) the soil, thus preventing it from being washed away easily;but where there are no trees, the rain falls on hard ground and flows away, causing floods and carrying away the rich top-soil. When the top-soil is gone, nothing remains but worthless desert.Two thousand years ago,a rich and powerful country cut down its trees to build warships, with which to gain itself an empire.It set up the empire, but, without its trees, its soil became poor and grew weak. When the empire fell to pieces, the home country found itself faced by floods and starvation(饥荒).1. According to the passage, which is the most important service of trees to man?
①  A. They help him make money.
②  B. They give him cool.
③  C. They give him wood and other things.
④  D. They help him to stop droughts and floods.