BUSINESS ADMINISTRATION
COMPUTER APPLICATION IN BUSINESS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Double-click on the cell and edit the formula in the cell.
|
|
|
Select the cell and edit the formula in the Formula Bar.
|
Detailed explanation-1: -A cell has a very long formula that you must edit. What is the best way to edit the formula? Double-click on the cell and edit the formula in the cell.
Detailed explanation-2: -Click the cell that contains the data that you want to edit, and then click anywhere in the formula bar. This starts Edit mode and positions the cursor in the formula bar at the location that you clicked. Click the cell that contains the data that you want to edit, and then press F2.
Detailed explanation-3: -#1 – Enter & Edit Modes with F2 When you have a cell selected, pressing the F2 key puts the cell in Edit mode. If the cell contains a formula, you will see the formula in the cell and be able to edit it. This is the same as double-clicking the cell with the mouse.
Detailed explanation-4: -If you change your mind, you can press the Esc key on your keyboard or click the Cancel command in the formula bar to avoid accidentally making changes to your formula.