Excel Basics:




Formulas use numbers from other cells on the sheet, or even from other sheets or other workbooks to do calculations. You can use AutoFill when you have to create a set of similar formulas. What a time saver! Excel is really, really smart when it comes to formulas. But don't let Excel outsmart you! When you copy a formula into another cell, Excel will modify the formula. If you copied into the next cell down the column, for example, all the cell references in the formula are changed down one cell. What does this look like? Suppose you have in cell G3 the formula = A3*B3/D4. If you copy the formula down one cell into G4, Excel changes the formula to =A4*B4/D5. All the cell references are changed down one, so that they are in the same relative location, compared to the cell with the formula. For more on formulas, read the extra material in the Appendix and do the review exercises. 
Project 2: Excel Basics
Search Glossary Appendix 

When a trip is sold at World Travel Inc., the Total Sale is calculated by multiplying the number people going on the trip by the cost per person. You will create the formula that calculates this. Then you will copy the formula to other Total Sale cells. Start with: trips5.xls (saved in previous lesson) Formula: Enter
AutoFill: Formula
If you find
some of your numbers look like ######, the column is just not wide enough to
show all the digits in the numbers. Simply make the column wider. 
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~ 