Radford
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.