You are building a formula in Excel, and you intend to copy the formula into many destination cells. All instances of the formula you create are intended to refer to the same period begin date, which is located in cell C10 of your spreadsheet. How can you create an absolute reference to cell C10 in your formula? (select all valid responses)

Group of answer choices

Type C&"TEN" in your formula in the place where you want to create an absolute reference to cell C10

Type $C$10 in your formula in the place where you want to reference cell C10

Give cell C10 the name "Begin_date" and refer to "Begin_date" in place of cell C10 in your formula

Use cell C10 in your formula, and press the [F4] key one time after entering C10 in your formula