## Search Results

### 10 results for "Peter G. Aitken"

• #### Finding the Correct Function in Excel 2007

The first step to using a function in Excel 2007 is finding the one you need! Even when you know the one you need, you may not remember all the arguments it takes. To find a function, open the Insert Function

• #### Tracing Precedents and Dependents in Excel 2007 Formulas

Excel 2007 formulas may contain precedents and may serve as dependents to other formulas. Precedents are cells or ranges that affect the active cell’s value.

• #### Avoiding Circular References in Excel 2007 Formulas

A circular reference occurs when a cell in an Excel 2007 worksheet refers to itself, whether directly or indirectly. For example, if =100+A2 is entered into cell A2, then a direct circular reference has

• #### Controlling Excel 2007 Formula Calculations Manually

By default, Excel 2007 calculates your formulas automatically as they are entered or when you modify the worksheet. You can switch to manual calculation when necessary. Leaving the setting on automatic

• #### Using Functions in Excel 2007 Formulas

In Excel 2007, functions are like built-in formulas that perform simple to complex tasks. For example, the SUM function sums up numbers, the COUNT function counts, and the AVERAGE function calculates an

• #### Evaluating and Checking Errors in Excel 2007

The Evaluate Formula dialog box in Excel 2007 walks you through the steps used in calculating a result from a formula. This helps locate errors in formulas that are long, or have precedents. For example

• #### How to Build Excel 2007 Formulas with the Insert Function Dialog Box

The Insert Function dialog box in Excel 2007 is designed to simplify the task of using functions in your worksheets. The dialog box not only helps you locate the proper function for the task at hand but

• #### Fixing Broken Formula Links in Excel 2007

Formulas in Excel 2007 can reference external workbooks. Links become broken when external workbooks are moved, deleted, or renamed. When a workbook that contains an external reference is opened but cannot

• #### How to Display All Formulas in an Excel 2007 Worksheet

In Excel 2007, it can be difficult to view your formulas without accidentally editing them. That’s because anytime you are in “edit” mode and the active cell has a formula, the formula might incorporate

Found in: Managing
• #### Using Absolute and Relative References in Excel 2007 Formulas

You can use three types of cell references in Excel 2007 formulas: relative, absolute, and mixed. Using the correct type of cell reference ensures that formulas work as expected when you copy them to another

#### 1 result for "Peter G. Aitken" in the store

 About us More From Dummies Topics A-Z