## 63 terms · Go! with Microsoft Excel 2010 Comprehensive

### row heading

a number at the far-left side of a row that can be clicked to select the entire row of cells

### fill handle

the small black square in the lower right corner of a selected cell, lets you copy cell contents or continue a series of data into a range of selected cells

### Auto Fill

generates and extends a series of values into adjacent cells based on hte value of other cells

### point and click method

Allows you to point and click each cell in a formula rather than typing cell references

### rounding

a procedure that determines which digit at the right of the number will be the last digit displayed and then increases it by one if the next to its right is 5-9

### relative cell reference

a cell reference based on the relative position of the cell that contains the formula and the cells refered to

### cell style

a defined set of formatting characteristics, such as font, font size, font color, cell borders and cell shading

### Accounting number format

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 when negative numbers are present

### chart types

ways you can display data in a way that is meaningful to the reader; e.g. column charts, pie charts, and line charts

### category labels

labels that display along the bottom of the chart to identify the category of data; category axis or the x-axis

### value axis

on the left of the chart, excel includes a numerical scale on which the charted data is based; y-axis

### legend

on the right, identifies the tterns or colors that are assigned to the categories in the chart

### data marker

a column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point

### chart layout

a combination of chart elements, which can include a title, legend, labels for the columns, and the table of charted cells

### chart styles

the overall visual look of the chart in terms of its colors, backgrounds and graphic effects such as flat or beveled columns

### normal view

maximizes the number of cells visible on your screen and keeps the column letters and row numbers closer

### scaling

shrinks the width (or height) of the printed worksheet to fit a maximum number of pages, and is convient for printing formulas

### range finder

the referenced cells are displayed in color and bordered with the same color; useful for verifying formulas because it visually indicates which workbook cells are included in a formula calculation

### Autosum

a function that automatically adds the values in the cells directly above or to the left of the active cell

### operators

symbols with which you can specify the type of calculation you want to perform in a formula

### sheet tab scrolling buttons

display sheet tabs that are not in view when there are numerous sheet tabs

### status bar

displays the current cell mode, page number, worksheet information, view and zoom buttons, and for numerical data, common calculations such as Sum and Average