Chapter 6: Performing Calculations on Data


Page 124

To name a range of cells

 
  1. Select the cells to be included in the range.

  2. Click in the Name Box .

  3. Type the name of the range, and press F.

126

To write a formula

 
  1. Click the cell into which the formula will be written.

  2. Type an equal sign, and then type the remainder of the formula.

126

To enter a range into a formula

 
  1. Click the cell into which the formula will be written.

  2. Type an equal sign, and then type the first part of the formula.

  3. Select the cells to be used in the formula.

  4. Finish typing the formula.

126

To create a formula with a function

 
  1. Click the cell where you want to create the formula.

  2. On the Insert menu, click Function .

  3. Click the function you want to use, and then click OK .

  4. Type the arguments for the function in the argument boxes, and then click OK .

126

To create a formula with a conditional function

 
  1. Click the cell where you want to create the formula.

  2. On the Insert menu, click Function .

  3. In the Select a function list, click IF , and then click OK .

  4. In the Logical_test box, type the test to use.

  5. In the Value_if_true box, type the value to be printed if the logical test evaluatesto true. (Enclose a text string in quotes.)

  6. In the Value_if_false box, type the value to be printed if the logical test evaluatesto false. (Enclose a text string in quotes.)

132

To trace precedents or dependents

 
  1. Click the cell from which to trace precedents or dependents.

  2. On the Tools menu, point to Formula Auditing and then click Trace Precedents or Trace Dependents .

132

To use the Error Tracking tool

 
  1. Click the cell containing the error.

  2. On the Tools menu, click Error Checking .

  3. Use the controls in the Error Checking box to examine the formula containingthe error.




Microsoft Office 2003 Step by Step
MicrosoftВ® Office ExcelВ® 2003 Step by Step (Step By Step (Microsoft))
ISBN: 0735615187
EAN: 2147483647
Year: 2005
Pages: 350
Authors: Curtis Frye

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net