| A | B |
|---|
| An Excel _____ allows data to be summarized and charted easily. | Worksheet |
| The _____ box displays the active cell reference. EX6 | Name |
| When you begin typing a cell entry, Excel displays two additional boxes in the formula bar: _____. EX 7 | the Cancel box and the Enter box |
| The _____ feature of Excel works behind the scenes, correcting common mistakes when you complete a text entry in a cell. EX 9 | AutoCorrect |
| When you enter numeric data in a cell, Excel recognizes the values as numbers and _____ the values. EX 13 | Right-aligns |
| A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells. EX 14 | Range |
| A preceding _____ alerts Excel that you are entering a formula or function and not text. EX 20 | Equal Sign |
| Font size is gauged by a measurement system called _____. EX 23 | Points |
| 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. EX50 | Insert |
| The _____ command on the Clear menu is the only command that clears both the cell entry and the cell formatting. EX52 | Clear All |
| A formula in a cell that contains a reference back to itself is called a(n) _____ reference. EX73 | Circular |
| If the following arithmetic operations all are found in a formula with no parentheses, which one is completed last? EX75 | + |
| When you copy a formula with a relative cell reference down a row, _____. EX 78 | the row references change in the formula |
| The _____ function is used to determine the lowest number in a given range. EX 84 | MIN |
| To assign a dollar sign to appear immediately to the left of the first digit with no spaces, use a _____ dollar sign. EX 99 | Floating |
| Which of the following is a valid conditional formatting operator found in the New Formatting Rule dialog box? EX 103 | Greater than |
| A dot on the screen that contains a color is called a _____. EX 103 | Pixel |
| Excel includes a(n) _____ you can use to check a worksheet for spelling errors. EX 107 | Spell Checker |
| A(n) _____ is text and graphics that print at the bottom of each page. EX 110 | Footer |
| The _____ version of a worksheet shows the results of formulas. EX 115 | Values |
| _____ are values in cells that you can change to determine new values for formulas. EX 130 | Assumptions |
| The _____ is a temporary storage area in the computer’s memory that allows you to collect text and graphics from an Office document and then paste them into almost any other type of document. EX 141 | Office Clipboard |
| Valid format symbols include all of the following EXCEPT _____. EX 147 | + |
| A _____ shows the date a workbook, report, or other document was created or the time period it represents. EX 148 | Date Stamp |
| A formula using the _____ cell reference B4 instructs Excel to adjust the cell reference as it copies it to the destination area. EX 151 | Relative |
| Excel displays the error message _____ in cells that are not wide enough to display entire entry. EX 157 | ##### |
| An Excel _____ chart provides a simple way to show trends and variations in a range of data within a single cell. EX 160 | Sparkline |
| The _____ feature evaluates the selected data and makes suggestions regarding which chart types will provide the most suitable representation. EX 171 | Recommended Charts |
| When you _____ a worksheet, Excel enlarges the view of the characters on the screen, but displays fewer columns and rows. EX 182 | Freeze |
| When working with a large worksheet, you can split the window into two or four _____ to view different parts of the worksheet at the same time. EX 184 | Panes |
