## 50 terms

### The formulas version verifies that you entered formulas, rather than ____, in formula-based cells.

Numbers

### ____ means that the width of the column will be increased or decreased so the widest entry will fit in the column.

Best Fit

### A formula using the ____ cell reference B20 instructs Excel to adjust the cell reference as it copies it to the destination area.

Relative

### If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on which the formula depends.

Goal Seeking

### If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on which the formula depends.

Sheet1

### Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ____.

What-if Analysis

### The AVERAGE function requires that the argument (the range) be included within parentheses before the function name.

False

### The ____ of the worksheet shows the actual formulas you have entered, rather than the resulting values.

Formulas Version

### A __________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.

range

### If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series.

Dec/Inc

### To toggle between the values version and the formulas version of a worksheet, hold down the ____ key.

CTRL key while pressing the ACCENT MARK (`)

### In the accompanying figure, if you enter 90 in the Degrees box in the Orientation area, the text will appear ____.

vertically and read from bottom to top in the cell

### When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

NOW

### A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Nested

### Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after arithmetic operators.

False

### When a formula is copied, Excel adjusts the cell references so the new formulas contain references corresponding to the new location and performs calculations using the appropriate values.

True

### To start a new line in a cell, press ____ after each line, except for the last line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the arrow keys.

ALT+ENTER

### When using conditional formatting, if the condition is true, then Excel applies the formatting.

True

### Copying, deleting, inserting, and moving ranges of cells have the potential to ____.

Render a worksheet useless

### When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

constant

### If a major error is made when typing data into a cell, click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.

True

### When you complete a copy, the values and formats in the destination area are replaced with the values and formats of the source area.

True

### When you change a value on which a chart is dependent, Excel ____.

immediately redraws the chart based on the new value

### If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of ____.

1932

### Saving the workbook frequently is important for the following reason:

if you lose power, the worksheet could be lost

### If the contents of cells copied using the fill handle are 430 and 410, then the next three values of an extended series are: 400, 390, 370.

False

### Regardless of the length and complexity of a formula, using Point mode to enter formulas always is slower and less accurate than using the keyboard.

False

### If you accidentally delete valuable data, immediately click the Undo button on the Quick Access Toolbar.

True