xl 2
About this set
Created by:
rayalextrujillo on January 7, 2011
Subjects:
Log in to favorite or report as inappropriate.
Order by
36 terms
Terms | Definitions |
|---|---|
 Accounting Number Format | displays numbers with a dolla sign to the left of the number, inserts a comma every three positions to the left of the decimal point, an displays numbers to the nearest cent (hundredths place) |
| arguments | the information necessary to calculate the answer |
| asterisk | a star-shaped character * used in printing |
| AVERAGE function \ | example: =Average(C4:C18) determines the average of the range of cells from C4 through C18 |
| best fit | means that the width of the column will be increased or decreased so the widest entry will fit in the column |
| blank cell | a numerical value of zero |
| Comma style format | can be assigned to a range of cells by clicking the Comma style button on the Ribbon, inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths |
| condition | the procedure that is varied in order to estimate a variable's effect by comparison with a control condition |
| conditional formatting | Highlights worksheet data by changing the look of cells that meet a specified condition (EX 136). |
| debugging | fixing errors |
| e-mail | (computer science) a system of world-wide electronic communication in which a computer user can compose a message at one terminal that is generated at the recipient's terminal when he logs in |
| equal sign | a symbol that shows two amounts have the same value |
| fixed dollar sign | places a dollar sign to the left of the cell leaving spaces between it and the cell numbers |
| floating dollar sign | appears immediately to the left of the first digit with no spaces, use the Currency Style in the Format Cell dialog box |
| formula | An equation that calculates a new value from values currently in a worksheet |
| formulas version | shows the actual formulas you have entered, rather than the resulting values |
| function | a set sequence of steps, part of larger computer program |
| hiding cells | allows you to hide data in cells |
| landscape orientation | page orientation in which data prints across the wider portion of the page |
| MAX function | displays the highest (maximum) value in a range |
| MIN function | determines the lowest (minimum) number in the range |
| Normal View | the default view in a presentation, which contains the slide pane, the outline pane, the task pane, and the notes pane |
| Order of operations | moving from left to right in a formula |
| Page Layout View | View that displays the worksheet as a printed page. |
| 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 | Printout ,of a page,is printed across the width of a page |
| previewing the worksheet | you can 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 |
| relative cell references | is copied and pasted to other cells, the cell references in the formula or function change to reflect the function's new location. |
| smart tag indicator | a small purple triangle in a cell that indicates that a smart tag is available |
| smart tags | identifies certain actions to take on specitic data in workbooks |
| spell checker | Checks 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 the actual formulas |
| Web query | used to import data stored on a web site |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.