| A | B |
| sheet reference | reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address |
| 3D reference | refers to a cell in the same location but on separate sheets in a workbook |
| 3D range | range that spans two or more sheets in a workbook |
| drilling an entry | name of the technique of entering a number once and copying it so that it is entered in the same cell on all selected worksheets |
| group | group on the Page Layout Ribbon contains commands used to organize objects placed in the worksheet |
| show | group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings |
| split | command separates a worksheet window into four individual panes |
| new window | command creates a new view of the current document in a separate window |
| tile | command will tile Excel 2010 windows and all other program windows so that they appear side by side on the screen |
| zoom to selection | command do you use to increase or decrease the size of a selected cell or range of cells to fill the Excel Window area for better visibility |
| freeze panes | feature of Excel 2010 keeps a portion of a worksheet visible while the other portion scrolls |
| sheet tabs | appears at the bottom of an Excel 2010 workbook to distinguish individual worksheets |