Excel Glossary: A

active cell: The worksheet cell that contains the cell cursor. Each worksheet can have only one active cell.

Analysis ToolPak: An Excel 2007 add-in program that adds extra financial, statistical, and engineering functions to Excel's pool of built-in functions.

AutoComplete: A feature that looks at the entries that you make in a worksheet column and automatically duplicates them in subsequent rows whenever you start a new entry that begins with the same letter or letters as an existing entry in that column.

AutoCorrect: A feature that alerts Excel 2007 to common typing errors and your own typing errors (that you specify) and tells the program how it should automatically fix them for you.

AutoFill: An Excel 2007 feature that quickly creates a series of entries based on the data you enter in one or two cells. AutoFill works with days of the week, months of the year, yearly quarters; consecutive series of numbers; and formulas. You also can add your own custom AutoFill series.

AutoFilter: A feature in Excel 2010 that enables you to temporarily hide everything in a table except the records you specifically want to view, based on criteria you specify.

  • Print
  • Share

Inside Dummies.com

Music, Pictures & Video

Other Topics in Microsoft Office