Question

which character is used to create an absolute reference to a cell?
=
$
!
()

Explanation:

In spreadsheet software like Excel, the $` character is used to create an absolute reference to a cell. An absolute reference keeps the row and/or column fixed when a formula is copied or filled to other cells. For example, `$A$1 is an absolute reference to cell A1. The = character is used to start a formula. The ! character is used to separate the sheet name from the cell reference (e.g., Sheet1!A1). The () characters are used in functions to enclose arguments (e.g., SUM(A1:A10)).

Answer:

$ (the second option)