Excel Chapter 1: Creating a worksheet and charting data
Chart elements button
A button that enables you to add, remove, or change chart elements such as the title, legend, girdlines, 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
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
Column chart
A chart in which the data is arranged in columns and that is useful for showing how 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
Context sensitive
A command associated with the currently selected or active object; often activated by right-clicking a screen item
Cell style
A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.
AutoCalculate
A feature that displays three calculations in the status bar by default--average, count, and sum--when you select a range of numerical data
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
Chart Styles gallery
A group of predesigned Chart styles that you can apply to an excel chart
Function
A predefined formula
Data point
A value that originates in a worksheet cell and that is represented in a chart by a data marker
column
A vertical group of cells 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
Auto Fill
An Excel feature that generates and extends values into adjacent cells based on the values of selected cells
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.
Cell address
Another name for a cell reference
Cell content
Anything typed into a cell
format
Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read
Constant Value
Numbers, text, dates, or times of day that you typei into cell
Data series
Related data points represented by data markers
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 or 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
Category axis
The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis
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 a title, legend, labels for the columns, and the table of charted cells
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
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 letter and row number
Cell
The intersection of a column and a row
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
Chart style
The overall visual look of chart in terms of its 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
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, multiplication, division, percentage, and exponentiation in an Excel formula
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
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
Data
text or numbers in a cell