FIN 571 NERD Education Specialist /fin571nerd.com FIN 571 NERD Education Specialist /fin571nerd.com | Page 23

converted to a mixed number is ________. 2. The product of one and
four thirty-seconds and twenty thirty-seconds is ________. 3. One and
eight thirty-seconds divided by twelve thirty-seconds is ________. 4.
A U.S. Treasury bond is trading at 98 and 6/32. Convert this price to
its decimal form. 5. What is the percentage increase if the S&P 500
Index is currently trading at 1,100 and rises 55 points? 6. Exponential
Functions This lesson will help you refresh your skills using
exponents. Many financial equations rely on exponents to show
compounding and growth. 1. A business acquaintance promises to
deliver a $20 bill to you one year from today. How much should you
be willing to pay today for this promise? 2. What is the present value
of $1,000 received three years from today if interest rates are
currently 6 percent? 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.