Excel B

2. Function that finds the smallest number in a range of cells
5. handle Lets you copy contents or continue a series of data into a range of selected cells
6. The default column width
7. Key board short cut that cycles through modes in the mode indicator
8. method Text book page 42, concepts review, under the labeling of the Excel worksheet, letter c
11. Function that adds together all values in a range of cells
12. Copies cell contents into adjacent cells
14. Function that adjusts the value or formula result to a specified number of decimal places
15. Function that returns the number of cells in a range that contain numeric data
16. The name of the name, spelled out, key you press to copy while dragging and dropping selected cells
18. Here is an example of the type of cell referencing: $A$3
20. Function that adds together all values in a range then divides them by how many values there are
21. An absolute cell address of a range that begins in column Z, row 1 and ends in column Z, row 10
22. Clears contents of selected cells with one button
23. Function that finds the largest number in a range of cells

1. box launcher Item on the Ribbon that opens a dialog box or task pane
3. Here are examples of the type of cell referencing: $A3 or A$3
4. Cell address of the range starting in column D, row 4 and ending in column D, row 18
7. autocomplete Displays an alphabetical list of functions from which you can choose (page 42 in the text book)
9. Number format that adds dollar signs, which line up and down the let side of the cell, and two decimal places to the data
10. Referencing changes in relation to cell containing formula and changes when copied
11. The name for a collection of characters with a similar, specific design is a(n) -----
13. Key board shortcut that cycles through cell referencing
16. An relative cell reference ------- when copied. Extra help: The lady ------- her clothes all the time.
17. formula A formula that uses more than one arithmetic operator
19. Cell address of column B, row 10