excel

active cell

The cell outlined in green in which data is entered when you begin typing

Formula bar

a bar below the Ribbon that displays the value contained in the active cell and is used to enter or edit values or formulas

Legend

a box that identifies the patterns or colors that are assigned to the data series or categories in the chart.

Pie chart

a chart that illustrates the relationship to parts to a whole.

Embedded chart

a chart that is place on the worksheet containing the data.

Area chart

a chart type that emphasizes the magnitude of change over time.

Bar chart

a chart type that illustrates comparisons among individual items.

Line chart

a chart type that illustrates trend over time, with time displayed along the x axis and the data point values connected by a line.

Column chart

a chart type used for illustrating comparisons among related numbers.

Data point

a chart value that originates in a excel worksheet cell, a word table cell, or an access field. Individual data plotted in a chart.

Calculated Column

a column in an excel table that uses a single formula that adjusts for each row

Data marker

a column, bar, area,dot, pie, slice, or other symbol that represents a single data point.

Autofit

a command that automatically changes the column width to accommodate the longest entry.

Filter

a command to display only the rows of a table that meet specified criteria filtering temporarily hides rows that do not meet the criteria

Formula AutoComplete

a feature that suggests values as you type a function

Conditional Formatting

a format such as cell shading or font color, which is applied to cells when a specified condition is true

Text wrap

a format that displays text on multiple lines within a cell.

Average function

a function that adds a group of values, and then divide the result by the number of values in the group.

COUNT function

a function that counts the number of cells that contain numbers

Max function

a function that returns the largest value in a range of cells.

Min function

a function that returns the smallest value in a range of cells.

Chart

a graphical representation of data used to show comparisons, patterns, and trends.

Error indicator

a green triangle that indicates a possible error in formula.

Series

a group of things that come one after another in succession; for example, the months january, february, march.

Axis

a line bordering the chart plot area used as a frame of reference for measurement.

Error value

a message that displays whenever a formula or function cannot perform its calculations.

Chart style

a pre built chart that applies an overall visual look to a chart by modifying it graphic effects, coors, and background.

Chart layout

a pre built set of chart elements that can include a title, legend, or labels.

Cell style

a pre built set of formatting characteristics such as font font size font color cell borders and cell shading

Statistical function

a predefined function that describes a collection of data;for example, totals, counts, and averages.

serial number

a sequential number

Number format

a specific way that excel displays numbers.

Arithmetic operator

a symbol that specifies a mathematical operation such as addition or subtraction

Normal View

a view that maximizes the number of cells visible on the screen

Chart sheet

a workbook sheet that contains only a chart and is useful when you want to view a chart separately from the worksheet data.

summary sheet

a worksheet that displays and summarises totals from other worksheets

detail sheet

a worksheet with cells referred to by summary sheet formulas

Formula

an equation that performs mathematical calculations on number values in the worksheet

Range finder

an excel feature that outlines all of the cells referenced in a formula. It is useful for verifying which cells are used in a formula and it can be used to edit formulas.

Comparison Operation

an operator that compares two values

X axis

another name for horizontal axis.

Y axis

another name for the vertical axis.

Logical test

any value or expression that can be evaluated as being TRUE or FLASE

Name Box

area that displays the active cell reference

tab scrolling buttons

button to the left of the worksheet tabs used to display worksheets that are not in view

Text Value

character data in a cell that labels number values

Sparkline

chart contained in a single cell that is used to show data trends

clustered bar chart

chart type that is useful when you want to compare values across categories; bar charts organize categories along the vertical axis and the values along the horizontal.

Freeze Panes

command used to keep rows or columns visible when scrolling in a large worksheet the frozen rows and columns become separate panes

Criteria

condition that is specified in the logical test

Truncated

cut off

3

d- short for three-dimensional

Displayed value

data displayed in a cell

Underlying value

data displayed in formula bar

Value

data in cell

three

dimensional- refers to an image that appears to have all three spatial dimensions: length,width,and depth.

SUM

excel function that adds all the numbers in a range of cells

Replace

feature that finds and then replaces a character or string or characters, or in a selected range

Workbook

file that you can use to organize various kinds of information

Data Bar

format that provides a visual cue to the reader about the value of a cell relative to other cells the length of the data bar represents the value in the cell

Underlying formula

formula as displayed in the formula bar

Logical Function

function that applies a logical test to determine if a specific condition is met

TODAY Function

function that returns the serial number of the current date

NOW Function

function that returns the serial number of the current date and time

line chart

illustrates data overtime, time displayed on x axis connected by a line

Data series

in a chart, data points that are related to one another.

IF function

logical function that checks whether criteria is met, and then returns one value when the condition is TRUE, and another value when the condition is FALSE

operator precedence

mathematical rules for performing calculations within a formula

drag and drop

method in which you move objects point to a selection and move to a different area

Category label

non numeric text that identifies the categories of the data.

Row heading

number that displays at the left of a row

Number value

numeric data in a cell

Landscape

orientation that is wider than it is tall

Function

prewritten Excel formula that takes a value or values performs an operation and returns value or values

Spreadsheet

primary document that you use in excel to store and work with data also called worksheet

Relative cell reference

refers to cells based on their position in relation to the cell that contain the formula

Data series

relates data points on a chart; assigned a unique color or pattern represented in a chart legend.

Volatile

result of a function that does not remain as entered, but is updated each time the workbook is opened

Total Row

row that displays as the last row in an excel table and provides summary functions in drop-down lists for each column

Excel Table

series of rows and columns that contains related data that have been formatted as a table

Worksheet

spreadsheet

paste area

target destination for an item that has been cut or copied

Label

text data in a cell that identifies a number value

Category axis

the axis that displays the category labels.

Value axis

the axis that displays the worksheets numeric data.

Cell reference

the column letter and row number that identify a cell also called cell address

Cell address

the column letter and row number that identify a cell also called the cell reference

General format

the default number format. It does not display commas or trailing zeros to the right of a decimal point.

Absolute cell reference

the exact address of a cell, regardless of the position of the cell that contains the formula, that remains the same when the formula is copied. An absolute cell reference takes the for $A$1.

Worksheet tab

the labels along the lower border of the workbook window that identify each worksheet or chart sheet.

Column heading

the letter that displays at the top of a column

Formatting

the process of specifying the appearance of cells or the overall layout of a worksheet

Fill handle

the small black square in the lower right corner of the selection

Argument

the values that a function uses to perform operations or calculations.

Range

two or more cells in a worksheet that are adjacent or nonadjacent

Content

underlying formulas and data in cells

Page layout view

view used to to adjust how a worksheet will look when it is printed