Operations Performed in MS Excel

Worksheet is the actual working area consisting of rows and columns. The worksheets arc also known as the spreadsheets. A workbook in MS Excel is a combination of several worksheets. Each workbook of MS Excel contains three worksheets by default. The key operations that are performed in MS Excel include:

• Creating a worksheet
• Saving a worksheet
• Modifying a worksheet
• Renaming a worksheet
• Deleting a worksheet
• Moving a worksheet
• Editing a worksheet

Creating the worksheet:

We can create a worksheet in MS Excel by simply inserting the data in the cells of the worksheet. To create a worksheet, perform the following steps: 

• Open the Microsoft Excel – Book1 window.
• Insert the data into the cells according to the requirement,

Saving the worksheet:

After entering the data in the worksheet, we need to save the worksheet at the desired location in the computer system. To save a worksheet, perform the following steps: 

• Select File ⇒ Save As to display the Save As dialog box.
• Select a location from the Save in list where the worksheet is to be saved.
• Enter the name of the file in the File name text box.
• Click the Save button to save the file.

Modifying the worksheet:

A worksheet in MS Excel can be modified in the following two ways: 

• By inserting rows and columns in the existing worksheet.
• By changing the width or height of rows and columns.

Renaming the worksheet:

Usually the default names of the worksheet in MS Excel are Sheet 1, Sheet2, Sheet 3 etc. In order to rename the worksheet, we need to perform the following steps:

• Open the Microsoft Excel – Book1 window.
• Right-click the Sheet 1 tab to display a shortcut menu.
• Select the Rename option and change the name of worksheet

Deleting the worksheet:

In order to delete a worksheet from the workbook, we need to perform the following steps:

• Open the Microsoft Excel - Book 1 window.
• Right-click the Sheet2 tab to display the shortcut menu.
• Select the Delete option to delete the Sheet2 worksheet.

Editing the worksheet:

In order to edit a worksheet in the workbook, we need to perform the following

Steps:

• Open the Microsoft Excel - Book 1 window.
• Double-click the cell in which we want to make the changes.

• Enter the new data in the cell.

Questionnaire:

• What are the basic operations performed in MS Excel?