| A | B |
|---|
| Accouting Number format | Excel displays numbers with a dolloar sign to the left of the number, inserts a comma every three positions to the left of the decima point, and displays numbers to the nearest cent. |
| Arguments | The Value that you use with a function. |
| Asterisk | (*) the arithmetic operator that directs Excel to perform the multiplication operation. |
| AVERAGE functions | sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range. |
| Best fit | the width of the column will be increased or decreased so the widest entry will fit in the column. |
| Blank Cell | a cell in Excel that has a numerical value of zero, which would have resulted in an error message. |
| Comma Style format | Displays numbers with commas and no dollar signs. |
| Condition | made up of two values and relational operator, is true of false for each cell in the range. |
| Conditional formatting | made up of two values and a relational operator, is true of false for each cell in the range. |
| Debugging | the process of fingind a correcting errors in the worksheet. |
| Equal sign | alerts Excel that you are entering a formula or function and not text. |
| Fixed dollar sign | displays to the far left in the cell, oftern with spaces between it and the first digit. |
| Floating dollar sign | displays immediately to the left of the first digit with no spaces. |
| Formula | Excel will calculate the result. |
| Formulas version | shows the actual formulas you have entered, rather than the resulting values. |
| Funciton | a prewritten formula that is built into Excel. |
| Hiding cells | a technique you can use to hide data that might not be relevant to a particular report or sensitive data that you do not want others to see. |
| Landscape orrientation | the printout is printed accross the length of the page. |
| MAX function | Dispays the highest value in a range. |
| MIN function | determines the lowest (minimum) number in the range. |
| Normal view | The default view that you have worked in. |
| Order of operations | when using a formula with more than one operations use as follows: first negation (-), then all percentages (%), then all exponentiations (^), then all multiplications (*), and divisions (/), and finally, all additions (+) and subtractions (-). |
| Page layout view | allows you to create or modify a worksheet while viewing how it will look in printed format. |
| Pixel | – a dot on the screen that contains a color. |
| Point mode | Allows you to select cells for use in a formula by using the mouse. |
| Portrait orientation | the printout is printed across the width of the page. |
| Previewing the worksheet | you see exactly how it will look without generating a printout. |
| Range finder | checks which cells are referenced in the formula assigned to the active cell. |
| Relatie cell references | when you copy a formula, Excel adjusts the cell references so the new formulas contain references corresponding to the new location and performs calculations using the appropriate values. |
| Smart tag indicator | a small purple triangle, indicating that smart tag is available. |
| Smart tags | Excel identifies certain actions to take on specific data in workbooks, such as: dates, financials symbols, people’s names, and more. |
| Spell checker | used to check the worksheet for spelling errors. |
| Theme | a predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook. |
| Values version | shows the results of the formulas you have entered, rather than an actual formula. |
| Web query | importing data stored on a web site. |
