AnswersComputer Applications - Office 2019Office 365 ALookup Functions and Formula AuditingQuestion 1
1
AssignmentMultiple Choice

Lookup Functions and Formula Auditing

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

If the VLOOKUP function is used to find an approximate match, what will it return if there is no exact match?

Answer
A
the largest value in the table
B
the smallest value in the table
C
the largest value that is less than the lookup value
D
the smallest value that is greater than the lookup value
Next

More from this Course

Assignment
9 verified answers

Sharing and Protecting Worksheets

Assignment
6 verified answers

Automating Workbook Functionality

Assignment
5 verified answers

Forecasting Data

If the VLOOKUP function is used to find an…