Chapter 1 - excel
Legend
A chart element that identifies the patterns
Series
A group of things that come one after another in succession
Quick Analysis tool
A tool that displays in the lower right hand corner of a selected range with which you can analyze your data
Data series
Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend
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
Scaling
The process of shrinking the width
Range
Two or more selected cells on a worksheet that are adjacent
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.
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
Show formula
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 style
A defined set of formatting characteristics, such as front, font size, font color, cell borders, and cell shading
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
SUM function
A predefined formula that adds all the numbers in a selected rang 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
Normal view
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
Sparkline
A tiny chart in the background of a cell that gives a visual trend summary alongside your data
Data point
A value that originates in a worksheet cell and that is represented in a chart by a data marker
AutoFit
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column
Recommended Chart
An Excel feature that displays a customized set of charts that, according to Excel's calculations, will best fit your data based on the range of data that you select
Auto Fill
An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.
Workbook
An Excel file that contains one or more worksheet
Formula Bar
An element in the Excel window that displays the value or formula contained in the active cell
Formula
An equation that performs mathematical calculations on values in a worksheet
Label
Another name for a text value, and which usually provides info about number values
spreadsheet
Another name for a worksheet
Format
Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read
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.
Comma Style
The Excel number format that inserts thousand comma separators where appropriate and applies two decimal places
Pixel
The abbreviated name for a picture element
Left alignment
The cell format in which characters align at the left edge of the cell
Active cell
The cell, surrounded by a black border, ready to receive data or be affected by the next Excel command.
Chart
The graphic representation of data in a worksheet; data presented as a chart is usually usually easier to understand than a table of numbers
Chart style
The overall visual look of a chart in terms of its graphic effects, colors, and background,
Worksheet
The primary document that you use in Excel to work with and store data
Fill handle
The small black square in the lower right corner of a selected cell
