Name box left and formula bar right - Name box shows address of current cell - Formula bar shows contents of current cell. These formulas we can use in Excel 2013. A name created by using this procedure refers only to the cells that contain values and does not include the existing row and column labels.
In Excel 2016 this function is replaced with FORECASTLINEAR as part of the new Forecasting functions but its still available for compatibility with earlier versions.
The CFI Excel book is a great way to jumpstart your spreadsheet knowledge. This comprehensive book explains how to create financial formulas release the power of array formulas develop custom worksheet functions with VBA debug formulas and much more. The arguments are contained inside round brackets. For more information about the new functions see Statistical functions reference and Math and trigonometry functions reference.