chapter 1 excel

autoSum

A button that provides quick access to the SUM function

absolute cell reference

A cell reference that refers to cells by their fixed position in a worksheet; an absolute cell reference remains the same when the formula is copied

theme

A collection of coordinated fonts, colors, and effects for graphic elements, such as charts and images, that can be quickly applied to all sheets in a workbook.

merge and center

A command that will join selected cells and center the contents.

cell style

A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

number format

A format that controls how numerical data is displayed, including the use of commas, dollar signs, and the number cell.

chart

A graphical representation of data

legend

A list that identifies patterns, symbols, or colors used in a chart

function

A predefined formula that performs a specific calculation using the inputs you specify.

relative cell reference

A relative address changes if you copy a formula that contains it to a new location on the worksheet. Think of it like saying "in two weeks" - the date will always be different (or relative) depending on the current date.

data point

A value that originates in a worksheet cell and that is represented in a chart by a data marker

normal view

A view that maximizes the number of cells visible on the screen.

AutoFit

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column.

auto fill

An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.

recommended charts

An Excel feature that helps you choose a chart type by previewing suggested charts based upon patterns in your data.

workbook

An Excel file with one or more worksheets.

status bar

An area at the bottom of the Word window that provides information about the program, open file, or current task or selection; it also contains buttons and other controls for working with the document and its content.

formula bar

An element in the Excel window that displays the value or formula contained in the active cell; here you can also enter or edit values or formulas.

spreadsheet

Another name for a worksheet.

chart style

Formats the chart based on the colors, fonts, and effects associated with the workbook's theme

range

Selection of two or more cells.

accounting number format

The Excel number format that applies a thousand comma separator where appropriate

comma style

The Excel number format that inserts thousand comma separators where appropriate and applies two decimal places; Comma Style also leaves space at the right to accommodate a parenthesis when negative numbers are present.

numbered row headings

The area along the left edge of a worksheet that identifies each row with a unique number.

active cell

The cell displayed with a black border.

general format

The default format that Excel applies to numbers; this format has no specific characteristics—whatever you type in the cell will display, with the exception that trailing zeros to the right of a decimal point will not display.

x-axis

The horizontal axis .

row

The horizontal cells in one line of a spreadsheet.

cell

The intersection of a row and a column; the smallest element in which you can enter data. Example of cell addresses: A5, B10, and AA150

column heading

The letter that displays at the top of a vertical group of cells in a worksheet; beginning with the first letter of the alphabet, a unique letter or combination of letters identifies each column.

fill handle

The small black square in the lower right corner of a selected cell

y-axis

The vertical axis

operators

These are symbols or words that perform operations on one or more operands.

format

To apply attributes to cell data to change the appearance of the worksheet.

chart types

Various chart formats used in a way that is meaningful to the reader; common examples are column charts, pie charts, and line charts.

series

a group of things that come one after another in succession

sheet tabs

a label along the lower border

sparkline

a tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious

column

a vertical group of cells in a worksheet identified by letters

data serious

all the data points for a particular category of plotted information

pixel

picture element

label

provide information about number values.

data

text or number in a cell

row heading

the numbers along left side

worksheet

the primary document that work with store data, and formatted as a pattern of horizontal and vertical lines