In MS-excel if ________ function key is pressed after entering a formula into…
2022
In MS-excel if ________ function key is pressed after entering a formula into a cell in place of Enter key, the result of formula is placed as value in the cell and the formula is removed from that cell.
- A.
F12
- B.
F11
- C.
F10
- D.
F9
Attempted by 1090 students.
Show answer & explanation
Correct answer: D
In MS-Excel, when you enter a formula in a cell and press the F9 function key instead of Enter, the formula is evaluated and replaced with its calculated value. This action removes the formula from the cell and stores only the result as a static value. This is useful when you want to fix the result of a calculation and prevent it from changing due to updates in referenced cells.