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.