DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
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.
|
|
|
Either A or B
|
|
|
None of the above
|
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.