Shared Flashcard Set

Details

Excel Terms 2
Excel Terms 2
22
Computer Networking
10th Grade
02/12/2013

Additional Computer Networking Flashcards

 


 

Cards

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. the rules you set to filter, sort, or format data,
Supporting users have an ad free experience!