COMP APPS II: 5.2.4 - External Data

What is Excel able to do with files it doesn’t immediately recognize?

• Import them with only a few clicks

• Export them with only a few clicks

• Delete them with only a few clicks

• Format them with only a few clicks

Where do you start when dealing with data from a source outside of Excel?

• In the Home tab

• In the Insert tab

• In the Data tab

• In the Page Layout tab

How can you import data from a text file into Excel?

• Click From Text in the Get External Data group in the Data tab

• Click From Text in the Get External Data group in the Home ta

• Click From Text in the Get External Data group in the Insert tab

• Click From Text in the Get External Data group in the Page Layout tab

What is a delimiter?

• A character used to separate information in different cells

• A character used to combine information in different cells

• A character used to format information in different cells

• A character used to delete information in different cells

What should you do if your data has headers?

• Tick the ‘My data has headers’ box

• Uncheck the ‘My data has headers’ box

• Check the comma box

• Uncheck the Tab box

What should you do if your data is separated by commas?

• Check the comma box

• Uncheck the comma box

• Check the Tab box

• Uncheck the Tab box

What can you choose on the final screen of importing external files into Excel?

• Which number format to apply to each column

• Which delimiter to use for each column

• Which header to use for each column

• Which cell to start importing data into

How can you choose where your data should go on an Excel spreadsheet?

• By clicking on the cell you’d like the data to appear in

• By dragging and dropping the data onto the cell

• By typing in the cell coordinates

• By selecting the cell from a drop-down menu

What did we learn in this video?

• How to recognize what kind of delimiter an external file uses

• How to import external files into Excel

• How to export external files from Excel

• a and b

What are Excel’s importing tools useful for?

• Working across different data analysis programs

• Working within one data analysis program

• Working without any data analysis programs

• Working with only one kind of file