Computer Sci test 3 (with Complete Solutions)

An Excel ___ allows data to be summarized and charted easily. correct answers a. worksheet 2. The _____ box displays the active cell reference correct answers d. Name 3. When you begin typing a cell entry, Excel displays two additional boxes in the formula bar: _____. correct answers c. the Cancel box and the Enter box 4. The _____ feature of Excel works behind the scenes, correcting common mistakes when you complete a text entry in a cell. correct answers b. AutoCorrect 5. When you enter numeric data in a cell, Excel recognizes the values as numbers and _____ the values. correct answers a. right-aligns 6. A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells. correct answers d. range 7. A preceding _____ alerts Excel that you are entering a formula or function and not text. correct answers a. equal sign 8. Font size is gauged by a measurement system called _________ correct answers d. points 9. In _____ mode, as you type a character, Excel inserts the character and moves all characters to the right of the typed character one position to the right. correct answers c. Insert 10. The _____ command on the Clear menu is the only command that clears both the cell entry and the cell formatting. correct answers b. Clear All 1. A formula in a cell that contains a reference back to itself is called a(n) _____ reference. correct answers d. circular 2. If the following arithmetic operations all are found in a formula with no parentheses, which one is completed last? correct answers a. + 3. When you copy a formula with a relative cell reference down a row, _____. correct answers a. the row references change in the formula 4. The _____ function is used to determine the lowest number in a given range. correct answers c. MIN 5. To assign a dollar sign to appear immediately to the left of the first digit with no spaces, use a _____ dollar sign correct answers b. floating 6. Which of the following is a valid conditional formatting operator found in the New Formatting Rule dialog box? correct answers d. Greater than