Which type of cell references are locked and NO Tautomatically updated when copied? Fomula Relative Absolute Worksheet

## Step 1<br />In spreadsheet programs like Microsoft Excel, cell references are used in formulas to indicate the location of data. There are three types of cell references: relative, absolute, and mixed.<br /><br />## Step 2<br />Relative cell references change when a formula is copied to another cell. For example, if a formula in cell B2 refers to cell A1, and the formula in cell C2 is a copy of the formula in cell B2, the reference to cell A1 in the formula in cell C2 will change to cell B1.<br /><br />## Step 3<br />Absolute cell references, on the other hand, remain constant no matter where they are copied. They are denoted by a dollar sign ($) before the column and row coordinates. For example, $A$1 is an absolute reference to cell A1.<br /><br />## Step 4<br />Mixed cell references have a dollar sign in front of the row or column coordinate, but not both. For example, $A1 or A$1.<br /><br />## Step 5<br />Given the options provided, the type of cell references that are locked and not automatically updated when copied are absolute cell references.