6
QuizMultiple Choice

Uploading Your Work — Unit test

Question 6 • Computer Applications - Office 2019/Office 365 A

In a VLOOKUP formula, what does the argument column_index_number mean?

Answer
A
the secret INDEX number that each column in an Excel worksheet has
B
the number of the column within the selected table array where the lookup result is located
C
a numerical representation of the letters at the top of a worksheet; for example, A = 1, B = 2, etc.
D
numbers a user assigns to columns in a worksheet
In a VLOOKUP formula, what does the argument…