Excel chapter 1
Auto sum
A button that provides quick access to the SUM function
Absolute cell reference
A cell reference that refers to the 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 pattern s or color that are assigned to the categories in the chart
Merge & Center
A command that joins selected cells in an excel worksheet into one larger cell and center contents in the merged cell.
Cell style
A defined set of formatting characteristics, such as font, font size, font color, cell border, and cell shading.
Series
A group of things that come one after another in succession for example Jan Feb. march April ...
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 coordinate with each other
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 column and rows
Number format
A specific way in which excel displays number 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
Data point
A value that originates in a worksheet cell and that is represented in a chart by data marker.
Column
A vertical group of cells in a worksheet
Formula Bar
An element in excel window that displays the value or formula contained in the active cell here you can also enter or edit values or formulas
Auto Fill
An excel feature that generates and extends values into adjacent cells based on the values of selected cells.
Auto fit
An excel features that adjusts the width of a column to fit the cell content of the widest cell in the column.
Recommended Charts
An excel features that display 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
Workbook
An excel file that contains one or more worksheets
Label
Another name for a text value and which usually provides information about number values
X- axis
Another name for the horizontal axis
Y-axis
Another name for the horizontal axis
Worksheet
Primary doc. 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
Data seriers
Related data points represented by data markers ; each data series has a unique color pattern represented to the chart legend
Data
Text or number in a cell
Pixel
The abbreviated name for a picture element
Numbered row heading
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 when worksheet information on the right side when the numerical data is selected common calculations such as a sum and average
Active cell
The cell, surrounding by a black border, ready to receive data or be affected by the next Excel comma.
General Format
The default format that excel applies to number this format has no specific characteristics
Accounting Number format
The excel number format that applies a thousand comma separators where appropriate.
Comma style
The excel number format that inserts thousand comma separators where appropriate and applies two decimal places comma styles also leaves space at the right to accommodate a parenthesis when negative numbers are present
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
Column heading
The letter that display 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 number
Chart style
The overall visual look of a chart in ter4ms of its graphic effects colors and backgrounds; for example you can have flat or beveled columns colors that are solid or transparent and background that are dark or light
Fill handle
The small black square in the lower corner of a selected cell
Operators
The symbol with which you can specify the type of calculation you want to perform in an excel formula
Range
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 type
Various charts formats used in a way that is meaningful to the reader common examples are columns charts, pie charts, and line charts.
Row
a horizontal group of cells in a worksheet
Spreadsheet
another name for worksheet
Format
changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read
Relative cell reference
in a formula the address of a cell based on the relative position of the cell referred to in the formula
Chart
the graph representation of data in a worksheet; data presented as a chart is usually easier to understand than a table of numbers.