Take Test: EXAM TWO
Content
Top of Form
Assistive Technology Tips [opens in new window]
Instructions
| Timed Test | This test has a time limit of 1 hour.You will be notified when time expires, and you may continue or submit. Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain. |
| Multiple Attempts | Not allowed. This test can only be taken once. |
| Force Completion | This test can be saved and resumed later. The timer will continue to run if you leave the test. |
 Question Completion Status:
Question 1
- The _________function is used to calculate loan payments
| PMT | ||
| LOAN | ||
| FV | ||
| AMORT |
4 points  Â
Question 2
- The MINIMUM function is included in the ___________category of functions’
| Statistical | ||
| Financial | ||
| Date and Time | ||
| Logical |
4 points  Â
Question 3
- The value within a cell range for which there are an equal number of values above and below it is called the:
| Average | ||
| Median | ||
| Middle | ||
| half-way pointg |
4 points  Â
Question 4
- The Margins tab is found in the _______________dialog box.
| Insert Function | ||
| Save As | ||
| Page Setup | ||
| Margin Settings |
4 points  Â
Question 5
- The Pmt function argument of the FV function represents the:
| intitial payment of the investment. | ||
| number of payment periods that will be used | ||
| type of payment that will be made | ||
| amount of money paid out per payment period. |
4 points  Â
Question 6
- The rules for combining a function”s equal sine, the name and the argumnets is called its:
| logical operation | ||
| median | ||
| syntax | ||
| decision point |
4 points  Â
Question 7
- The Function Arguments dialog box associated with the DATE functions contains____ box(es) for user input.
| one | ||
| two | ||
| three | ||
| four |
4 points  Â
Question 8
- In order to indicate that a cell contains a formula or functin, you must begin typing a(an):
| cell reference | ||
| equal sign | ||
| quote mark | ||
| argument |
4 points  Â
Question 9
- The formula =(A1+A2+A3+A4)/4 is equivalent to the function:
| =SUM(A1:A4) | ||
| =MEDIAN(A1:A4) | ||
| =AVERAGE(A1:A4) | ||
| =COUNT(A1:A4) |
4 points  Â
Question 10
- Which box of the IF function’s Function Argument dialog box will contain expression that evaluates to a TRUE value?
| Value_if_true | ||
| Logical_test | ||
| Formula_result |
4 points  Â
Question 11
| Nper | ||
| Rate | ||
| Pv | ||
| Type |
4 points  Â
Question 12
- All of the following operations can be used to invoke the Inert Function dialog box EXCEPT:
| Selecting the Insert Function menu option, | ||
| Typing a function into the formula bar. | ||
| Clicking the button marked fx next to the formula bar. | ||
| Selecting More Functions from the AutoSum button list. |
4 points  Â
Question 13
- How many categories of functions does Excel support?
| Three | ||
| Six | ||
| Fourteen | ||
| Twelve |
4 points  Â
Question 14
- When invoking the MAX function from the Insert Function dialog box, the Function Arguments dialog box will initially display ________________ Number box(es).
| One | ||
| Two | ||
| three | ||
| four |
4 points  Â
Question 15
- What formula is most like =SUM(A1:A4):
| =A1+A4 | ||
| =A1+A2+A3+A4 | ||
| =1+2+3+4 | ||
| =AVG(A1:A) |
4 points  Â
Question 16
- Which of the following FV function arguments must be a negative number and is the present value of a lump sum amount?
| Nper | ||
| Rate | ||
| Pv | ||
| Type |
4 points  Â
Question 17
- The interest rate that should be applied to the PMT function should be:
| always annual | ||
| always monthly | ||
| based on the desired future value | ||
| based on the payment schedule |
4 points  Â
Question 18
- In the function =SUM(A1:A5), the portion inside the parenthesis is called the function:
| argument | ||
| syntax | ||
| property | ||
| value |
4 points  Â
Question 19
- The IF logical function has_________________arguments
| one | ||
| two | ||
| three | ||
| four |
4 points  Â
Question 20
- If you click the button marked FX that appears to the left of the Formula Bar, this causes:
| a formula to be calculated | ||
| the Function Argumnets dialog to appeaqr | ||
| the Insert Function dialog to appear | ||
| the most recently used function to be inserted into the Formula Bar. |
4 points  Â
Question 21
- Which of the following can contain a cell range that the user selects by clicking and dragging on a group of cells while the dialog is displayed?
| The Function Arguments dialog box’s Number1 box | ||
| The Insert Function’s dialog box Search for a function box | ||
| The Define Name dialog box’s Refers to box. | ||
| The Insert Function’s dialog box’s Select a function list |
4 points  Â
Question 22
- Using the DATE function, you should use the syntax ________________to display the date September, 25, 2006.
| =DATE(September,25,2006) | ||
| =DATE(9,25,2006) | ||
| =DATE(9/5/2006) | ||
| =DATE(2006,9,25) |
4 points  Â
Question 23
- Which types of cells will be included in the COUNT function’s calculations?
| Text | ||
| Logical | ||
| Blank | ||
| Numeric |
4 points  Â
Question 24
- The ________________argument of the FV function controls whether the payment will be made in the beginning or the end of a payment period.
| Pmt | ||
| Nper | ||
| Type | ||
| Pv |
4 points  Â
Question 25
- The FV function is in the _____________category of functions.
| Statistical | ||
| Logical | ||
| Date and Time | ||
| Financial |
