Question: 1 ) How can you import data into Excel? ( 1 point ) Click FILE then click EXPORT. Click Next to specify the delimiter. Click
How can you import data into Excel? point
Click FILE then click EXPORT.
Click Next to specify the delimiter. Click Next again to name the fields as well as to specify their data type. Then click Finish.
Click FILE then click IMPORT.
Click the External Data tab, select the file that contains the data and check Import the source data into a new table in the current database. Click OK
Open Excel, click the Data tab, and in the Get External Data section of that ribbon click From Text. Specify a comma delimiter and indicate where in the worksheet you want the data placed.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
