# Shared Flashcard Set

## Details

Excel Terms 2
Excel Terms 2
23
Computer Networking
02/12/2013

Term
 Chart:
Definition
 A graphic that allows you to compare and contrast data in a visual format.
Term
 Embedded Chart:
Definition
 A chart placed as an object within a worksheet.
Term
 Chart Sheet:
Definition
 A chart that occupies its own worksheet.
Term
 Plot:
Definition
 To position data points on a graph.
Term
 Data series:
Definition
 For most charts, the information in a worksheet column. Each is then represented by its own color bar, line, or column.
Term
 Legend:
Definition
 A key that identifies each of the data series in a chart.
Term
 X-axis:
Definition
 The horizontal scale of a chart on which categories are plotted.
Term
 Y-axis:
Definition
 The vertical scale of a chart on which the value of each category is plotted.
Term
 Categories:
Definition
 For most charts, information in a worksheet row. These will be listed along the x-axis.
Term
 Plot Area:
Definition
 The area defined by the x and y axes.
Term
 Object:
Definition
 An item that is treated separately from the main document. In the case of a chart, each chart element can be manipulated independently.
Term
 Chart area:
Definition
 The total area occupied by a chart.
Term
 Tick marks:
Definition
 Lines of measurement along the value and category axes.
Term
 Relative Cell Reference:
Definition
 A cell address expressed in relation to the cell containing the formula. For example, rather than naming a specific cell in a formula, a relative cell reference might identify a cell three columns to the left of the cell containing the formula. When such a formula is copied, the relative cell references are adjusted to reflect the new location of the formula cell.
Term
 Absolute Cell Reference:
Definition
 A cell address, such as \$E\$14, referenced in a formula that does not change based on the location of the cell that contains the formula.
Term
 Argument:
Definition
 The parts of a formula that are variable. You select the cell or cells, and Excel calculates the answers based on their values.
Term
 Nest:
Definition
 To use a function as an argument within another function.
Term
 Formula AutoComplete:
Definition
 A feature that speeds up the manual entry of functions.
Term
 AutoCalculate:
Definition
 A feature that temporarily performs the following calculations on a range of cells without making you write a formula. For example, SUM, MIN, MAX, AVERAGE.
Term
 Comment:
Definition
 A text note attached to a worksheet cell.
Term
 Function:
Definition
 A preprogrammed Excel formula for a complex calculation.
Term
 Criteria:
Definition
 A value, some text, or an expression that defines the type of cells you’re looking for.
Term
 Expression:
Definition
 A sort of equation (such as B6>25) that returns a value, such as TRUE or FALSE. Excel uses these to identify cells to include in certain formulas, such as IF and SUMIF.
Supporting users have an ad free experience!