Test 4 A Flashcards Preview

Excel > Test 4 A > Flashcards

Flashcards in Test 4 A Deck (24)
Loading flashcards...
1
Q

Connection

A

A defined process for retrieving data from an external file.

2
Q

Text File

A

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

3
Q

Delimited Text

A

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
Q

Fixed-Width Format

A

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

5
Q

Stock Chart

A

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

6
Q

Delimiter

A

A symbol that separates one column of data from another.

7
Q

Column Break

A

The point at which one column ends and another begins.

8
Q

External Data Range

A

Each location in which a connection is applied.

9
Q

Refreshes

A

How excel updates data.

10
Q

Trusted Location

A

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

11
Q

XML Data Map

A

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

12
Q

Extensible Markup Language (XML)

A

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

13
Q

Element

A

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

14
Q

Opening Tag

A

Maks the beginning of the data value.

15
Q

Closing Tag

A

Marks the end of the data value.

16
Q

Uniform Resource Locator (URL)

A

Provides the location of a webpage.

17
Q

Web Query

A

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

18
Q

Rich Text Format (RTF)

A

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
Q

Ticker Symbols

A

Abbreviations for the stock names used by the market.

20
Q

Office Open XML Format

A

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

21
Q

Rate Function

A

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
Q

NPER Function

A

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
Q

FV Function

A

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

24
Q

PV Function

A

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