3-D reference

A pattern for referring to the workbook, worksheet, and cell from which a value should be read

active cell

The cell that is currently selected and open for editing


A supplemental program that can be used to extend Excel’s functions


The manner in which a cell’s contents are arranged within that cell (for example, centered)


The specific data a function requires to calculate a value

aspect ratio

The relationship between a graphic’s height and width


The process of examining a worksheet for errors


The ability to complete data entry for a cell based on similar values in other cells in the same column


The ability to extend a series of values based on the contents of a single cell

AutoFilter ...

Get Microsoft® Office Excel® 2007 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.