AnswersComputer Applications I-Sem A -CA- 39901AWorking with Multiple Worksheets and Workbooks

Lookup Functions and Formula Auditing Answers

2 verified answers3 views
1
Free Preview

The VLOOKUP function looks up values in a table with which feature?

A
column labels in the top row
B
column labels in the bottom row
C
row labels in the leftmost column
D
row labels in the rightmost column
2
Free Preview

What is the format for the VLOOKUP function?

A
VLOOKUP(table array, lookup value, range lookup, col index num)
B
VLOOKUP(lookup value, table array, col index num, range lookup)
C
VLOOKUP(col index num, range lookup, table array, lookup value)
D
VLOOKUP(range lookup, table array, lookup value, col index num)

Did you find these answers helpful?

More from this Course

Assignment
12 verified answers

Working with Multiple Worksheets and Workbooks

Instruction
5 verified answers

Instruction

Assignment
25 verified answers

Topic Test

Lookup Functions and Formula Auditing Answers…