AC341 - Excel Lab 1. Summation a. =SUM() b. AutoSum 2. Linking Sheets a. Formula starting with an operation (+,-,=) b. Start in the sheet you want the information displayed 3. Eliminating Hard Coded Data a. Within a sheet i. Link to a source sheet ii. Ease of data entry/downloading b. Within a formula i. Link formula components to another cell ii. Reference can be within the same sheet or another sheet 4. Linking Files a. One file displays information included in a different file b. Updated when opened 5. Random Number Generation a. RAND() b. Monte Carlo simulation c. Used for unpredictable events (i.e. weather) 6. Comments a. Insert Comment b. Used for documentation/explanation 7. Regression a. Tools, Data Analysis, Regression b. Interpret Results 8. If-then and Nesting a. IF(a