Microsoft Exam 77-427 Topic 3 Question 8 Discussion

Actual exam question for Microsoft's exam

Question #: 8
Topic #: 3

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.

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 using paste > special > values sequence.

DCreate a new column subsequent to the one with the additional spaces in it.

EUse the TRIM function in the new column.

Show Suggested Answer

Suggested Answer: B, C, D, E

In this situation, you will take the following steps:

1. Create a new column subsequent to the one with the additional spaces in it.

2. Use the TRIM function in the new column to get rid of extra spaces.

3. Copy the contents of the new column and paste them on the top of the original column by using paste > special > values sequence.

4. Delete the column having the TRIM function. Answer option A is incorrect. This is an invalid answer option.

by Ceola at May 08, 2022, 02:03 AM

Limited Time Offer

25%

Off

Get Premium Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!