Term
| If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series. |
|
Definition
|
|
Term
| Copying, deleting, inserting, and moving ranges of cells have the potential to ____. |
|
Definition
| D. render a worksheet useless |
|
|
Term
| Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ____. |
|
Definition
|
|
Term
| 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. |
|
Definition
|
|
Term
| The number of worksheets that a workbook can contain is __________. |
|
Definition
| B. limited by computer memory |
|
|
Term
| A Pie chart with one or more slices offset is called a(n) ____. |
|
Definition
|
|
Term
| What effect does the Accounting Number Format have on the selected cells? |
|
Definition
| A. causes cells with two decimal places to align vertically correctly |
|
|
Term
| Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas. |
|
Definition
|
|
Term
| Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas |
|
Definition
|
|
Term
| All of the following are valid Excel arithmetic operators except ____. |
|
Definition
|
|
Term
| Click ____ in the Conditional Formatting gallery to display the New Formatting Rule dialog box |
|
Definition
|
|
Term
| To instruct Excel to display a hidden column, position the mouse pointer to the ____. |
|
Definition
| B. right of the column heading boundary where the hidden column is located and then drag to the right |
|
|
Term
| If you want to increase or decrease column width significantly, you can right-click a column heading and then use the ____ command on the shortcut menu to change the column’s width. |
|
Definition
|
|
