BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED

BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED

Importing
The process of inserting external data into the current application
External data
Data created or stored in another format
Two common file types imported into Excel
-Text files
-Access database files
Two ways to import directly into Excel
-Opening the file using the Open dialog box
-Creating a link to the original data source
Embed data
When you import external data into Excel but not maintain a link to the original data
source; allows you to edit the data directly within Excel
Link data
When you want to create a link; when you want imported data updated if changes are
made to the original data source
Text file
A data file that contains characters, such as letters, numbers, and symbols, including
punctuation and spaces, and contains delimiters
Text file extension
.txt
Benefit of a text file
Can import easily into a variety of programs
What does a text file NOT contain?
Formatting, sound, or video
Delimiters
Special characters that separate data
(tabs, commas)
Tab-delimited files
One tab separates columns
Columns may not align
Comma-separated value (CSV) files
Commas separate columns
Newline character separates rows
Fixed-width text file
A file in which each column contains a specific number of characters to separate the
fields
3 ways Access data can be imported into Excel
-As a table
-As a PivotTable report
-As a PivotChart
Importing Access databases into Excel