Excel Ch. 2
MIN
The ________ function determines the lowest number in a range.
>
________ is not a valid arithmetic operator.
blank
A ________ cell in Excel has a numerical value of zero.
theme
A ________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.
function
A ________ is a prewritten formula that is built into Excel.
Auto Fill Options
Gives options for filling cells following a fill operation
=23%
Multiplies 23 by 0.01
(Home tab | Number group)
Path to the Comma Style button
(Home tab | Styles group)
Path to the Conditional Formatting button
(Review tab | Proofing group)
Path to the Spelling button
(Home tab | Editing group)
Path to the Sum button
(Home tab | Clipboard group)
Path to the copy and paste buttons
select cells for use in a formula using the mouse pointer
Point mode allows you to ________.
26
When Excel follows the order of operations, for formula, 8*3+2, equals ________.
operations
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ________ that you use in algebra.
CTRL+C
To copy cell contents, you can select the cell and the press the ________ keys.
Insert Function box on the formula bar
Clicking the ________ opens the Insert Function dialog box shown in the accompanying figure.
=G15
Excel assigns the value in cell G15 to the active cell.
right parenthesis
Excel automatically appends the ________ to complete the AVERAGE function with you click the Enter box or press the ENTER key.
CTRL+V
To paste copied cell contents, you can press the ________ keys.
Print Selection
To print a range of cells in the active worksheet, click ________ in the Settings area in the Print gallery, as shown in the accompanying figure.
ALT+ENTER
To start a new line in a cell, press the ________ keys.
AutoCorrect Options
You can click the ________ button to undo an automatic correction.
CTRL+1
You can open the Format Cells dialog box by pressing the ________ keys.
F8
You can select a range using the keyboard by pressing the ________ key and then an ARROW key.
Range Finder
You can use the ________ to check which cells are referenced in the formula assigned to the active cell.
double-click
You should ________ a function name in the Formula AutoComplete list to select the function.
Page Layout
________ view allows you to create or modify a worksheet while viewing how it will look in printed format.
8.43
If you do not assign a format to a cell or cells in a column, the column width will remain ________ characters.
fixed
In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a ________ dollar sign.
Formula
The ________ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
Insert
The ________ Option button lists formatting options following an insertion of cells, rows, or columns.
Trace Error
The ________ Options button lists error-checking options following the assignment of an invalid formula to a cell.
Accounting number format
The ________ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.
MAX
The ________ function displays the highest value in a range.
AVERAGE
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.
relative
The adjusted cell references in a copied and pasted formula are called ________ references.
blue
The most popular background color is ________.
0
When you decrease the row height to ________, the row is hidden.
20xx
When you enter a two-digit year that is less than 30, Excel changes the year to ________.