| A | B |
|---|
| freeze panes | keeps titles on the screen while scrolling through your worksheet |
| $b$16 | when copies the column and row reference stays the same |
| $b16 | when copied the column stays the same, row changes |
| b16 | when copied the column and row changes |
| delete key | erases characters to the right of the insertion point |
| charts | pictorally represents data |
| cell | the basic unit of a worksheet into which you enter data |
| gridlines | horizontal and vertical lines on the worksheet |
| AutoCalculate | can be used in place of a claculator to view the sum, average or other types of totals |
| range | a series of two or more adjacent cells in a column or row or a rectangular group of cells |
| fill handle | is the small black square located in the lower right corner of the heavy border around the active cell |
| Name Box | located on the left side of the formula bar |
| y-axis | vertical axis |
| x-axis | horizontal axis |
| Max function | displays the greatest value in the selected range |
| Min function | displays the least value in the selected range |
| Sum function | displays the sum of the numbers in the selected range |
| Average function | displays the average of the numbers in the selected range |
| ALT + ENTER | adds more lines to a cell |
| * | multiplication symbol |
| = | indicates a formula will be typed |
| currency style button | displays a $ sign to the far left in the cell |
| control + `~ | displays the formulas on the worksheet |
| rotate text 45 degrees | right click, Format Cells, orientation, select 45 degrees |
| Net sales-total expenses= | net income |
| ######## | cell is not wide enough to fit all the numbers |
| NOW function | automatically inserts/format today's date |
| =if(b4>50,25,0) | if the value of b4 is >50, enter the value of 25, if not enter 0 in the desired cell |
| Split Command | panes will be divided above and to the left of active cell |
| Goal Seek | you know what answer you want a formula in a cell to be, but you do not know the value to place in a cell that is involved in the formula. |
