The __ Feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry
The cell being copied is called the souce are (or copy area). The range of cells receiving the copy is called the __
D. destination area (or paste area)
When more than one arithmetic operator-is involved in a formula, Excel follows the same basic order of __ that you use in algebra
Point mode allows you to , as shown in the accompanying figure.
C.select cells for use in a formula using the mouse pointer
The function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range
The __ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign
20. You should a function name in the Formula AutoComplete list to select the function
21. If you do not assign a format to a cell or cells in a column, the column width will remain __ characters.
With a solid understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to __
a. use Excel to create the worksheet
The Auto Fill Option that fills the destination area using the format of the source area; no content is
b. Fill Formatting Only
The Copy button copies the contents and format of the source area to the Office, a reserved place in the
the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the
examines the formulas in a workbook in a manner similar to the way the spell checker examines a __workbook for misspelled words
b. The formula checker
A check mark in the __ check box speeds up printing by ignoring formatting and not printing most graphics
d. Draft quality
The Conditional Formatting __ dialog box display all of the rules for the curent selection or for the entire workbook.
d. Rules Manager
When you first create a table, Excel automatically enables __, as shown in the accompanying figure.
You can display all records in the table after a query hid some of the records by clicking the filter button on
c (Data tab/ Sort & Filter group)
A requirements document includes a needs statement, source of data, summary of calulations, and any other special requirements for a worksheet, as shown inthe accompanying figure.
45. You can turn off the Bold formatting for selected text by clicking the Bold Off button (Home tab | Font group).
You can snap an embedded chart to the worksheet gridlines by holding down the ALT key while you drag the chart to a new position.
47. You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.
49. As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.
Clicking the Insert Function box opens the Function Arguments dialog box, as shown in the accompanying figure.
Excel has more than 400 additional functions that perform just about every type of calculation you can imagine.
The use of a fill color in a cell or range of cells sets off the cell or range from other portions of the worksheet and provides visual impact to draw the user's eye toward the cell or range
A floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.
Best fit means that the width of the column will be increased or decreased by a percentage you specify.
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area
Changing the order of sheets in a workbook allows you to position the most important worksheets first.
You can apply merge and center formatting with the Center button (Home tab | Alignment group).
Excel automarically creates an empty row in he row in the table, as shown in the accompanying figure, so that you are ready to enter the first record in the table.
Excel's __, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.
When Excel draws a(n) chart, it always positions the chart so that one of the __dividing lines between two slices is a straight line pointing to 12 o'clock (or 0 degrees)
you can start data in a table by clicking the Sort button in the Sort & Filter group on the __ tab.
Fills a destination area using the format of the source area; no content is copied.
B. Fill Formatting Only
91. Returns a number that corresponds to the system date and time beginning with December 31,1899
A. Now function
Returns the present value of an investment or annuity.
E. Returns the present value of an investment
A name assigned to a cell or range in one worksheet can be used to reference the cell or range on other worksheets in the same workbook.
98. Displays all records that meet the criteria as a subset of the table by hiding records that do not pass the test
99. An area of the worksheet that you use to manipulate records that pass the comparison criteria.
E. criteria range