Flashcards in Test 4 A Deck (24):
A defined process for retrieving data from an external file.
Contains only text and numbers without any formulas, graphics, special fonts or formatted texts.
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.
A text file can be stored here where each column starts at the same location in the text file.
Displays the high, low and closing value of a stock.
A symbol that separates one column of data from another.
The point at which one column ends and another begins.
External Data Range
Each location in which a connection is applied.
How excel updates data.
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.
Where each of piece of data in an XML document is contained.
Maks the beginning of the data value.
Marks the end of the data value.
Uniform Resource Locator (URL)
Provides the location of a webpage.
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.
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.
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])
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])
The function used to calculate the future value of of a loan or an investment. =FV(rate, nper, pmt [, pv=0] [, type=0])