Respuesta :

Answer:

$A$5

Explanation:

mean in Excel formula?

An absolute reference in Excel exists as a cell address with the dollar symbol ($) in the row or column coordinates, like $A$1. The dollar sign specifies the connection to a given cell so that it stays unchanged no matter where the formula moves.

The A$5 would permit the row position of the authority to remain in place but would permit the column to modify. The location of the $ before either the row or column or both exists what specifies what component stands frozen. Therefore, the correct answer is option b) $A$5.

Complete question:

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

a. A5

b. $A$5

c. $A5

d. A$5

To learn more about Excel formula

https://brainly.com/question/26276255

#SPJ2