Question

explain in short absolute reference and relative reference and cell reference ​

Answer 1

Answer:

Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign ($). It can precede the column reference, the row reference, or both.

Answer 2

Excel Cell Reference:

• A cell reference in Excel is a cell address. It tells Microsoft Excel where to look for the value you want to use in the formula.

• For example, if you enter a simple formula =A1 in cell C1, Excel will pull a value from cell A1 into C1
• As already mentioned, as long as you write a formula for a single cell, you are free to use any reference type, with or without the dollar sign ($), the result will be the same:
• But if you want to move or copy the formula across the worksheet, it's very important that you choose the right reference type for the formula to get copied correctly to other cells.

Relative Cell Reference (without $ sign):

• A relative reference in Excel is a cell address without the $ sign in the row and column coordinates, like A1
• When a formula with relative cell references in copied to another cell, the reference changes based on a relative position of rows and columns. By default, all references in Excel are relative.
• Supposing you have the formula in cell B1 as A1*10
• If you copy this formula to another row in the same column, say to cell B2, the formula will adjust for row 2 (A2*10) because Excel assumes you want to multiply a value in each row of column A by 10.

Absolute Cell Reference (with $ sign)

• An absolute reference in Excel is a cell address with the dollar sign ($) in the row or column coordinates, like $A$1.
• The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.
• For example, if you have 10 in cell A1 and you use an absolute cell reference ($A$1), the formula =$A$1+5 will always return 15, no matter what other cells that formula is copied to. On the other hand, if you write the same formula with a relative cell reference (A1), and then copy it down to other cells in the column, a different value will be calculated for each row

----So basically if want all of these you can use mixed cell reference,hope you liked my answer, if you liked it mark as brainliest,it would really help me.    :)