As I mentioned earlier, a formula must begin with an equal sign to inform Excel that the cell contains a formula rather than text. Excel provides two ways to enter a formula into a cell: manually or by pointing to cell references. The following sections discuss each way in detail.

Excel 2007 provides additional assistance when you create formulas by displaying a drop-down list that contains function names and range names. The items displayed in the list are determined by what you’ve already typed. For example, if you’re entering a formula and type the letter T, you’ll see the drop-down list shown in Figure 15-2. If you type an additional letter, the list is shortened to show only the matching functions. To have Excel AutoComplete an entry in that list, use the arrow keys to highlight the entry, and then press Tab. Notice that highlighting a function in the list also displays a brief description of the function. See the sidebar “Using Formula AutoComplete” for an example of how this new feature works.

FIGURE 15-2
Excel 2007 displays a drop-down list when you enter a formula.

• Grocery Shopping for Better Health pt 1 This is part 1 in a 4 part series about knowing how to read labels and excel at grocery shopping...
• Patents are crucial to embryonic stem cell research, scientist says Patents offer the economic guarantees scientists and companies need to develop new treatments, Oliver Bruestle told Deutsche Welle. He's at...
• The Best Healthy Food Alternatives There are a lot of different foods in your daily nutritional plan that can probably be switched out for healthier...
• Factory farming is key to swine flu epidemic In a previous post, we noted the recently published research of Yoshihiro Kawaoka, the eminent Japanse virologist, in which he...
• Excel How-to: The GETPIVOTDATA Function In a previous post, we created a simple pivot table from a list of Excel data.  Today, we'll link the...