|
1 | | Number entries can include any combination of letters, numbers, spaces, and any other special characters. |
| | A) | True |
| | B) | False |
|
|
|
2 | | A text entry that is larger than the column width will be fully displayed only if the cells to the right are blank. |
| | A) | True |
| | B) | False |
|
|
|
3 | | The thesaurus is a reference tool that provides synonyms, antonyms, and related words for a selected word or phrase. |
| | A) | True |
| | B) | False |
|
|
|
4 | | A function is a prewritten formula that performs certain types of calculations automatically. |
| | A) | True |
| | B) | False |
|
|
|
5 | | Horizontal placement allows you to specify whether the cell contents are displayed at the top, the bottom, or the center. |
| | A) | True |
| | B) | False |
|
|
|
6 | | The _____ feature makes some basic assumptions about the text you are typing and, based on these assumptions, automatically corrects the entry. |
| | A) | AutoCorrect |
| | B) | Undo |
| | C) | AutoFormat |
| | D) | Excel Wizard |
|
|
|
7 | | The spelling checker feature works by comparing each word to a dictionary of words, called the _____ dictionary, which is supplied with the program. |
| | A) | Primary |
| | B) | Initial |
| | C) | Default |
| | D) | Main |
|
|
|
8 | | A selection consisting of two or more cells on a worksheet is a(n) |
| | A) | Area |
| | B) | Name |
| | C) | Range |
| | D) | Unit |
|
|
|
9 | | A formula always begins with what? |
| | A) | + |
| | B) | = |
| | C) | - |
| | D) | ( |
|
|
|
10 | | Copying the formula =SUM(A1:A5) from cell A6 to cell B6 will result in what formula for cell B6? |
| | A) | =SUM(A1:B6) |
| | B) | =SUM(B6:A6) |
| | C) | =SUM(B1:B5) |
| | D) | =SUM(B1:A5) |
|
|