 |
1 | |
If rows 1 through 5 and columns A through C are frozen and the current cell is H9, what happens if you press  <![CDATA[<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0072834277/138125/ex_07mc_1.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (10.0K)</a>]]>? |
| | 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 |
|