# Shared Flashcard Set

## Details

Excel 2010 Lesson 3&4
Vocabulary Definitions
35
02/18/2013

Term
 Absolute Reference
Definition
 A permanent reference to a cell and does not change in relation to the location of the formula.
Term
 Argument
Definition
 Follows the function name and is enclosed in parentheses.
Term
 Arithmetic Operations
Definition
 The most common Used operators such as addition and subtraction.
Term
 Auto Fill
Definition
 A feature that you can use to automatically fill in worksheet data in any direction.
Term
 Comparison Operators
Definition
 Used to compare two Values to obtain a logical value, either TRUE or FALSE.
Term
 Constants
Definition
 Numbers entered directly into a formula that does not change.
Term
 Error Value
Definition
 Excel indicates when a formula you have entered results in an error.
Term
 Fill Handle
Definition
 A little black square in the lower-right corner of the results in an error.
Term
 Formula
Definition
 A set of instructions used to perform calculations on values in a worksheet.
Term
 Functions
Definition
 Built-in formulas that enable you to perform complex calculations easily.
Term
 Mixed Reference
Definition
 Contains both relative and absolute cell references.
Term
 Operator
Definition
 A sign or symbol that indicates what calculation is to be performed.
Term
 Order of Operations
Definition
 A specific sequence used to calculate the value of a formula.
Term
 Relatvie Reference
Definition
 The reference to a cell changes in relation to the location of the formula.
Term
 Syntax
Definition
 A function must follow a set of established rules that specifies how the function must be entered.
Term
 Chart
Definition
 A graphical representation of wroksheet data.
Term
 Chart Area
Definition
 The complete chart and all its elements, which include the plot area, titles, axes, legend, and any other objects.
Term
 Chart Sheet
Definition
 Placing the chart in a seperate sheet in the workbook.
Term
 Clip art
Definition
 A collection of predisigned artwork such as drawings or images that can be inserted into worksheets.
Term
 Data Marker
Definition
 A dot, a bar, or a symbol used to to represent one number from the sheet.
Term
 Data Series
Definition
 As series of related values from the worksheet graphically represented by a unigue color or pattern.
Term
 Data Source
Definition
 The range of cells that contains the data you want to display in the chart.
Term
 Drawing Objects
Definition
 shapes, curves, and lines that you create in the worksheet by first selecting the type of shape you want to create, and then clicking and dragging the mouse to create that shape.
Term
 Embedded Chart
Definition
 A newly created chart that are used for showing categories.
Term
 Gridlines
Definition
 Lines extending from the vertical or horizontal axes across the plot area of a chart.
Term
 Horizontal Axis
Definition
 Lines on a chart that are used for showing catergories.
Term
 Legend
Definition
 A list that identifies the patterns or colors of the data series or catgories in a chart.
Term
 Pictures
Definition
 Digital photographs or images, stored on your computer or network.
Term
 Plot Area
Definition
 The area in the chart where the calues from the data series are displayed graphically; this includes the axes and data series.
Term
 Screenshot
Definition
 A picture of a computer screen or part of a screen, such as a button.
Term
 SmartArt Graphic
Definition
 A predesigned diagram made up shapes contacting text that illustrates a cincept or idea.
Term
 Sparlines
Definition
 Miniature charts that are embedded in the background of a single cell.
Term
 Title
Definition
 Descriptive name that identifies a chart or axis.
Term
 Vertical Axis
Definition
 Lines on a chart thatare used for plotting values.
Term
 WordArt
Definition
 A drawings tool that turns word into a graphics object.
Supporting users have an ad free experience!