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.
| An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column.
| Another name for the SUM function.
| 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.
| The intersection of a column and a row.
| Another name for a cell reference.
| Anything typed into a cell.
| 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.
| A vertical group of cells in a worksheet.
| 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.
| A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point;...
Please join StudyMode to read the full document