Question

Write the steps (Attempt any three):-

a) To make modification in the cell contents using the Edit mode.

b) To insert multiple columns in a worksheet.

c) To move data in a worksheet using the dragging method.

d) To select a range of non-adjacent cells in a worksheet.​

Answer 1

a)To start working in Edit mode, do one of the following:

1. Double-click the cell that contains the data that you want to edit. ...
2. Click the cell that contains the data that you want to edit, and then click anywhere in the formula bar. ...
3. Click the cell that contains the data that you want to edit, and then press F2.

b)  To insert multiple columns in a worksheet.

1. Select the heading of the column to the right of which you want to insert additional columns. Tip: Select the same number of columns as you want to insert. ...
2. Hold down CONTROL, click the selected columns, and then on the pop-up menu, click Insert.

c) To move data in a worksheet using the dragging method.

1. To move or copy a selection using drag-and-drop:
2. Select the cells that contain the data or object you want to move or copy.
3. Position the pointer on the border of the selection.
4. Move the selection by holding down the mouse button and dragging-and-dropping the selection to the new location.

Hope You Gotcha!