 |
1 | |
The syntax for the PMT function is which of the following? |
|
| | A) | PMT(nper,rate,pv) |
| | B) | PMT(pmt,rate,nper) |
| | C) | PMT(rate,nper,pv) |
| | D) | PMT(pv,rate,nper) |
|
2 | |
Which of the following functions is used to calculate the periodic payment on a loan? |
|
| | A) | RATE |
| | B) | PMT |
| | C) | PAY |
| | D) | LN |
|
3 | |
Which of the following is not an argument of the PMT function? |
|
| | A) | interest rate |
| | B) | amount of the loan |
| | C) | number of loan payments |
| | D) | loan payment amount |
|
4 | |
If the annual percentage rate of a loan is 12% and you are trying to find the monthly payment, then the rate argument would be what? |
|
| | A) | .1 |
| | B) | 12 |
| | C) | .12 |
| | D) | .01 |
|
5 | |
This function allows you to launch web searches directly from within Excel. |
|
| | A) | Web |
| | B) | Research |
| | C) | Google |
| | D) | SurfNet |
|
6 | |
To open the Research task bar, choose |
|
| | A) | View/Toolbars/Research |
| | B) | Tools/Web |
| | C) | Tools/Research |
| | D) | Edit/Find/On The Web |
|
7 | |
When you use the Research task pane to open a hyperlink, the web page opens in what program? |
|
| | A) | Excel |
| | B) | Internet Explorer |
| | C) | your default browser |
| | D) | Netscape Communicator |
|
8 | |
In Excel, this is used to quickly calculate multiple what-if versions in one operation and to view the results of all variations together in a worksheet. |
|
| | A) | Data table |
| | B) | Argument |
| | C) | Solver |
| | D) | Scenario |
|
9 | |
In Excel, this can contain one or more formulas, with each formula referring to one input cell. |
|
| | A) | Multi-variable data table |
| | B) | Unrestricted data table |
| | C) | One-variable data table |
| | D) | Open data table |
|
10 | |
In a data table, this is a cell in which a list of values is substituted to see the resulting effect on the related formulas. |
|
| | A) | Formula cell |
| | B) | Input cell |
| | C) | What-if cell |
| | D) | Data cell |
|
11 | |
The PMT function calculates a periodic payment on a loan. |
|
| | A) | TRUE |
| | B) | FALSE |
|
12 | |
The Insert Function feature can be used to help enter the PMT function in Excel. |
|
| | A) | TRUE |
| | B) | FALSE |
|
13 | |
By default, all web searches from within Excel are returned by Excite. |
|
| | A) | TRUE |
| | B) | FALSE |
|
14 | |
A chart is a range of cells that is used to quickly calculate multiple what-if versions in one operation. |
|
| | A) | TRUE |
| | B) | FALSE |
|
15 | |
A two-variable data table uses only one formula that refers to two different input cells, one column-oriented and one row-oriented. |
|
| | A) | TRUE |
| | B) | FALSE |