皮皮学，免费搜题
登录
logo - 刷刷题
搜题
【单选题】
关于函数OFFSET的应用,下列描述正确的有:
A.
操作公式 =OFFSET(a2,,,3,5)时，录入此公式以后，先按照原数据区域在新的位置选中相应大小的区域，然后在编辑栏的公式后单击，最后按ALT+SHIFT+ENTER
B.
公式 =OFFSET(a2,1,2,3,4)的意思是以a2为基准点，向下移一列，再向右移二行，数据显示在一个高3行宽4列的表格中
C.
操作公式 =OFFSET(a2,,,3,5)时，A2后面的三个逗号表示直接省略行数和列数编移，就是偏移5行5列后以后，将原数据区域的值在新的选定区域重现
D.
OFFSET中的参数reference必须为对单元格或相连单元格区域的引用，否则会返回错误值#N/A”
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
微信内点击右上角“…”即可分享
反馈
参考答案：
举一反三
【单选题】Why do some publishers no longer promote their books?
A.
Because the paper books are not profitable enough to sustain promotion.
B.
Because Amazon's near monopoly over the industry makes promotion unnecessary.
C.
Because the public have easy access to the books' sales and reviews.
D.
Because all the writers are promoting the books on their own.
查看完整题目与答案
【单选题】What critics are really worried about?
A.
Broadcasters and publishers do not want to make open bad news about their advertisers.
B.
Stations are too much interested in seeking money from their advertisers.
C.
Programs are not so appealing to more and more audience.
D.
Stations will not broadcast enough educational programs.
查看完整题目与答案
【单选题】传染病区内属于半污染区的是
A.
病室内所
B.
浴室、处置室
C.
病区内走廊
D.
库房、值班室
E.
更衣室、配餐室
查看完整题目与答案
【简答题】声道分为:
查看完整题目与答案
【单选题】What do publishers have to do if they want their digital products to be successful according to Murphy?
A.
They have to make the prices lower.
B.
They have to provide more kinds of products.
C.
They have to advertise their products.
D.
They have to design the user experience to be  as interactive as possible.
查看完整题目与答案
【单选题】What are editors and publishers doing to attract non-readers?
A.
Lowering the prices of their newspapers.
B.
Shortening their news stories.
C.
Adding variety to their newspaper content.
D.
Including more advertisements in their newspapers.
查看完整题目与答案
【单选题】传染病区内属于半污染区的是
A.
库房
B.
病区内走廊
C.
值班室
D.
病室
E.
病区外走廊
查看完整题目与答案
【单选题】What is the controversial point between the publishers and the technology companies?
A.
The publishers hope they can offer books of top quality.
B.
The publishers hope they can respect copyright of original books.
C.
The publishers hope they can provide the comments.
D.
The publishers hope they can digitize as many books as possible.
查看完整题目与答案
【单选题】Under the new law, what must publishers do?
A.
Offer cheaper DVDs and workbooks
B.
Sell books individually
C.
Provide discounts to professors
D.
Communicate with parents
查看完整题目与答案
【单选题】传染病区内属于半污染区的是
A.
病室内厕所
B.
浴室,处置室
C.
病区的内走廊
D.
库房,值班室
E.
更衣室,配餐室
查看完整题目与答案
相关题目：
【单选题】Why do some publishers no longer promote their books?
A.
Because the paper books are not profitable enough to sustain promotion.
B.
Because Amazon's near monopoly over the industry makes promotion unnecessary.
C.
Because the public have easy access to the books' sales and reviews.
D.
Because all the writers are promoting the books on their own.
查看完整题目与答案
【单选题】What critics are really worried about?
A.
Broadcasters and publishers do not want to make open bad news about their advertisers.
B.
Stations are too much interested in seeking money from their advertisers.
C.
Programs are not so appealing to more and more audience.
D.
Stations will not broadcast enough educational programs.
查看完整题目与答案
【单选题】传染病区内属于半污染区的是
A.
病室内所
B.
浴室、处置室
C.
病区内走廊
D.
库房、值班室
E.
更衣室、配餐室
查看完整题目与答案
【简答题】声道分为:
查看完整题目与答案
【单选题】What do publishers have to do if they want their digital products to be successful according to Murphy?
A.
They have to make the prices lower.
B.
They have to provide more kinds of products.
C.
They have to advertise their products.
D.
They have to design the user experience to be  as interactive as possible.
查看完整题目与答案
【单选题】What are editors and publishers doing to attract non-readers?
A.
Lowering the prices of their newspapers.
B.
Shortening their news stories.
C.
Adding variety to their newspaper content.
D.
Including more advertisements in their newspapers.
查看完整题目与答案
【单选题】传染病区内属于半污染区的是
A.
库房
B.
病区内走廊
C.
值班室
D.
病室
E.
病区外走廊
查看完整题目与答案
【单选题】What is the controversial point between the publishers and the technology companies?
A.
The publishers hope they can offer books of top quality.
B.
The publishers hope they can respect copyright of original books.
C.
The publishers hope they can provide the comments.
D.
The publishers hope they can digitize as many books as possible.
查看完整题目与答案
【单选题】Under the new law, what must publishers do?
A.
Offer cheaper DVDs and workbooks
B.
Sell books individually
C.
Provide discounts to professors
D.
Communicate with parents
查看完整题目与答案
【单选题】传染病区内属于半污染区的是
A.
病室内厕所
B.
浴室,处置室
C.
病区的内走廊
D.
库房,值班室
E.
更衣室,配餐室
查看完整题目与答案
参考解析：
知识点：
题目纠错 0
发布
创建自己的小题库 - 刷刷题