Goal: Examining the formulas developed by others, it can often be beneficial to look at the results of a particular portion of a formula. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Goal: Adding the value 666, 6+6+6 adds up to 18! Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Goal: Force to display the formulas themselves. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Goal:  Use the SUBSTITUTE function to replace dashes with periods in a text string. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Goal: A common technique in scoring and grading is to remove both the high and low score from a series of scores. Microsoft Excel versions: 97 | 2000 | 2002 | 2003