 |
| 1 | |
Which character separates arguments in a function? |
| | A) | / (forward slash) |
| | B) | \ (backward slash) |
| | C) | ; (semicolon) |
| | D) | , (comma) |
|
|
|
| 2 | |
In which view does a page break appear as a black dashed line on the screen? |
| | A) | Normal |
| | B) | Page Break Preview |
| | C) | Page Layout |
| | D) | Custom |
|
|
|
| 3 | |
Which of the following arguments in a financial function indicates the interest for a period? |
| | A) | FV |
| | B) | PV |
| | C) | Nper |
| | D) | Rate |
|
|
|
| 4 | |
Which of the following arguments in a financial function represents the total number of payments? |
| | A) | FV |
| | B) | PV |
| | C) | Nper |
| | D) | Rate |
|
|
|
| 5 | |
What category of functions is used in this formula? =PMT(C10/12,C8,C9,1) |
| | A) | Logical |
| | B) | Financial |
| | C) | Payment |
| | D) | Statistical |
|
|
|
| 6 | |
When Extend Selection is active, what is the keyboard shortcut for selecting all data up to and including the last row? |
| | A) | [Ctrl]+[Down Arrow] |
| | B) | [Ctrl]+[Home] |
| | C) | [Ctrl]+[Shift] |
| | D) | [Ctrl]+[Up Arrow] |
|
|
|
| 7 | |
Which formula would result in TRUE if C4 is less than 10 and D4 is less than 100? |
| | A) | =AND(C4>10, D4>10) |
| | B) | =AND(C4>10, C4<100) |
| | C) | =AND(C4>10, D4<10) |
| | D) | =AND(C4<10, D4<100) |
|
|
|
| 8 | |
Which of these is not an argument of the IF function? |
| | A) | Logical_test |
| | B) | Value_if_false |
| | C) | Value_when_false |
| | D) | Value_if_true |
|
|
|
| 9 | |
In what cell is the Rate for this function? |
| | A) | C8 |
| | B) | C9 |
| | C) | C10 |
| | D) | C12 |
|
|
|
| 10 | |
Except for IF and IFERROR, what results from a logical function? |
| | A) | YES and NO |
| | B) | TRUE and FALSE |
| | C) | Calculated value |
| | D) | Arithmetic value |
|
|
.