Sample Exam-type Problems

Problem #1: The first few fibonacci numbers are: 1,1,2,3,5,8,... where the first two numbers are always 1,1 and each subsequent number is found by adding the previous two. In one column, I would like you to find the first 12 fibonacci numbers. In a column next to this one, I would like you to find the first 12 solutions to the equation: y = x^2 over the interval 1 <= x <= 12 where x is an integer. Once you have these two columns laid out, in a line graph underneath these columns show the graph of each set of numbers with all axes properly labeled and a chart title.

Problem#2: Solve the following problem. A friend of yours just got his first credit card and decided to buy a very nice surround sound stero system for his TV. The system cost was $980.00. As most credit cards work, you can make the minimum payment suggested with the monthly statement and you will remain in good standing with the credit card company. When the monthly statement arrived he was quite pleased to find that the minimum payment was $20. As many people do, he decided to make the minimum monthly payment becuase he really didn't have the money to pay off the entire debt. After hearing what your friend was doing, you decided to design a SS that shows your friend how long it will take him to pay off the debt if he continues to make the minimum payment and the yearly interest rate is 19.5%.

Design the SS with the following column headings:

1) Beginning Balance - balance at the beginning of the month
2) Monthly Interest - interest charged for the month
3) Minimum Payment - minimum monthly payment
4) Ending Balance - beginning balance plus monthly interest minus minimum payment.
5) Month - month that goes 1, 2, 3, ...

Allow the user a place on the worksheet to enter:

1) Beginning Balance
2) Minimum Payment
3) Fixed Interest Rate

In another cell at the top of the SS, show the amount of interest paid.

Here is a sample of the beginning of the spreadsheet. I have not included the total interest paid in this sample, but you need to in your solution. Hopefully, this will help, but ask if you are not sure.