Question

Gabriel needs to create a formula that does not change when it is copied to cell b2. which formula should he create?

Answer 1

=sum(1+1)  it's a simple formula and won't change from any cells. Another you can do is to put a value in a specific cell, let's say, C3. Then have a formula that says, =sum(C3+2). But if you REALLY wanna impress someone - put a value in A1 - anything at all. Then put this formula in any other cell you want. If you change cells, you get a different answer. If you change the # in A1, you get different answers, all thanks to the RANDom function.  =SUM((RAND()*100)+A1)