Click on the correct response for each question below.
 |
1 | |
Bob Frankston and Dan Bricklin formed a company called Software Arts, Inc. and invented the spreadsheet product |
| | A) | Lotus |
| | B) | Access |
| | C) | VisiCalc |
| | D) | FormCalc |
|
|
2 | |
In Excel, this toolbar contains buttons that execute commands such as Print, Cut, and Insert Table. |
| | A) | Standard |
| | B) | Format |
| | C) | Menu |
| | D) | Forms |
|
|
3 | |
Which of the following is not a correct statement? |
| | A) | A workbook can contain up to 255 worksheets. |
| | B) | A worksheet can contain numeric columns. |
| | C) | Each worksheet contains columns and rows that are labeled with letters and numbers respectively. |
| | D) | A worksheet contains 65,536 rows. |
|
|
4 | |
The name or cell reference of this will appear in the name box and its contents will appear in the formula bar. |
| | A) | Cell reference |
| | B) | Active cell |
| | C) | Worksheet window |
| | D) | Sheet tab |
|
|
5 | |
Pressing this key will move the active cell of a worksheet one to the right. |
| | A) | Right arrow |
| | B) | Tab |
| | C) | Shift |
| | D) | Enter |
|
|
6 | |
This type of worksheet entry documents and identifies important elements in a worksheet. |
| | A) | Value |
| | B) | Text |
| | C) | Menu |
| | D) | Format |
|
|
7 | |
Important worksheet input numbers are |
| | A) | text. |
| | B) | formulas. |
| | C) | functions. |
| | D) | values. |
|
|
8 | |
This computes and displays numeric or text that usually changes when you alter values upon which it depends. |
| | A) | Values |
| | B) | Fields |
| | C) | Formulas |
| | D) | Functions |
|
|
9 | |
A social security number or a telephone number is considered to be this type of entry in a worksheet. |
| | A) | Numeric |
| | B) | Text |
| | C) | Value |
| | D) | Formula |
|
|
10 | |
This consists of one or more cells that form a rectangular group in a worksheet. |
| | A) | Cell reference |
| | B) | Cell formula |
| | C) | Cell value |
| | D) | Cell range |
|
|
11 | |
The menu bar is visible at all times while working in Microsoft Excel 2003. |
| | A) | True |
| | B) | False |
|
|
12 | |
The bold, underline, and italics attributes are set using buttons on the Formula toolbar. |
| | A) | True |
| | B) | False |
|
|
13 | |
Cells within a worksheet can contain text, values (constants), formulas, functions, and a combination of these. |
| | A) | True |
| | B) | False |
|
|
14 | |
When opening a workbook, Excel reads a copy of the file into your computer's memory (RAM). |
| | A) | True |
| | B) | False |
|
|
15 | |
Formulas are predefined functions that provide a shortcut to entering complex calculations. |
| | A) | True |
| | B) | False |
|
|
16 | |
When entering data in a worksheet, text will appear in both the formula bar and active cell. |
| | A) | True |
| | B) | False |
|
|
17 | |
Functions contain values and return arguments. |
| | A) | True |
| | B) | False |
|
|
18 | |
The SUM function may contain multiple cell ranges. |
| | A) | True |
| | B) | False |
|
|
19 | |
To clear the contents of the active cell, simply press the SPACEBAR on your keyboard. |
| | A) | True |
| | B) | False |
|
|
20 | |
Formulas that reference empty cells use zero within their calculations because blank cells equate to zero. |
| | A) | True |
| | B) | False |
|