FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The most efficient way to edit a cell is to hit the F2 key when on the cell. This keeps our hands on the keyboard. You can now move left and right inside the formula using the and symbols. However, if you want to move outside the cell again to modify cell references, hit the F2 again.

Detailed explanation-2: -Everybody (well, almost everybody) knows that pressing the F2 key in Excel activates the “editing” mode for the active cell – the cursor goes into the cell so that you can change the contents and the various cell references in that formula turn different colours.

Detailed explanation-3: -By holding “Alt + F2” keys together the “Save As” dialog box opens for saving the excel workbook.