Question

V. Write all the steps to perform the following tasks in MS Excel 1. Naming a Sheet Tab 2. Renaming Sheet Tab 3. Deleting a Sheet Tab 4. Selecting partial range in a row 5. Selecting partial range in a column. ​

Answer 1

Answer:

C3. Match the two columns.

Column A

1. Cotton

2. Jute

3. Silk

4. Separating of cotton fibres from seeds

5. Spinning

6. Handlooms

Column B

(i) Animal fibre

(ii) Ginning

(iii) Charkha

(iv) Bolls

(v) Weaving

(vi) Cheapest plant fibre

Answer 2

Explanation:

Naming a sheet tab

Select the sheet tab that you want to name .Double click on the sheet tab and enter an appropriate name. press the 'enter' key. Renaming a sheet tab. Select the worksheet which you want to rename right click on the sheet name select rename option from the drop down menu retain the sheet and press Enter key. Deleting a sheet tab. Select the sheet tab that you want to delete right click on the sheet tab select the option delete and press enter key.

selecting partial range in a row select the row bring the cell pointed to the desired location from where you want to start your selection click the left mouse button and keep dragging to your right till you reach the last cell to be selected release the mouse button. Selecting partial range in a column. Click on any cell in the column and then press shift + key .to select non adjacent cell and cell range , hold control and select the cells.