click below
click below
Normal Size Small Size show me how
Lesson 3 excel vocab
Vocab
| Term | Definition |
|---|---|
| function | a predefined formula that uses the values in the cell you select to calculate its answer. |
| argument | the parts of a formula that are variable. you select the cell or cells for each argument, and excel calculates the answer based on their value. |
| nest | to use a function an argument within another function. |
| auto calculate | a feature that temporarily performs the following calculations on a range of cells without making you write a formula: AVERAGE, COUNT, COUNTA, MAX, MIN, or SUM. |
| comment | a text note attached to a worksheet cell. |
| range name | an identification label assigned to a group of cells. also known as defined name. |
| name box | the text box located to the left of the formula bar. |
| criteria | a value, some text,or an expression that defines the type of cells you're looking for. |
| expression | a sort of equation (such as B6>25) that returns a value, such as TRUE or FALSE. excel uses expressions to identify cells to include in certain formulas, such as IF and SUMF. |
| embedded chart | a chart placed as an object within a worksheet. |
| plot | to position data points on a graph. |
| data series | for most charts, a data series is the information in a worksheet column.if you select multiple columns of data for a chart, you'll create multiple data series. each data series is then represented by its own color bar, line, or column. |
| legend | a key that identifies each of the data series in a chart. |
| x-axis | the horizontal scale of a chart on which categories are plotted. |
| Y-AXIS | the vertical scale of a chart on which the value of each category is plotted. |
| categories | a category is information in a worksheet row. |
| plot area | the area defined by the x and y axes. |
| object | an item that is treated separately from the main document. in the case of a chart, each chart element is an object that can be manipulated independently. |
| tick marks | lines of measurements along the value and category axes. |