Microsoft
77-427 · Question #36
77-427 Question #36: Real Exam Question with Answer & Explanation
Sign in or unlock 77-427 to reveal the answer and full explanation for question #36. The question stem and answer options stay visible for context.
Question
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
- AThe lookup_value or the array you are searching resides in a cell containing unseen spaces
- BThe contents of the cells that are being compared may have different data types.
- CExcel is trying to reference an invalid cell.
- DYou are inserting a new column, next to a column that is already formatted as text.
Unlock 77-427 to see the answer
You've previewed enough free 77-427 questions. Unlock 77-427 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.