Term
| The ____ value calculates the future value of a loan or an investment. |
|
Definition
|
|
Term
| The ____ function calculates the present value of a loan or an investment. |
|
Definition
|
|
Term
| A ______ _____ ____ is a negative value that represents cash going away from the investor |
|
Definition
|
|
Term
| Negative Cash Flow is also known as |
|
Definition
|
|
Term
| The ______ function calculates the per period interest rate required to pay off a loan or reach an investment goal |
|
Definition
|
|
Term
| A ______ ______ ____ is a positive value that represents money coming to the investor |
|
Definition
|
|
Term
| Positive cash flow is also known as |
|
Definition
|
|
Term
| The _____ function calculates the payment in each period required to pay off a loan or reach an investment goal. |
|
Definition
|
|
Term
| The ______ function calculates the number of payments required to pay off a loan or reach an investment goal |
|
Definition
|
|
Term
| An ________ _________ provides the schedule of payments used to pay off a loan |
|
Definition
|
|
Term
| The _____ function calculates the amount of a loan payment applied to the principal. |
|
Definition
|
|
Term
| The _____ functions calculates the amount of a loan payment used to pay off the interest |
|
Definition
|
|
Term
| The _____ functions automatically format calculated values as currency |
|
Definition
|
|
Term
| Negative cash flows appear in a _____ font within parentheses |
|
Definition
|
|
Term
| Cell Style is located in the _____ group of the _____ tab |
|
Definition
|
|
Term
| you can insert the PMT function and view its arguments and meanings with the _______ _______ and Function Arguments dialog boxes by clicking the ________ _________ button on the formula bar |
|
Definition
|
|
Term
| If the _____ function returns #NUM!,the loan cannot be repaid in any length of time. This occurs when the monthly payments are less than the monthly interest charges, making it impossible to repay the loan. |
|
Definition
|
|
Term
| To calculate an annual rate, multiply the value returned by the ____ function by the number of payments per year. For monthly payments, multiply the rate value by 12 |
|
Definition
|
|
Term
| In an ______ schedule, use absolute reference to refer to the original loan conditions and use relative references to refer to information about specific payment periods. |
|
Definition
|
|
Term
| A table of red values enclosed in parentheses can be difficult to read. ______ schedules often format all entries as positive values, and then label the columns to indicate the values represent negative cash flows |
|
Definition
|
|
Term
| A _____ _____ contains only text and numbers without any formulas, graphics, special fonts, or formatted text |
|
Definition
|
|
Term
| Text files can be stored as _______ _____ in which a special character such as a space, comma, or tab marks the beginning of each column. |
|
Definition
|
|
Term
| A text file can also be stored in a ____-____ ______ where each column starts at the same location in the text file |
|
Definition
|
|
Term
| The _____ tab contains commands for retrieving and refreshing data from external sources. |
|
Definition
|
|
Term
| The _____ _____ dialog box lists all of the connections in the workbook. |
|
Definition
|
|
Term
| A ____ is a defined process for retrieving data from an external file. |
|
Definition
|
|
Term
| A ____ ___ displays the high, low, and closing value of a stock. |
|
Definition
|
|
Term
| The ____ ____ dialog box defines how and when connections to external data sources are retrieved and updated. |
|
Definition
|
|
Term
| In delimited text, a ____ ____ separates one column from another. |
|
Definition
|
|
Term
| In delimited text, a _____ or ____ separates columns |
|
Definition
|
|
Term
| In fixed-width text, each column entry begins at the _____ point in the text file. |
|
Definition
|
|
Term
| The From Text button is located in the ____ tab in the Get External _____ group |
|
Definition
|
|
Term
(keyboard shortcut)
Select all the cell that is after the active cell |
|
Definition
|
|
Term
| To resize a chart, hold ____ while dragging a corner of the chart |
|
Definition
|
|
Term
| The Chart Title button can be located in the Chart Tools _______ tab, in the ______ group |
|
Definition
|
|
Term
| To delete a connection to its data source,select the connection in the _____ _____ dialog box, and then click the Remove button |
|
Definition
|
|
Term
| The connections button is located in the _____ tab |
|
Definition
|
|
Term
| The Properties button for Connections is located in the _____ tab |
|
Definition
|
|
Term
| Check the _____ external data from worksheet before closing check box to remove the external data when the file is closed, which reduces the file size, and retrieve the data when the file is reopened. |
|
Definition
|
|
Term
| The Trust Center can be located in the _____ tab, under _____ |
|
Definition
|
|
Term
| You start the Microsoft Query Wizard by clicking the _____ ____ ____ button, and then clicking from Microsoft Query. |
|
Definition
|
|
Term
| A _____ stores information about a specific characteristic of a person,place or thing. |
|
Definition
|
|
Term
| A _______ displays a collection of characteristics of a particular person, place, or thing. |
|
Definition
|
|
Term
| Different tables are combined using a ____ _____, which is a field that is present in both tables |
|
Definition
|
|
Term
| A ______ is a collection of data values organized in a way so that they can be easily retrieved and manipulated by the end user. |
|
Definition
|
|
Term
| Databases are stored in _____, a collection of data values arranged in rows or records and columns or fields |
|
Definition
|
|
Term
| _____ _____ retrieves data from multiple database tables and stores the data values in an Excel workbook. The query is created in the wizard by displaying four dialog boxes in sequence |
|
Definition
|
|
Term
| A _____ is a set of guidelines that specify what values to retrieve from a database and in what order the values should be retrieved. |
|
Definition
|
|
Term
| _____ tables can be inserted directly into PivotCharts and PivotTables |
|
Definition
|
|
Term
| _____ ______ allows you to retrieve data from multiple tables |
|
Definition
|
|
Term
| To detach an Excel table from its data source, select a cell in the table, click the Table Tools Design tab, and then, in the External Table Data group, click the ______ button |
|
Definition
|
|
Term
| A _____ _____ specifies which data should be retrieved from different sections of a Web page |
|
Definition
|
|
Term
| An _____ ____ ____ shows the structure of an XML document in a schematic diagram. |
|
Definition
|
|
Term
| Dragging an element from the data map to a cell ______ that XML value to the cell |
|
Definition
|
|
Term
| _______ _______ ______ structures data in text files that can be read by a wide variety of programs, including Excel |
|
Definition
| Extensible Markup Language |
|
|
Term
| Each piece of data in an XML document is contained within an ______, which includes an opening tag, the element content, and a closing tag. |
|
Definition
|
|
Term
| The _____ _____ marks the end of the data value |
|
Definition
|
|
Term
| The _____ content is the actual data. |
|
Definition
|
|
Term
| The ____ ____ marks the beginning of the data value |
|
Definition
|
|
Term
| To map an XML document directly into an Excel table, click the _____ ____ _____ button in the Get External Data group on the Data tab, and then click from XML Data Import |
|
Definition
|
|
Term
| A ______ is usually a space, comma, or tab that separates one column of data from another |
|
Definition
|
|
Term
| The point at which one column ends and another begins is called a _____ _____ |
|
Definition
|
|
Term
| To connect to a text file, use the _____ ______ ______ |
|
Definition
|
|
Term
| In addition to setting the name of an external data range, you can also define how Excel updates, or ______, the data. |
|
Definition
|
|
Term
| To manually refresh a data range: In the ____ group on the ____ tab, click the Refresh All button |
|
Definition
|
|
Term
| To automatically refreah a data range: Select any cell in the data range, and click the Properties button in the _____ group on the _____ tab |
|
Definition
|
|
Term
| To manually refresh a connection: In the _____ group on the _____ tab, click the Connection button |
|
Definition
|
|
Term
| To automatically refresh a connection: In the _____ group on the ___ tab, click the Connection button, and then click the Properties button. |
|
Definition
|
|
Term
| A ____ ____ is a data source where Excel will NOT prompt you to confirm that the connection is secure |
|
Definition
|
|
Term
| The _____ is the amount of the loan that is still unpaid. |
|
Definition
|
|
Term
| The Grand Totals button is in the Layout group of the ____ ___ ____ tab |
|
Definition
|
|
Term
| to load the data map for the Data.xml file. Click the ____ tab on the ribbon and then click the _____ button in the XML group. |
|
Definition
|
|
Term
| To map an XML document directly into an Excel table, click in the _____ _____ _____ group on the Data tab, and then click from XML Data Import |
|
Definition
|
|
Term
| When using PPMT and IPMT, payments must be _____ |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
Excel can Import data from:
a. databases and files
b. data with Microsoft query
c. data from the World Wide Web
d. All of the above |
|
Definition
|
|
Term
True or False?
With Excel and an Internet connection, you can get current stock quotes provided by MSN Money Central Investor Stock Quotes. |
|
Definition
|
|
