Multiple choice general knowledge

In MS Excel, How can we add dolor sign to our cell formula using keyboard?

  1. Using F4 key in formula bar

  2. Using F2 key in formula bar

  3. Ctrl + F4

  4. Ctrl + F3

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Excel, pressing F4 in the formula bar or cell adds the dollar sign ($) to create absolute references (e.g., A1 becomes $A$1). This locks the cell reference so it doesn't change when copied. F2 is for editing, Ctrl+F4 closes the workbook, and Ctrl+F3 opens the Name Manager.