Import/Export Data (Grade 11 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Importing in Excel
Importing in Excel
Bringing data from external sources into Excel
Exporting in Excel
Exporting in Excel
Saving Excel data in different file formats
Location of import functions
Location of import functions
Data tab on Excel's ribbon
Common sources for importing data
Common sources for importing data
Access, text files, other Excel workbooks, web pages
CSV meaning
CSV meaning
Comma Separated Values
CSV format advantage
CSV format advantage
Most universal data format, readable by almost any programme
Import format options from Access
Import format options from Access
Table, PivotTable Report, PivotChart, Only Create Connection
Text Import Wizard purpose
Text Import Wizard purpose
Helps Excel understand text file structure
Common delimiters for text files
Common delimiters for text files
Comma, Tab, Semicolon, Space
What CSV files cannot store
What CSV files cannot store
Formulas, formatting, multiple worksheets, charts/images