Question

Answer the following:
1.How will you make modification in the cell contents using the Edit mode?
2.Explain the method to insert multiple columns in a worksheet.
3.What is the function of Undo and Redo commands?
4.How will you select a range of non-adjacent cells in a worksheet?​

Answer 1

Explanation:

1.How will you make modification in the cell contents using the Edit mode?

answer:

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.

2.Explain the method to insert multiple columns in a worksheet.

answer :

Insert columns

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. ...

Hold down CONTROL, click the selected columns, and then on the pop-up menu, click Insert.

3.What is the function of Undo and Redo commands?

answer :

The undo function is used to reverse a mistake, such as deleting the wrong word in a sentence. The redo function restores any actions that were previously undone using an undo.

4.How will you select a range of non-adjacent cells in a worksheet?

answer :

Below is how to select two non-adjacent range of cells:

Click on the first cell that you want to be selected. ...

Hold the Control key on your keyboard.

Left-click on the mouse and drag to make the selection.

Leave the mouse click. ...

Place the cursor on the second cell/range that you want to select.