Microsoft Excel 2010 Expert — Question 6

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.

Answer 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

Explanation

The correct answers are A and B because leading or trailing spaces can prevent Excel from matching values, and differing data types can also cause mismatches. Option C is incorrect because referencing an invalid cell does not directly relate to lookup issues, and option D does not affect the matching process between values.