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.
Uniform Resource Locator (URL)
Provides the location of a webpage.
Web Query
Specifies which data should be retrieved from different sections of a webpage.
Rich Text Format (RTF)
A file format that allows for text formatting styles including boldface, italic and color but not advance features such as hyperlinks or complicated table structures.
Ticker Symbols
Abbreviations for the stock names used by the market.
Office Open XML Format
Where office 2010 files are stored in an XML based file format.
Rate Function
The financial function to calculate the per period interest rate required to pay off a loan or reach a goal. =rate(nper, pmt, pv [, fv=0] [, type=0])
NPER Function
The financial function used to calculate the number of payments required to pay off a loan or reach an investment goal. =NPER (rate, pmt, pv [, fv=0] [, type=0])
FV Function
The function used to calculate the future value of of a loan or an investment. =FV(rate, nper, pmt [, pv=0] [, type=0])
PV Function
The financial function to calculate the present value of a loan or an investment. =pv(rate, nper, pmt [, fv=0] [, type=0])
