FIN 571 Course Great Wisdom / tutorialrank.com FIN 571 Course Great Wisdom / tutorialrank.com | Page 18

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 ________.
4. If the future value of a one-period investment is given by the
formula, F = I + (I × R), what is the formula for the rate of interest, R?