Ap Calculus

Only available on StudyMode
  • Topic: Data type, Relational database, Table
  • Pages : 8 (2722 words )
  • Download(s) : 62
  • Published : April 29, 2013
Open Document
Text Preview
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.| 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.| Active cell| The cell, surrounded by a black border, ready to receive data or be affected by the next Excel command.| Arithmetic operators| The symbols +, -, *, /, %, and ^ used to denote addition, subtraction (or negation), multiplication, division, percentage, and exponentiation in an Excel formula.| Auto Fill| An Excel feature that generates and extends values into adjacent cells based on the values of selected cells| AutoComplete (Excel)| 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.| AutoFit| An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column.| AutoSum| Another name for the SUM function.|

Category axis| The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis.| 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.| Cell| The intersection of a column and a row.|

Cell address| Another name for a cell reference.|
Cell content| Anything typed into a cell.|
Cell reference| The identification of a specific cell by its intersecting column letter and row number.| Cell style| A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.| Chart (Excel)| The graphic representation of data in a worksheet; data presented as a chart is usually easier to understand than a table of numbers.| 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.| Chart Layouts gallery| A group of predesigned chart layouts that you can apply to an Excel chart.| 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 that solid or transparent, and backgrounds that are dark or light.| Chart Styles gallery| A group of predesigned chart styles that you can apply to an Excel chart.| 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.| Column| A vertical group of cells in a worksheet.|

Column chart| A chart in which the data is arranged in columns and which is useful for showing data changes over a period of time or for illustrating comparisons among items.| 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.| Comma Style| The Excel number format that inserts thousand comma separators where appropriate and applies two decimal places; Comma Style also leaves space at the right to accommodate a parenthesis when negative numbers are present.| Constant value| Numbers, text, dates, or times of day that you type into a cell.| Context sensitive| A command associated with activities in which you are engaged; often activated by right-clicking a screen item.| Data (Excel)| Text or numbers in a cell.|

Data marker| A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point;...
tracking img