Www.radford.edu
Math 114
Excel Practice Problems
Fall 2011
1. Create a Microsoft Excel spreadsheet that will calculate the following information regarding sale information given the original price of items and the discounted prices. We will do this together to show how Excel can create such a table.
USE THE FORMULA: =A2-A2*0.05 in the cell below “5% Off”
|Original Price |5% Off |10% Off |15% Off |20% Off |
|59.95 | | | | |
|42.95 | | | | |
|39.99 | | | | |
|104.98 | | | | |
2. On a different sheet, spreadsheet that will calculate simple interest and total amount in accounts based on the following principal amounts, interest rates, and times invested in a saving account. Also find the average of the interest you earned in the accounts.
USE THE FORMULA: =ROUND(A2*(B2/100)*C2,2) in the cell below “Simple Interest”
|Principal |Interest Rate (Percent) |Time (Years) | Simple Interest |Total Amount in Account |
|7456.78 |3.5 |5 | | |
|6000 |3.6 |4 | | |
|10000 |4.6 |8 | | |
|9000 |2.2 |5 | | |
3. On a different sheet, create another Excel spreadsheet that calculates the following information regarding the sales price of cars and the savings passed to a consumer off of the retail price of the car. AGAIN, BE CAREFUL TO INCLUDE CONVERTING PERCENTS TO DECIMALS!!!
CREATE YOUR OWN FORMULAS!!
|Retail Price of the Car |Percent Discount |Sales Price of the Car |Savings to the Customer |
|35,000 |30 | | |
|50,000 |25 | | |
|25,000 |35 | | |
|45,000 |15 | | |
4. On a different sheet, create a Microsoft Excel spreadsheet that will calculate the total amount and interest earned in accounts based on the following principal amounts, interest rates, compounds, and times invested in a saving account. Also, find the average of the interest you earned in the accounts.
USE THE FORMULA: =ROUND(A2*POWER(1+((B2/100)/(D2)),C2*D2),2)
in the cell below “Future Amount”
|Principal |Interest Rate (Percent) |Time (Years) |Compounds Per Year |Future Amount |Interest Earned |
| 10000 |3.5 |4 |12 | | |
| 5000 |5.6 |10 |4 | | |
| 7000 |5.7 |10 |52 | | |
| 5000 |1.8 |10 |4 | | |
5. Find the monthly payments of each given the amount borrowed, the interest rate, and the length of the loan.
USE THE FORMULA:
=ROUND((A2*(B2/100)/12)/(1-POWER(1+(B2/100)/12,-12*C2)),2)
in the cell below “Monthly Payment”
|Borrowed Amount |Interest Rate |Years to Repay Loan |Monthly Payment |Total Amount to be Re-paid to Bank |
|50000 |4 |30 | | |
|100000 |5 |15 | | |
|560000 |3.2 |30 | | |
|250000 |6.4 |30 | | |
|300000 |4.5 |15 | | |
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- sba loans business plan template bmo harris bank
- sample cost and price analysis
- introduction to excel formulae functions exercises
- university of bahrain yaqoob al slais
- introduction to formulae and functions exercises
- personal web space basics university of baltimore
- solutions for homework accounting 311 cost winter 2009
Related searches
- minecraft edu edition
- https www municipalonlinepayments
- minecraft edu download free
- minecraft edu edition recipes
- minecraft edu mod download
- minecraft edu launcher download
- minecraft edu free download
- alsde edu contacts
- edu perfect
- edu minecraft launcher
- minecraft edu free download pc
- minecraft edu classroom mode