Microsoft Exam 77-427 Topic 5 Question 29 Discussion

Actual exam question for Microsoft's exam

Question #: 29
Topic #: 5

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 in the columns. While doing so, 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. You want to store sets of values as text and convert sets of data to text by using Excel's Text To Columns tool. Which of the following steps will you take to accomplish the task?

Each correct answer represents a part of the solution. Choose all that apply.

ASelect the Text to Columns option from the Data tab at the top of the Excel workbook.

BSelect Text and click the Finish button in Column Data Formats.

CSelect the Delimited option and click Next

DMake sure that all delimiter options are unselected, and then again click Next.

ERemove the unseen spaces at the start or end of the first Macro cell.

FSelect the cells to convert their data to text.

Show Suggested Answer

Suggested Answer: A, B, C, D, F

In this situation, you will take the following steps:

Select the cells to convert their data to text.

Select the Text to Columns option from the Data tab at the top of your Excel workbook.

Select the Delimited option and click Next.

Make sure that all delimiter options are unselected, and then again click Next.

Select Text and click the Finish button in Column Data Formats.

by Chanel at May 07, 2022, 09:32 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!