You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You observe that while trying to look up or match a lookup value within an array, Excel is not able to recognize the matching value. Which of the following are the reasons that are causing the above problem? Each correct answer represents a complete solution. Choose all that apply.
Options
A. The lookup value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.
B. The contents of the cells that are being compared may have different data types.
C. Excel is trying to reference an invalid cell.
D. You are inserting a new column, next to a column that is already formatted as text.
Correct Answer: A,B
No comments:
Post a Comment
Note: only a member of this blog may post a comment.