Câu 6: 77-888: Excel 2010 Expert

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.

1. 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. — đáp án hiện tại
2. B. The contents of the cells that are being compared may have different data types. — đáp án hiện tại
3. C. Excel is trying to reference an invalid cell.
4. D. You are inserting a new column, next to a column that is already formatted as text.