Question

What happens when you select a cell in MS Excel and type  "=B25" ?

1. The selected cell will show '=B24'
2. The selected cell will show an error
3. The selected cell will show the value that is contained in cell B25
4. The selected cell will be blank

Answer 1

Correct Answer - Option 3 : The selected cell will show the value that is contained in cell B25

The correct answer is The selected cell will show the value that is contained in cell B25.

• When you select a cell in MS Excel and type  "=B25"  then the selected cell will show the value that is contained in cell B25.
• In MS-Excel Equal (=) sign means that you enter either a calculation or function for the selected cell.
• Therefore, when the equal sign is entered after any cell it takes its value. 

• Using $ in cell references allows you to copy the formula in Excel without changing references. 
• When you are entering information in a cell, Excel recognizes the information as a formula if you start it with an equal sign.