|
1 | | If rows 1 through 5 and columns A through C are frozen and the current cell is H9, what happens if you press (10.0K)? |
| | A) | you get an error message |
| | B) | the active cell becomes D6 |
| | C) | the active cell becomes C5 |
| | D) | the active cell becomes A1 |
| | E) | the active cell becomes B4 |
|
|
2 | | How would you change the page break position for an Excel spreadsheet? |
| | A) | in the page break preview, drag the break line to a new position |
| | B) | choose Edit, Page Break, fill in break point box with the row number |
| | C) | choose Insert, Page Break, fill in break point box with the row number |
| | D) | choose Format, Page Break, fill in break point box with the row number |
| | E) | in the normal view, drag the break line to a new position |
|
|
3 | | In a large worksheet, Excel performs searches faster if you place the cell pointer: |
| | A) | anywhere in column A |
| | B) | in cell A1 |
| | C) | at the top of the desired search column |
| | D) | anywhere in the last row containing data |
| | E) | anywhere in the last column containing data |
|
|
4 | | Hyperlinks inserted in an Excel workbook that have been activated recently will appear as: |
| | A) | green and underlined |
| | B) | blue and underlined |
| | C) | purple and underlined |
| | D) | blue |
| | E) | purple |
|
|
5 | | What is used to increase the size of the comment text box? |
| | A) | Selection handle |
| | B) | Sizing handle |
| | C) | Rotation handle |
| | D) | Adjustment handle |
| | E) | Double-clicking on the border of the text box |
|