FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

On which of these groups in the Data tab will you go if you wish to import data from .txt or .csv files?

A	Sort & Filter
B	Forecast
C	Get & Transform Data
D	Queries & Connections

Explanation:

Detailed explanation-1: -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: -On the File menu, click Import. In the Import dialog box, click the option for the type of file that you want to import, and then click Import. In the Choose a File dialog box, locate and click the CSV, HTML, or text file that you want to use as an external data range, and then click Get Data.

Detailed explanation-3: -Go to the Data tab and select From Text. The Import Text File opens. Select your file in the Import Text File dialog window and then select Import.

Detailed explanation-4: -You can also import CSVs into Google Sheets directly from the file menu. Open a new Google spreadsheet and click File-> Import. Then choose a CSV to upload. You can choose a CSV file stored on Google Drive or upload one from your device.

There is 1 question to complete.