Final answer:
The correct answer is b. $K$1, which is the absolute reference in Excel, locking both the column and the row.
Step-by-step explanation:
An absolute reference in Excel is a cell reference that remains constant, even if the formula is copied or moved to another cell. The correct answer to which of the following is an example of an absolute reference in Excel is b. $K$1. This reference style locks both the column and the row. In choice a, the column is locked but not the row; in choice c, the row is locked but not the column; and choice d is not a valid reference in Excel.
An absolute reference in Excel is a cell reference that does not change when copied or filled to other cells. It is denoted by the use of the dollar sign ($). Among the options given, $K$1 represents an absolute reference in Excel. The dollar sign before both the column letter and row number ensures that the reference remains fixed.