【判断题】【消耗次数：1】
VLOOKUP函数的功能是在表格或数值数组的首列查找指定的数值，并由此返回表格或数组中该数值所在行中指定列处的数值。
①
正确
②
错误
参考答案：
复制
纠错
➡️如需代学继续教育，联系微信：yizhituziang
相关题目
【单选题】
VLOOKUP 函数从一个数组或表格的（）中查找含有特定值的字段，再返回同 一列中某一指定单元格中的值。
①
A.第一行
②
B.最末行
③
C.最左列
④
D.最右列
【单选题】
在下列函数中,函数值为数值的就是( )
①
AT(′人民′ , ′中华人民共与国′)
②
CTOD(′01/01/96 ′)
③
BOF()
④
SUBSTR(DTOC(DATE()),7
【简答题】
在Excel中，若要计算表格中某行数值的最大值，可使用的函数是_____ 。
随机题目
【单选题】
15. She suffered great mental_____ after her husband died, and as a result she became mad.
①
anger
②
. discomfort
③
unhappiness
④
anguish
【单选题】
13. The supervisor appreciates ______ so hard in the office.
①
for your working
②
your working
③
you to work
④
for you to work
【单选题】
10. ______, he was unable to make much progress.
①
Hard as he tried
②
Though hard as he tried
③
He tried hard
④
Because he tried hard
【单选题】
9.She does not_____ that she owes the money, but she just wouldn’t like to return it.
①
argue
②
. dispute
③
think
④
agree
【单选题】
9. By 2008, Beijing ______ its total discharge of pollutants.
①
will reduce
②
will have reduced
③
reduces
④
has reduced
【单选题】
5. The children were seen _______ musical instruments across the street.
①
play
②
to play
③
playing
④
played
【单选题】
8. ______, he was honest.
①
As he was poor
②
Being poor
③
Poor as he was
④
He was poor
【单选题】
12. I’m very sorry to have _______ you with so many questions on such an occasion.
①
interfered
②
offended
③
impressed
④
bothered