Entering Formulas into Your Worksheets
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.
// Related Posted - GOOGLE!
Related Websites
- Top Best free iPod Touch and iPhone Apps - Editor's Choice [/caption] Business Tap Next Remote for Powerpoint, Keynote Score: 8/10 Price: $3.99 Spreadsheet Spreadsheet viewer & editor Score: 8/10 Price:...
- Excel How-to: The SUMIF Function The SUMIF function is an easy way to get a subtotal of specific data that meets a certain condition, without...
- Bioheart Announces Cell Therapies Program in the Middle East for Congestive Heart Failure and Peripheral Arterial Disease Patients (...) Bioheart's MyoCell® is a regenerative cell therapy that uses myoblasts, or muscle stem cells, that are grown from a...
- How to Remove Private Personal Information from the Internet Now that the Facebook privacy firestorm has, for the most part, eased up a bit, people seem to be a...
- Crystal Color Fire Sticks & Pinecones, Crystal Color Sticks User Reviews Send this to a friend Crystal Color Fire Sticks & Pinecones, Crystal Color Sticks Manufacturer: Winter Woods Customer...
