The correct answer is C: F4. In Microsoft Excel, the F4 function key serves as the primary shortcut to repeat the last action performed. This is incredibly useful for repetitive tasks, such as applying the same formatting, inserting a row, or copying a formula multiple times. For example, if you bold text in one cell, selecting another cell and pressing F4 will bold the text in that new cell.
A: F2 is used to edit the active cell. When you press
F2, the cursor appears at the end of the text in the active cell, allowing you to modify its contents without double-clicking.B: F3 is often used to display the 'Paste Name' dialog box in Excel, which allows you to insert a defined name into a formula. It does not repeat the last action.
D: F5 is used to open the 'Go To' dialog box, allowing you to quickly navigate to a specific cell, range, or named item in your workbook. It is not used to repeat the last action.