Excel Chapter One

Merge and Center

A Command that will join selected cells in an Excel Worksheet into one larger cell and centers the contents in the merged cell

Legend

A chart element that identifies the patterns or colors that are assigned to the categories in the chart

Data Marker

A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point; related data points form a data series.

Function

A predefined formula

Normal View

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

Number Format

A specific way in which Excel displays numbers in a cell

Quick Analysis Tool

A tool that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas.

Data Point

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

Excel Pointer

An Excel window element with which you can display the location of the pointer.

Expand Formula Bar Button

An Excel window element with which you can increase the height of the Formula Bar to display lengthy cell content.

Expand Horizontal Scroll Bar Button

An Excel window element with which you can increase the width of the horizontal scroll bar.

Name Box

An element of the Excel window that displays the name of the selected cell, table, chart or object

Label

Another name for a text value

Format

Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read

Numbered Row Headings

Indicate the row number.

Data Series

Related data points represented by data markers

Data

Text or numbers in a cell.

Lettered Column Headings

The area along the top edge of a worksheet that identifies each column with a unique letter or combination of letters.

Left Alignment

The cell format in which characters align at the left edge of the cell; this is the default for text entries and is an example of formatting information stored in a cell.

Displayed Value

The data that displays in a cell

General Format

The default format that Excel applies to numbers; Whatever you type in the cell will display

Fill Handle

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

Point and Click Method

The technique of constructing a formula by pointing to and then clicking cells; this method is convenient when the referenced cells are not adjacent to one another.

Number Values

Values consisting of only numbers

Picture Element

a point of light measured in dots per square inch on a screen; 64 pixels equals 8.43 characters, which is the average number of characters that will fit in a cell in an Excel worksheet using the default font

Page Layout view

a screen view in which you can use the rulers to measure the width and height of data, set margins for printing, hide or display the numbered row headings and the lettered column headings, and change the page orientation; this view is useful for preparing your worksheet for printing

Formula Bar

an element in the Excel window that displays the value or formula contained in the active cell

Formula

an equation the performs mathematical calculations on values in a worksheet

Pixel

picture element

Operators

smbols with which you can specify the type of calculation you want to perform in an Excel formula