Excel 2010 - Comprehensive

Select All box p. 53

A box that appears in the upper left corner of the worksheet grid that, when clicked, selects all the cells in a worksheet.

Range finder p. 82

A Excel feature that outlines cells in color to indicate which cells are used in a formula; useful for verifying which cells are referenced in a formula.

SUM function p. 61

A predefined formula that adds all the numbers in a selected range of cells.

function p. 117

A predefined formula--a formula that Excel has already built for you--that performs calculations by using specific values in a particular order or structure.

Rounding p. 62

A procedure in which you determine which digit at the right of the number will be the last digit displayed and then increase it by one if the next digit to its right is 5, 6, 7, 8, or 9.

AutoFit p. 75

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

Workbook p. 51

An Excel file that contains one or more worksheets.

Expand Formula Bar button p. 53

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.

Horizontal window split box p. 53

An Excel window element with which you can split the worksheet into two horizontal view of the same worksheet.

Workbook-level buttons p. 52

Buttons at the far right of the Ribbon tabs that minimize or restore a displayed workbook.

Relative cell reference p. 63

In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to.

Insert Worksheet button p. 52

Located on the row of sheet tabs, a sheet tab that, when clicked, inserts an additional worksheet into the workbook.

Constant value

Numbers, text, dates, or times of day that you type into a cell.

Data series p. 68

Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend.

comparison operator p. 124

Symbols that evaluate each value to determine if it is the same (=)., greater than (>), or less the (<), or in between a range of values as specified by the criteria.

Accounting Number Format

The Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. Dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers.

Left alignment p. 55

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 stores in a cell.

Cell reference

The identification of a specific cell by its intersecting column letter and row number; another name for cell address.

Cell p. 51

The intersection of a column and a row.

Sheet tabs p. 52

The labels along the lower border of the Excel window that identify each worksheet.

Row heading p. 54

The numbers along the left side of an Excel worksheet that designate the row numbers.

Chart styles p. 69

The overall visual look of a chart in terms of its graphic effects, colors, and backgrounds; for example, you can have a flat or beveled columns, colors that are solid or transparent, and backgrounds that are dark or light.

Worksheet p. 51

The primary document that you use in Excel to work with and store data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.

filter p. 131

The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify.

Point and click method p. 61

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.

data bar p. 127

A cell format consisting of a shaded bar that provides a visual cue to the reader about the value of a cell relative to other cells; the length of the bar represents the value in the cell--a longer bar represents a higher value and shorter bar represents a lower value.

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.

Column chart

A chart in which the data is arranged in columns and which is useful for showing data changes over a period of time or for illustrating comparisons among items.

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.

Context sensitive

A command associated with activities in which you are engaged; often activated by right-clicking a screen item.

freeze panes p. 129

A command that enables you to select one or more rows or columns and freeze (lock) them into place; the locked rows and columns become separate panes.

Merge & Center p. 64

A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the new cell.

find and replace p. 127

A command that searches the cells in a worksheet--or in a selected range--for matches and then replaces each match with a replacement value of your choice.

Cell style

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

AutoComplete

A feature that speeds your typing and lessens the likelihood of errors; if the first few characters you type in a cell match an existing entry in the column, Excel fills in the remaining characters for you.

IF function p. 117

A function that uses a logical test to check whether a condition is met, and then returns one value if true, and another value if false.

logical functions p. 123

A group of functions that test for specific conditions and that typically use conditional tests to determine whether specified conditions are true or false.

Chart Layouts gallery p. 69

A group of predesigned chart layouts that you can apply to an Excel chart.

Chart Styles gallery p. 69

A group of predesigned chart styles that you can apply to an Excel chart.

Series p. 56

A group of things that come one after another in succession; for example: January, February, March, and so on.

Row p. 54

A horizontal group of cells in a worksheet.

Value axis p. 67

A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis.

Picture element p. 57

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 digits that will fit in a cell in an Excel worksheet using the default font; abbreviated "pixels"

Function p. 60

A predefined formula--a formula that Excel has already built for you--that performs calculations by using specific values in a particular order or structure.

Vertical window split box p. 52

A small box on the vertical scroll bar with which you can split the window into two vertical views of the same worksheet.

Number format p. 59

A specific way in which Excel displays numbers in the cell.

COUNTIF function p. 123

A statistical function that counts the number of cells within a range that meet the given condition and that has two arguments--the range of cells to check and the criteria.

Sparklines p. 66

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

Data point

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

Auto Fill p. 56

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

AVERAGE function p. 118

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

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.

Name Box p. 52

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

Formula p. 54

An equation that performs mathematical calculations on values in a worksheet.

Label p. 54

Another name for a text value, and which usually provides information about number values.

X-axis p. 67

Another name for horizontal (category) axis.

AutoSum p. 62

Another name for the SUM function.

Y-axis p. 67

Another name for vertical (value) axis.

Spreadsheet p. 51

Another name for worksheet.

Value p. 54

Anther name for constant value.

Cell content

Anything typed into a cell.

Sheet tab scrolling buttons p. 52

Buttons to the left of the sheet tabs used to display Excel sheet tabs that are not in view; used when there are more sheet tabs than will display in the space provided.

Format p. 64

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

CHAPTER TWO

Chapter 2

criteria p. 123

Conditions that you specify in a logical function.

Number values p. 54

Constant values consisting of only numbers.

Text values p. 54

Constant values consisting of only text, and which usually provides information about number values; also referred to as labels.

Data p. 54

Text or numbers in a cell.

Active cell

The cell, surrounded by a black border, ready to receive data or be affected by the next Excel command.

Chart layout

The combination of chart elements that can be displayed in a chart such as title, legend, labels for the columns, and the table of charted cells.

Displayed value p. 59

The data that displays in a cell.

Underlying value p. 59

The data that displays in the Formula Bar.

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.

Underlying formula p. 61

The formula entered in a cell and visible only on the Formula Bar.

Chart p. 66

The graphic representation of data in a worksheet; data presented as a char is usually easier to understand than a table of numbers.

Cell address

The identification of a specific cell by its intersecting column letter and row number; another name for a cell reference.

Category labels

The labels that display along the bottom of a chart to identify the categories of data; Excel uses the row titles as the category names.

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.

Column p. 53

A vertical group of cells in a worksheet.

Legend p. 67

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

conditional format p. 126

A format that changes the appearance of a cell--for example, by adding cell shading or font color--based on a condition; if the condition is true, the cell is formatted based on that condition, and if the condition is false, the cell is not formatted.

Page Layout view p. 71

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.

Normal view p. 73

A screen view that maximizes the number of cells visible on your screen and keeps the column letters and row numbers close to the columns and rows.

Excel table p. 130

A series of rows and columns that contains related data that is managed independently from the data in other row and columns in the worksheet.

Pixels p. 57

The abbreviated name for a picture element.

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.

drag and drop p. 121

The action of moving a selection by dragging it to a new location.

Category axis

The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis.

Numbered row headings p. 53

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

Status bar p. 52

The area along the lower edge of the Excel window that displays, on the left side, the current cell mode, page number, and worksheet information; on the right side, when numerical data is selected, common calculations such as Sum and Average display.

Lettered column headings p. 53

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

Scaling p. 75

The process of shrinking the width and/or height of printed output to fit a maximum number of pages.

Fill handle

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

Arithmetic operators

The symbols +, -, *, /,%, and ^ used to denote addition, subtraction (or negation), multiplication, division, percentage, and exponentiation in an Excel formula.

Operators p. 80

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

arguments p. 118

The values that an Excel function uses to perform calculations or operations.

detail sheets p. 152

The worksheets that contain the details of the information summarized on a summary sheet.

Range p. 58

Two or more selected cells on a worksheet that are adjacent or nonadjacent; because the range is treated as a single unit, you can make the same changes or combination of changes to more than one cell at a time.

Chart types p. 67

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