How can we help?

You can also find more resources in our Help Center.

40 terms

Excel Ch. 2

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