Www.radford.edu



Math 114

Excel Practice Problems

Fall 2009

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.

|Original Price |With 5% Off |With 10% Off |With 15% Off |With 20% Off |With 25% Off |

|59.95 |

|42.95 |

|39.99 |

|104.98 |

2. Create a Microsoft Excel spreadsheet that will calculate simple interest on the following principal amounts, interest rates, and times invested in a saving account. BE CAREFUL TO INCLUDE CONVERTING PERCENTS TO DECIMALS!!!

The simple interest formula is I = P x Rx T

The total simple interest amount formula is A = P x (1 + RxT)

|Principal |Interest Rate |Years in Account |Simple Interest |Total Amount |

|$1500 |5% |3 | | |

|$1500 |3% |4 | | |

|$1500 |4% |2 | | |

|$2000 |2.5% |3 | | |

|$2000 |3.2% |2 | | |

|$2000 |2% |5 | | |

|$2000 |5% |3 | | |

3. On a different spreadsheet, 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!!!

|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 spreadsheet, create your homework problem on credit card debt. Your spreadsheet should look similar to the provided table below. Let Excel do the calculations for you by creating equations within the spreadsheet.

|Date |Payments/Purchases |Balance on Card |Number of Days |Total |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

Average Daily Balance is:

Finance Charge for the month is:

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download