|
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 |
|
|