【单选题】【消耗次数:1】
若在Excel2010某工作表的F1、G1单元格中分别填入了3.5和4,并将这2个单元格选定,然后向右拖动填充柄,在H1和I1中分别填入的数据是()。
3.5、4
4、4.5
4.5、5
5、5.5
参考答案:
复制
纠错
相关题目
【单选题】 若在一个工作表的A3、A4单元格中分别填入了2006和2007,并将这2个单元格选定,然后向下拖动填充柄,在A8中自动填入的内容是( )。
①  2009
②  2012
③  2010
④  2011
【单选题】 在Excel 2010中,利用复制柄可以将数据复制到相邻单元格中,若A3、A4单元格的数值为分别为1,4,选中A3、A4单元格向上左键拖动复制柄,则A1单元格中的数值为( )。
①  10
②  64
③  -2
④  -5
【单选题】 在Excel中,当前工作表的B1:C5单元格区域已经填入数值型数据,如果要计算这10个单元格的平均值并把结果保存在D1单元格中,则要在D1单元格中输入____。
①  =COUNT(B1:C5)
②  =AVERAGE(B1:C5)
③  =MAX(B1:C5)
④  =SUM(B1:C5)
【单选题】 在Excel工作表中,A1,A2单元格中数据分别为2和5,若选定A1:A2区域并向下拖动填充柄,则A3:A6区域中的数据序列为____。
①  6,7,8,9
②  3,4,5,6
③  2,5,2,5
④  8,11,14,17
【单选题】 在A1单元格输入2,在A2单元格输入5,然后选中A1:A2区域,拖动填充柄到单元格A3:A8,则得到的数字序列是( )。
①  等比序列
②  等差序列
③  数字序列
④  小数序列
【单选题】 在A1单元格输入2,在A2单元格输入5,然后选中A1:A2区域,拖动填充柄到单元格A3:A8,则得到的数字序列是( )。
①  等比序列
②  等差序列
③  数字序列
④  小数序列
【单选题】 在A1单元格输入2,在A2单元格输入5,然后选中A1:A2区域,拖动填充柄到单元格A3后,A3单元格的值为8,则得到的数字序列是( )。
①  等比序列
②  等差序列
③  数字序列
④  小数序列
【单选题】 将Excel工作表的A1单元格中的公式“=F5+$G$9”复制到C2单元格中,则C2单元格中的公式是( )
①  =H6+$G$9
②  =H6+$I$10
③  =F5+$G$9
④  =F5+$I$10
【单选题】 默认状态下,在Excel 2010工作表单元格中输入(),可使该单元格显示1/5。
①  1/5
②  1/5
③  0 1/5
④  =1/5
【单选题】 Excel2010的D5单元格中公式为=SUM(D1:D4),删除第2行后,原单元格的公式将调整为_____。
①  #VALUF!
②  =SUM(D1:D4)
③  =SUM(D2:D4)
④  =SUM(D1:D3)
随机题目
【单选题】 The pressure _____ causes Americans to be energetic, but it also puts them under a constant emotional strains.
①  to compete
②  competing
③  to be competed
④  having competed
【单选题】 We should make a clear ____ between the two scientific terms for the purpose of our discussion.
①  separation
②  discrimination
③  deviation
④  distinction
【单选题】 He _______ to study harder in the future so that he could have more opportunities to find a better job.
①  resolved
②  resorted
③  requested
④  reserved
【单选题】 She accused the man _____ breaking into her house.
①  at
②  of
③  for
④  with
【单选题】 Students with _______ problems may apply for student loans.
①  economic
②  financial
③  male
④  economical
【单选题】 James Fraser ____ tradition by using three actual American Indians as models for his creation.
①  went out
②  went for
③  went in
④  went against
【单选题】 Many manufacturers were accused of concentrating too heavily on cost reduction, often at the ____ of the quality of their products.
①  expense
②  exposure
③  expansion
④  expectation
【单选题】 I always ____ what I have said.
①  get to
②  hold to
③  lead to
④  see to
【单选题】 The manager promised to keep me ____ of how our business was going on.
①  to be informed
②  on informing
③  informed
④  informing
【单选题】 I’m very sorry to have ____ you with so many questions on such an occasion.
①  interfered
②  offended
③  impressed
④  bothered