Spreadsheet Skills
Microsoft Excel 97

Adams Toolkit:
Check that an Excel formula is correct
   
In the Lab
On your PC

Self Assessment

Basic PC Operation

 

When working with spreadsheet formulas, it is important to check your formulas to make sure that they are correct. The easiest way to do this is to run the formulas on values that you can easily calculate the answer for.

For example, if you have an addition formula (A1 + B1) in cell C1, try the number 2 in both A1 and B1 to see if the result displayed in C1 is 4. Then replace one of the twos with an 8 to see if the value in C1 changes to 10. Use of similar substitutions for subtraction, multiplication, division, and combined operations will help you develop a spreadsheet that gives you valid results.


Use the links below for tips on how to perform other Spreadsheet functions using Microsoft Excel 97.


Copyright © 2001 Bruce LeNeal Adams. All rights reserved.

Questions and comments to bladams@msn.com