style, enter Invalid Entry as the title and Please select a valid method. as the error message.
18 On the CarLoan worksheet, in cell G10, use the
6
CUMPRINC function to calculate the cumulative principle paid on the car loan. Use the data in the range E4: E6 when entering the first three arguments in the function. Reference cell A10 as the start and end period arguments. Enter 0 as the type argument. Modify the function to convert the results to a positive value. Make the row references absolute in all arguments except for the end period. Copy the formula down through cell G19.
19 From Excel, open the downloaded tab-delimited text
4 fileeV2 _ stocks. txt using a data format of general. You do not need to create a connection to the original data file. Copy the range A1: F5 and then close the text file. Paste the copied range onto the Stocks worksheet in cell A3.