|
1 | | An absolute reference is a cell or range reference in a formula whose location does not change when the formula is copied. |
| | A) | True |
| | B) | False |
|
|
|
2 | | The Find command locates all occurrences of the text or numbers you specify. |
| | A) | True |
| | B) | False |
|
|
|
3 | | The multiple instances feature allows you to divide a worksheet window into sections, making it easier to view different parts of the worksheet at the same time. |
| | A) | True |
| | B) | False |
|
|
|
4 | | What-if analysis is a technique used to evaluate the effects of changing selected factors in a worksheet. |
| | A) | True |
| | B) | False |
|
|
|
5 | | AutoFormat changes the appearance of a range of cells based on a condition that you specify. |
| | A) | True |
| | B) | False |
|
|
|
6 | | Which of the following is not a rule for creating sheet names? |
| | A) | Can be up to 31 characters. |
| | B) | Cannot contain the characters : ? * / \. |
| | C) | Can only be lowercase |
| | D) | Can contain any combination of letters, numbers, and spaces. |
|
|
|
7 | | If you select a range of cells containing the values: 1,2,3 and use the Fill Handle to extend the series by three cells, the value of these three cells will be what? |
| | A) | 3,3,3 |
| | B) | 3,2,1 |
| | C) | 1,2,3 |
| | D) | 4,5,6 |
|
|
|
8 | | If you want to use the same cell or range of cells on multiple sheets, you can use a(n) |
| | A) | Entry cell |
| | B) | 3-D reference |
| | C) | Named range |
| | D) | Cell link |
|
|
|
9 | | The _____ tool is used to find the value needed in one cell to attain a result you want in another cell. |
| | A) | Goal Seek |
| | B) | Reference Checker |
| | C) | Expected Value |
| | D) | Formula Evaluation |
|
|
|
10 | | To keep the data in one or more columns from scrolling, you can _____ the panes. |
| | A) | Remove |
| | B) | Hide |
| | C) | Freeze |
| | D) | Lock |
|
|