Excel chapter 1
Autosum
A button that provides quick access to the SUM function
Absolute cell reference
A cell reference that refers to cells by their reference fixed position in 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
Series
A group of things that come one after another in succesion; for example,January,February,March,and so on
Row
A horizontal group of cells in a worksheet.
Function
A predefined formula - a formula that Excel has already built for you- that performs calculations by using specfic values in a paricular 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 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
Data point
A value that oringnates in a worksheet cell and that is represetned 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.
Recommended Charts
An Excel feature that displays a customized set of charts that, according to Excel's calculations, will best fit your data based on that you select.
Auto Fill
An Excel feature that generates and extends values into adjacent cells based on the values into adjacent cells based on the values of selected cells.
Workbook
An Excel file that contains one or more worksheets.
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
Spreadsheet
Another name for a worksheet
Label
Another name for tet value, and which usually provides information about number
X-axis
Another name for the horizontal axis.
Y-axis
Another name for the vertical axis.
Format
Changing the appearence of cells and worksheet elements to make a worksheet attractive and easy to read.
Realative cell reference
In a formula, the address of a cell based on the relative postions of the cell that contains the formula and the cell referred to i the formula
Data series
Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend.
Data
Text or numbers in a cell
Accounting Number Format
The Excel number format that applies a thousand comma separator where appropriate.
Comma Style
The Excel number that inserts thousand comma separators where approciate and applies two decimal places; Comma style also leaves space at the right to accomodate a parenthesis when negative numbers are present.
Pixel
The abbreviated name for a picture element.
Number 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 Average display.
Active cell
The cell, surrounded by a black border, ready to receive data or be affected by the Excel command.
General Format
The default forms Excel applies to numbers; this format has no specfic characteristics
Chart
The graphic representation of data in a worksheet; data presented as a chart is usually to easier to understand than a table of numbers.
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 displays at the top of vertical group of cells in a worksheet; beginning with the first 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 its graphic effects, colors and backgrounds; for example, you can have flat or beveled columns, 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 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.
Fill handle
The small black square in the lower right corner of a selected cell.
Operators
The symbols with qhich 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 types
Various chart formats used in a way that is meaningful to the reader; common examples are column charts, pie charts, and line charts.
Merge and Center
A command that joins selected cells in Excel worksheet into one larger cell and centers the contents in the merged cell.
Cell Style
A defined set of formatting characteristics,such as font,font size, font color,cell borders, and cell shading