In the formula, which symbol specifies the fixed columns or rows?

Answer: Option A

The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.