Excel Chapter 2 Test Review

Name:

Evaluate responses using AI:

OFF

1. When writing your own formulas, you must begin each formula with

• a quotation mark (").
• an equals sign (=).
• a colon (:).
• an asterisk (*).

2. Indicate what the following formula will do: =B2/C2.

• It will multiply the contents of cell B2 by the contents of cell C2.
• It will display the text “B2/C2” in the active cell.
• It will divide the contents of cell B2 by the contents of cell C2.
• It will divide the contents of cell C2 by the contents of cell B2.

3. After typing a formula into a cell, you can finish by pressing any of the following keys except

• Shift + Tab.
• Tab.
• Enter
• Spacebar

4. Copy a formula relatively in a worksheet using the Fill button. The Fill button is located in the _____ group on the _____ tab.

• Formula Auditing; Formulas
• Cells; Home
• Calculation; Formulas
• Editing; Home

5. The Cell Address is also known as the ?

• Cell Indicator
• Name Box
• Cell Range
• Cell Reference

6. If you enter the formula =SUM(A2:C2) in cell D2, what will happen if you copy it to cell D3?

• The formula will change to =SUM(A3:C3).
• The formula will change to =SUM(B3:D3).
• The formula will change to =SUM(B2:D2).
• The formula will not change.

7. To copy data or formulas using the fill handle, first position the mouse pointer on the desired fill handle until it turns into a

• pointing hand.
• thin black cross
• double-headed arrow point left and right
• clipboard icon

8. When creating a formula by pointing to cell references instead of typing them, what happens to the cell to which you are pointing?

• The cell is shaded yellow.
• A temporary moving border is placed around the cell.
• The cell contents are displayed in a bold font.
• The cell background is shaded gray and the text is dimmed.

9. When writing a formula by pointing, how do you end the formula?

• Click in an empty cell.
• Double-click the active cell.
• Press the Esc key.
• Press the Enter key.