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 .