Microsoft
77-427 · Question #16
77-427 Question #16: Real Exam Question with Answer & Explanation
Sign in or unlock 77-427 to reveal the answer and full explanation for question #16. 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 the spreadsheet of the company's high selling products. You want to find out the matching values. You get an unexpected error that when you attempt to look up or match a lookup_value within an array, Excel is not able to recognize the matching value. Which of the following steps will you take to resolve the problem? Each correct answer represents a part of the solution. Choose all that apply.
Options
- ARemove the unseen spaces at the start or end of the first Macro cell.
- BDelete the column having the TRIM function.
- CCopy the contents of the new column and paste them on the top of the original column by
- DCreate a new column subsequent to the one with the additional spaces in it.
- EUse the TRIM function in the new column.
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.