USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Where will you find the Convert Text to Columns Wizard?
|
|
Under the Home tab on the Ribbon, in the Cells group.
|
|
|
Under the Insert tab on the Ribbon, in the Data group.
|
|
|
Under the Data tab on the Ribbon, in the Data tools group.
|
|
|
By pressing the shortcut:Ctrl+W to launch the Wizard.
|
Explanation:
Detailed explanation-1: -Click the “Data” tab in the ribbon, then look in the “Data Tools” group and click “Text to Columns.” The “Convert Text to Columns Wizard” will appear.
Detailed explanation-2: -Click on the column letter to highlight the entire column you want to convert. On the Data tab, click on Text to Columns.
Detailed explanation-3: -Go to the Data tab > Get External Data > From Text. Then, in the Import Text File dialog box, double-click the text file that you want to import, and the Text Import Wizard dialog will open.
There is 1 question to complete.