I. Name box A. 3
II. Formula bar B. 1
III. Ribbon C. 4
IV. Menu bar D. 2
Exam
Name___________________________________
| MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. | ||
| 1) | All ________ in Excel begin with an equal (=) sign. | 1) ______ |
| A) dates | |
| B) Macros | |
| C) textual phrases | |
| D) formulas |
| 2) | A cell that has been commented has a(n) ________ triangle. | 2) ______ |
| A) green | |
| B) red | |
| C) outlined | |
| D) yellow |
| 3) | By default, a new Excel workbook has three: | 3) ______ |
| A) pages. | |
| B) colors. | |
| C) cells. | |
| D) worksheets. |
| 4) | Excel has predefined ________ that can be used to produce calculated results. | 4) ______ |
| A) formulas | |
| B) programs | |
| C) procedures | |
| D) macros |
| 5) | Worksheet names are displayed on: | 5) ______ |
| A) sheet tabs. | |
| B) the title bar. | |
| C) the task bar. | |
| D) ribbons. |
| 6) | The power of Excel are its functions and ________ which enable accurate and quick calculations. | 6) ______ |
| A) charts | |
| B) formats | |
| C) styles | |
| D) formulas |
| 7) | ________ can be one cell or a group of cells. | 7) ______ |
| A) Formulas | |
| B) Macros | |
| C) Cell ranges | |
| D) Functions |
| 8) | A formula in Excel begins with a(n): | 8) ______ |
| A) *. | |
| B) /. | |
| C) =. | |
| D) $. |
| 9) | Parameters in an IF function can be ________, a value, a formula, or a nested function. | 9) ______ |
| A) text | |
| B) wildcards | |
| C) syntax | |
| D) arguments |
| 10) | The ________ of a worksheet should be established before development begins. | 10) ______ |
| A) size | |
| B) purpose | |
| C) number of pages | |
| D) style |
| 11) | Values used in calculations in functions are: | 11) ______ |
| A) arguments. | |
| B) procedures. | |
| C) formulas. | |
| D) macros. |
| 12) | =$E2+C3-G$4 is an example of a(n) ________ cell reference. | 12) ______ |
| A) absolute | |
| B) mixed | |
| C) constant | |
| D) relative |
| 13) | The fill handle can be used to copy formulas or finish a(n) ________ series. | 13) ______ |
| A) cell | |
| B) text | |
| C) object | |
| D) date |
| 14) | To copy a formula across a range of cells and have the formula automatically update the cell row and column, use ________ cell referencing. | 14) ______ |
| A) abstract | |
| B) relative | |
| C) absolute | |
| D) mixed |
| 15) | The ________ command is used to center text within one cell so that it displays appropriately across the content of a worksheet. | 15) ______ |
| A) Horizontal | |
| B) Center | |
| C) Merge and Center | |
| D) Merge |
| TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. | ||
| 16) | If a label in a cell is too long, widening the cell is the other way to display all of the text. | 16) ______ |
| 17) | A quick way to rename a worksheet is to double-click the sheet tab name. | 17) ______ |
| 18) | Text can only be centered across one cell. | 18) ______ |
| 19) | AutoFill is used to add color to a series of cells. | 19) ______ |
| 20) | Calculations in Excel are NOT affected by mathematical precedence. | 20) ______ |
| SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question. | ||
| 21) |
Match the following terms to their menu item: I. Name box A. 3 II. Formula bar B. 1 III. Ribbon C. 4 IV. Menu bar D. 2 | 21) ______ |
| 22) | The ________ cell is surrounded by a dark border. | 22) ______ |
| 23) |
Match the following five terms to their purpose on a worksheet: I. active cell A. identifies row and column II. cell reference B. intersection of a row and column III. cell C. ready for text IV. fill handle D. used to copy formulas V. sheet tab E. navigate workbook | 23) ______ |
| 24) | The rule that multiplication is performed before addition is referred to as ________. | 24) ______ |
| 25) | If you have the formula =A1 + C3 in cell C4 and C4 is the active cell, the cell reference of the cell that contains the formula will display in the ________. | 25) ______ |