Help a student

[Harry1003]

Hi Guys,


I'm currently at college, and on my new course, we have started a module that goes over spreadsheets. As I am very new to using spreadsheets, would it be possible if anyone could give me any guidance on completing this task?


I will attach a dropbox link for you to view the question sheet and any help would be greatly appreciated!


https://www.dropbox.com/s/a4z4ore47ua0yo6/Screenshot 2019-03-25 14.32.40.png?dl=0


Thanks

 

[Kenneth Hobson]

Welcome to the forum!

It would unethical to help with homework problems and against some forum rules.

We can help with concepts. e.g. How to fill a 2 dimensional array. For the most part, it looks like this is more of a tabular math sort of solution. Once you have the table or matrix of data of x and y, that is easily plotted by selecting those 2 columns of data and on ribbon, Insert > Recommended Charts or the other specific chart categories and types.

The financial formula functions might help at some point. Click fx icon on the formula toolbar and select Financial category. If you search for "excel amortorize", you will find examples for that.