Test 4 A Flashcards Preview

Excel > Test 4 A > Flashcards

Flashcards in Test 4 A Deck (24):
1

Connection

A defined process for retrieving data from an external file.

2

Text File

Contains only text and numbers without any formulas, graphics, special fonts or formatted texts.

3

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.

4

Fixed-Width Format

A text file can be stored here where each column starts at the same location in the text file.

5

Stock Chart

Displays the high, low and closing value of a stock.

6

Delimiter

A symbol that separates one column of data from another.

7

Column Break

The point at which one column ends and another begins.

8

External Data Range

Each location in which a connection is applied.

9

Refreshes

How excel updates data.

10

Trusted Location

Excel will access the connection to this data source without prompting you to confirm that the connection is secure.

11

XML Data Map

Shows the structure if an XML document in a schematic diagram.

12

Extensible Markup Language (XML)

Structures data in text files that can be read by a wide variety of programs including excel.

13

Element

Where each of piece of data in an XML document is contained.

14

Opening Tag

Maks the beginning of the data value.

15

Closing Tag

Marks the end of the data value.

16

Uniform Resource Locator (URL)

Provides the location of a webpage.

17

Web Query

Specifies which data should be retrieved from different sections of a webpage.

18

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.

19

Ticker Symbols

Abbreviations for the stock names used by the market.

20

Office Open XML Format

Where office 2010 files are stored in an XML based file format.

21

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])

22

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])

23

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])

24

PV Function

The financial function to calculate the present value of a loan or an investment. =pv(rate, nper, pmt [, fv=0] [, type=0])