FIN 571 TUTOR Let's Do This /fin571tutor.com FIN 571 TUTOR Let's Do This /fin571tutor.com | Page 37

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?
5. If the bank returns $50 on a $1,000 deposit after one year, what is the
interest rate earned on this deposit?
10. Acco unting Concepts
This lesson will help you refresh the basic accounting concepts.
1. ________ are items owed to a creditor. ________ are items owned by a
company. ________ represents owners' claims to company resources.
2. Under ________ accounting, revenues are recorded when earned and
expenses are recorded with related revenues. Under ________ accounting,
revenues are recorded when cash is received and expenses are recorded
when cash is paid out. Financial statements are prepared using ________
accounting.
3. The ________ retains the power and authority to set accounting
standards. Currently, this responsibility has been delegated to
the________.
4. In what order are the four primary financial statements prepared?