77-427 · Question #16
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…
The correct answer is B. Delete the column having the TRIM function. C. Copy the contents of the new column and paste them on the top of the original column by D. Create a new column subsequent to the one with the additional spaces in it. E. Use the TRIM function in the new column. 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…
Question
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.
How the community answered
(17 responses)- A18% (3)
- B82% (14)
Explanation
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.
Topics
Community Discussion
No community discussion yet for this question.