please show the excel reference

Problem #4: Create a table on a spreadsheet with columns labelled "Count, Date, Interest this Period, and Total. As depicted below. A B D E 1 W N Timestep in years Rate 4 5 6 Count Date 30-Sep-16 Interest this period Total $ key to continue with the selection.) Take a screen shot of your picture, paste it into an application (like Paint), and save it as a (.png) file. Then upload your picture below. Problem #5: Upload Now Save Problem #6: On a new spreadsheet, copy and paste the table from Problem #4 above as values. Then rerun the spreadsheet from Problem #4 with timesteps of half a year, and then with timesteps of one month, pasting the resulting table as values on the new spreadsheet each time. In order to compare the results of the different compounding frequencies, you are to make up a new table of values, using the vlookup function on the values you have just pasted. Create a table as shown: B D E F G 1 00 N 4 Totals from vlookup Total above semi Date Quarterly Semiannual Monthly Quarterly Monthly 30-Sep-16 $ $ 31-Mar-17 5 6 7 8 8 Generate dates starting with Sept 30, 2016, and increasing by 365/2 days up to and including September of 2024. Use the vlookup function to find the total on each date under each of the compounding frequencies. Create columns for the difference of the quarterly total minus the semiannual total, and the monthly total minus the semiannual total. Create a graph with the two differences using the Scatterplot type that shows straight line interpolation between points, but which does not put dots on the data points. (Note: to include a non-adjacent column of data in a selection, use the key to continue with the selection.) Take a screen shot of your picture, paste it into an application (like Paint), and save it as a (.png) file. Upload your picture below. Problem #6: Upload Now Save Problem #4: Create a table on a spreadsheet with columns labelled "Count, Date, Interest this Period, and Total. As depicted below. A B D E 1 W N Timestep in years Rate 4 5 6 Count Date 30-Sep-16 Interest this period Total $ key to continue with the selection.) Take a screen shot of your picture, paste it into an application (like Paint), and save it as a (.png) file. Then upload your picture below. Problem #5: Upload Now Save Problem #6: On a new spreadsheet, copy and paste the table from Problem #4 above as values. Then rerun the spreadsheet from Problem #4 with timesteps of half a year, and then with timesteps of one month, pasting the resulting table as values on the new spreadsheet each time. In order to compare the results of the different compounding frequencies, you are to make up a new table of values, using the vlookup function on the values you have just pasted. Create a table as shown: B D E F G 1 00 N 4 Totals from vlookup Total above semi Date Quarterly Semiannual Monthly Quarterly Monthly 30-Sep-16 $ $ 31-Mar-17 5 6 7 8 8 Generate dates starting with Sept 30, 2016, and increasing by 365/2 days up to and including September of 2024. Use the vlookup function to find the total on each date under each of the compounding frequencies. Create columns for the difference of the quarterly total minus the semiannual total, and the monthly total minus the semiannual total. Create a graph with the two differences using the Scatterplot type that shows straight line interpolation between points, but which does not put dots on the data points. (Note: to include a non-adjacent column of data in a selection, use the key to continue with the selection.) Take a screen shot of your picture, paste it into an application (like Paint), and save it as a (.png) file. Upload your picture below. Problem #6: Upload Now Save