Question Discussion & Solution

Show Formula bar option by clicking the File (or Office button) > Options > Advanced > Display > Show Formula bar.
In earlier versions of Excel, you could hide the status bar if you wanted more space available for your worksheets. However, that capability was removed starting with Excel 2007.
In earlier versions of Excel, you could hide the tool bar as per requirement. However, that capability was removed starting with Excel 2007 and introduced Ribbon.

Click the Currency Style button on the formatting toolbar

Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.

In Excel, a Data Series is defined as a collection of related data. A data series is just a fancy name for a collection of related numbers in the same row, or the same column.