o change the relative cell reference A1 to an absolute cell reference you use:1 pointABS(A1)"A1"a1$A$1A$1$

To change the relative cell reference A1 to an absolute cell reference you use:1 point$A$1a1A$1$"A1"ABS(A1)

There are two types of cell reference, absolute and relative. Select the relative cell reference.

In order to create an absolute cell reference, we need to add a sign before the column letter, this can be done by pressing the key after entering your cell reference.

Cell A2 in your worksheet contains the number 50. You want this number to be recognized as a percentage. If you apply the Percentage format to this cell what number would now be showing in A2?1 point5000%500%50%

What are Excel cell references by default?1 pointCell references must be assigned Relative referencesAbsolute referencesMixed references