【单选题】【消耗次数:1】
在Excel2010工作表中,下列正确的Excel公式形式为_____。
=B3*Sheet3!A2
=B3*Sheet3$A2
=B3"Sheet3:A2
=B3*Sheet3%A2
参考答案:
复制
纠错
相关题目
【单选题】 在Excel工作表中,如果工作表Sheet1上E3的值等于另一工作表Sheet3上F3的值,则E3的公式可表示为( )。
①  =F3Sheet3
②  =Sheet3!F3
③  =Sheet3!(E3:F3)
④  =Sheet3(F3)
【单选题】 Excel中,某区域由A1,A2,A3,B1,B2,B3六个单元格组成,下列不能表示该区域的是( )。
①  A1:B3
②  A3:B1
③  B3:A1
④  A1:B1
【单选题】 在Excel中,“Sheet2!C2”中的Sheet2表示( )
①  工作表名
②  工作簿名
③  单元格名
④  公式名
【判断题】 若3?a2+b2,则3?a且3?b.
①  正确
②  错误
【简答题】 设 A = {1, 2=,2, 4=,3, 3=},B = {1, 3=,2, 4=,4, 2=},求交关系A∩B的值域ran(A∩B)。
【简答题】 设 A = {1, 2=,2, 4=,3, 3=},B = {1, 3=,2, 4=,4, 2=},则求差关系A-B。
【简答题】 设 A = {1, 2=,2, 4=,3, 3=},B = {1, 3=,2, 4=,4, 2=},求差关系A-B的域fld(A-B)。
【判断题】 设 A = {1, 2=,2, 4=,3, 3=},B = {1, 3=,2, 4=,4, 2=},则并关系A∪B的定义域dom(A∪B)等于:{1,2,3,4}。
①  正确
②  错误
【简答题】 设 A = {1, 2=,2, 4=,3, 3=},B = {1, 3=,2, 4=,4, 2=},求并关系A∪B的定义域dom(A∪B)。
【简答题】 设 A = {1, 2=,2, 4=,3, 3=},B = {1, 3=,2, 4=,4, 2=},则交关系A∩B等于:[填空1]
随机题目
【单选题】 Television is a remarkable_________ !
①  discussion
②  suggestion
③  invention
④  declaration
【单选题】 You can buy things_________ special low prices when department stores have sales.
①  at
②  in
③  on
④  for
【单选题】 阅读理解:阅读下列短文,回答文后问题,选择最佳答案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(饥荒).2. In many places forests slowly disappear because __________.
①  A. many trees have been cut down by man
②  B. new trees are not well looked after
③  C. man has not paid enough attention to planting trees
④  D. all the above
【单选题】 _________ people have a photographic memory.
①  No
②  None
③  Some
④  All
【单选题】 Rowland Hill was the first to_________ a proposal to use stamps.
①  put forward
②  put up
③  put away
④  put on
【单选题】 Why has jogging become so popular? Because jogging is a very_________ exercise.
①  boring
②  disturbing
③  frustrating
④  interesting
【单选题】 Your long-term memory_________ everythingthat you remember.
①  concludes
②  conveys
③  closes
④  contains
【多选题】 垄断竞争厂商的需求曲线包括( )
①  主观需求曲线
②  客观需求曲线
③  弯折的需求曲线
④  线性需求曲线
【多选题】 在长期中,下列成本中哪些是存在的( )
①  总成本
②  平均成本
③  机会成本
④  不变成本
【多选题】 以下是垄断竞争行业的特征( )
①  有进入限制
②  企业以利润最大化为目标
③  企业面临着向右下方倾斜的需求曲线
④  企业生产有差别的产品