Chapter 15

Select all box

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

Chart elements button

A button that enables you to add ,remove, or change chart elements such as the title, Eugene, grid lines, and data labels

Chart filters button

A button that enables you to change which data displays in the chart

Chart styles button

A button that enables you to set a style and color scheme for your chart

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

Legend

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

Column chart

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

Switch row/column

A charting command to swap the data over the axis-data being charted on the vertical axis will move to the horizontal axis and vice versa

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 the currently selected or active object; often activated by right clicking a screen item

Show formulas

A command that displays the formula in each cell instead of the resulting value

Merge & Center

A command that joins selected cells in an excel worksheet into one larger cell and centers the contents in the merged cell

Cell stye

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 th likelihood of errors; if the first few characters you type in a cell math an existing entry in the column, excel fills in th remaining characters for you.

Chart styles gallery

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

Series

A group of things that come one after another in succession for example, January, February, March an so on

Row

A horizontal group of cells in a worksheet

Value axis

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

Worksheet grid area

A part of the excel window that displays the columns and rows that intersect to form the worksheets cells

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

SUM Function

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

Function

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

Theme

A predefined set of colors, fonts, lines, and fill effects that coordinated with each other

Rounding

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

Normal view

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

Number format

A specific way in which excel displays numbers in a cell

Sparkline

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

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

Column

A vertical group of cells in a worksheet

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

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

Formula

An equation that performs mathematical calculations on values in a worksheet

Autofit

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

Recommended charts

An excel feature that displays a customized set of charts that according to excels calculations will best fit your data based on the range of data you select

AutoCalcuate

An excel feature that displays three calculations in the status bar by default. Average, count, and sum, when you select a range of numerical data

Auto fill

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

Range finder

An 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

Workbook

An excel file that contains one or more worksheets

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 display the location of the pointer

Expand horizontal scroll bar

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

Cell address

Another name for a cell reference

Value

Another name for a constant value

Label

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

Spreadsheet

Another name for a worksheet

X-axis

Another name for the horizontal (category) axis

Y-axis

Another name for the vertical (value) axis

Cell content

Anything typed into a cell

Sheet tab scrolling buttons

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

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

Number values

Constant values consisting of only numbers

Text values

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

Relative cell reference

In a formula. The address of a cell based on the relative positions of the cell that contains the formula and the cell referred to in the formula

Constant value

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

Data Series

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

Data

Text or numbers in a cell

Scaling

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

Pixel

The abbreviated name for picture element

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

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

Status bar

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

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

AutoSum

The button that provides quick access to the SUM function

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

Active cell

The cell surrounded by a 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 a title, legend, labels for the columns, and the table of charted cells

Displayed value

The data that displays in a cell

Underlying value

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

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

Comma style

The excel number format that inserts thousand comma separators where appropriate and applies two decimal places; comma style also leave space at the right to accommodate a parenthesis when negative numbers are present

Underlying formula

The formula entered in a cell and visible only on the formula bar

Chart

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

Cell reference

The identification of a specific cell by its intersecting column enter an row number

Cell

The intersection of a column and a row

Sheet tabs

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

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

Row heading

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

Chart style

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

Worksheet

The primary documents 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

Fill handle

The small 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

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

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

Range

Two or more selected cells on a worksheet that are adjacent or non adjacent 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

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