Question

if you had a cell reference C5, but in your formula you want C to stay constant and 5change would be the correct structure​

Answer 1

Answer:

'$' sign is used to keep something constant

Explanation:

so if the cell reference is C5 you and you want C to stay constant and 5 to uniform the the structure would be '$C5'

Answer 2

Answer:

The answer is $C5.

Explanation:

i) In Excel spreadsheets or Google Sheets, you can apply formulas to ranges by dragging  reference cells.

ii) You can add a "$" character before the row or column notation to keep the referenced row or column constant.

iii) Therefore, if you want to keep column C constant, add $ before C in C5.

iv) The answer is $ C5.

#SPJ3