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