FIN 571 TUTOR Future Starts Here/fin571tutor.com FIN 571 TUTOR Future Starts Here/fin571tutor.com | Page 14

3. What is the interest rate on a three-year investment with a future value of $ 1000 and a present value of $ 863.84? 4. The product rule of exponents says that when multiplying two powers that have the same base, you need to ________. 5. The fifth root of fifteen is equal to ________. 7. Basic Math This section of the tutorial will cover writing and editing formulas, using cell references, following the order of operations, and using operators. 1. Which of the following Excel cell entries gives the sum of 20 + 150 + 85? 2. Which letter or symbol does Excel use to multiply numbers? 3. What is the correct order of operations for entering formulas into Excel? 4. Which of the following sequences will give you the square root of 25 in Excel? 5. Suppose you need to add the values in range of cell from C2 through C8. Which of the following sequences will give you the correct answer? 8. Organizing Data This tutorial is designed to help you to successfully utilize Microsoft Excel in your finance courses. 1. You are working on an Excel table and realize that you need to add a row to the middle of your table. What is one way to do this? 2. You are working on an Excel table and realize that you need to add a single cell to your table. What is one way to do this? 3. You are working on an Excel table and realize that you need to delete a column in the middle of your table and shift the remaining data columns to the left. What is one way to do this? 4. You are valuing an investment that will produce cash flows of $ 10,000 each year for 15 years. What is the quickest way to enter $ 10,000 into each of the 15 cells of your table? 5. You have three tables in a worksheet in Excel. You need to sort one of the tables numerically, from smallest to largest values. How can you do this? 9. Solving for the Unknown This lesson will help you review how to solve for unknown quantities in a problem. 1. If the future value of a one-period investment is given by the formula, F = I +( I × R), what is the formula for the amount of the investment, I? 2. The opposite process rule says to solve for ________. 3. When solving for an unknown that involves more than one process, the multiple process rule requires that ________.