The type of cell reference that refers to cells by their fixed position in a worksheet is: A. exponentiation B. absolute C. relative

The correct answer is B. absolute.<br /><br />In spreadsheet software like Microsoft Excel or Google Sheets, a cell reference can be either relative, absolute, or mixed.<br /><br />A relative cell reference refers to the position of a cell relative to the cell where the formula is located. For example, if you have a formula in cell B2 that refers to cell A1, the reference to cell A1 is relative. If you copy the formula from B2 to B3, the reference to cell A1 will change to A2.<br /><br />An absolute cell reference refers to a specific cell by its fixed position in the worksheet, regardless of where the formula is copied or moved. Absolute references are denoted by a dollar sign ($) before the column and row coordinates. For example, $A$1 is an absolute reference to cell A1. No matter where the formula is copied or moved, it will always refer to cell A1.<br /><br />Mixed cell references are a combination of relative and absolute references, where either the column or the row is fixed, but not both. For example, $A1 is a mixed reference that refers to cell A1, but if the formula is copied down, the row will change while the column remains the same.<br /><br />Therefore, the type of cell reference that refers to cells by their fixed position in a worksheet is absolute.