Answer:
Any formula entered in the excel sheet should begin with “=”. Otherwise excel reads that to be a normal text and it will not process the further to get a “result”.
A formula can be entered either in the cell or in the “formula bar”. Once a formula is entered and an enter key is encountered, the result will be displayed in the cell and connected formula gets displayed in the Formula bar.
When we move the focus over that cell it displays only content and not formula, because formula gets displayed only in the “formula bar”.