case study

The situation is that you have to model a loan payment calculator and have 

found a YouTube video to show you how to do that. Most people learn from online videos, and you are no exception. You also wanted to learn about using data 

tables in the Microsoft Excel spreadsheet software, and this is your chance to model 

and use that feature since it is covered in the video. 

o Requirements: 

▪ Using the data table video https://www.youtube.com/watch?v=y7S9ecg1wdQ 

by Chris Menard, reproduce the spreadsheet that the speaker demonstrated.