Test 4 A Flashcards
Connection
A defined process for retrieving data from an external file.
Text File
Contains only text and numbers without any formulas, graphics, special fonts or formatted texts.
Delimited Text
A way that text files are stored in which a special character such as a space, comma, or tab marks the beginning of each column.
Fixed-Width Format
A text file can be stored here where each column starts at the same location in the text file.
Stock Chart
Displays the high, low and closing value of a stock.
Delimiter
A symbol that separates one column of data from another.
Column Break
The point at which one column ends and another begins.
External Data Range
Each location in which a connection is applied.
Refreshes
How excel updates data.
Trusted Location
Excel will access the connection to this data source without prompting you to confirm that the connection is secure.
XML Data Map
Shows the structure if an XML document in a schematic diagram.
Extensible Markup Language (XML)
Structures data in text files that can be read by a wide variety of programs including excel.
Element
Where each of piece of data in an XML document is contained.
Opening Tag
Maks the beginning of the data value.
Closing Tag
Marks the end of the data value.