题目内容

公式“=IFERROR(VLOOKUP(A2,$D$2:$E$39,3,0),"")”的意思是()。

A. 直接显示VLOOKUP(A2,$D$2:$E$39,3,0)查找结果
B. 将VLOOKUP(A2,$D$2:$E$39,3,0)查找结果显示为错误值
C. 如果VLOOKUP(A2,$D$2:$E$39,3,0)查找的结果为错误值,则显示为空单元格,否则显示为VLOOKUP(A2,$D$2:$E$39,3,0)查找结果
D. 将VLOOKUP(A2,$D$2:$E$39,3,0)查找结果显示为空单元格

查看答案
更多问题

关于VLOOKUP()函数,下列说法正确的有()。

A. 函数的第2参数,被查找的关键字必需位于选定区域的最左侧
B. 函数的第4参数,如果选择0,则为精确查找
C. 如果函数计算的结果,显示为
D. N/A,则表示:查无此值
E. 当函数第二参数选定错误时,或者第三参数要求返回的列数大于选定区域时,会出现查询结果为
F. REF!

关于VLOOKUP()函数,下列说法不正确的有()。

A. 函数的第2参数,查找区域一定要选择整张数据源表格
B. 函数的第4参数,如果选择0,则为模糊查找
C. 如果函数计算的结果,显示为
D. REF,则表示:查无此值
E. 当函数第二参数选定错误时,或者第三参数要求返回的列数大于选定区域时,会出现查询结果为
F. N/A

Identify the question, example and conclusion in the following passage.What is culture shock? When he first visited the US, Mr. Li was confused on a bus: He meant to give his seat to an elderly man, but the man seemed annoyed and refused to take the seat. Later his American friends explained to him that in the US it is not advisable, and even offensive, to offer your seat to elderly people. This is very different from China, where people are encouraged to do so.From the example we can see that culture shock is the feeling of confusion and anxiety when you encounter situations where the cultural norms in your culture no longer apply.

设初始栈为空,s表示入栈操作,x表示出栈操作,则合法的操作序列是

A. sxxssxxs
B. ssxsxxxs
C. ssxxxssx
D. sssxxxsx

答案查题题库