USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the process of bringing data containing text fields separated by commas into Excel called? Importing Data
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -You can import data from a text file into an existing worksheet. On the Data tab, in the Get & Transform Data group, click From Text/CSV. In the Import Data dialog box, locate and double-click the text file that you want to import, and click Import.
Detailed explanation-2: -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.
Detailed explanation-3: -A CSV (comma-separated values) file is a text file that has a specific format which allows data to be saved in a table structured format.
There is 1 question to complete.