Question: 1 ) How can you import data into Excel? ( 1 point ) Click FILE then click EXPORT. Click Next to specify the delimiter. Click

1)
How can you import data into Excel? (1 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!