Mastering the Essentials: An Overview of MS Excel Fundamental Concepts

In Microsoft Excel, basic spreadsheet concepts serve as the foundation for creating and manipulating data efficiently and effectively within a professional setting. Understanding these concepts is crucial for maximizing productivity and accuracy when working with large sets of data.

1. Created by: Ms. Aeshwarya Chauhan MS Excel Basic Concepts

2. Basic operations performed in MS Excel Basic operations p erformed in MS Excel Worksheet is the actual working area consisting of rows and columns. The worksheets are 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.

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

4. Creating a Worksheet We can create a worksheet in MS Excel by simply inserting the data in the following steps. To create a worksheet, perform the following steps: Open the Microsoft Excel-Book 1 window. Insert the data into the cells according to the requirement.

5. Creating a Worksheet To create a worksheet, follow these steps: Click on 'File' menu. A drop down list will open.

6. In this drop down list click on 'New' option. ‘New’ dialog box will open. Choose 'Workbook option and click on 'OK' button. A new worksheet will appear on the screen.

7. Saving the Worksheet After entering the data in the worksheet, we need to save the worksheet at the desired location in the computer system.

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

9. Select File → Save As to display the Save As dialog box.

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

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

12. Inserting rows and columns In order to insert a row in the worksheet, select Home  > Insert > Insert Sheet Rows

13. Alternatively, right-click the row number, and then select  Insert . Note: Similarly, we can insert a column in the worksheet by selecting Insert Columns

14. Changing the width or height of rows and columns In order to change the height of the rows in the worksheet, perform the following steps: Select Format → Row → Height to display the Row Height dialog box. Enter the required height in the Row Height text box and click OK to apply height specifications to the rows.

15. Select Format → Row → Height to display the Row Height dialog box. Enter the required height in the Row Height text box and click OK to apply height specifications to the rows.

16. Renaming a Worksheet Usually the default names of Sheet in MS Excel are Sheet1, Sheet2, Sheet3 etc., In order to rename the worksheet, we need to perform the following steps: Open t he Microsoft Excel - Book1 window. Right-click the Sheet3 tab to display a shortcut menu. Select the Rename option and change the name of worksheet.

17. Deleting a Worksheet In order to delete a worksheet from the workbook, we need to performs the following steps: 1. Open the Microsoft Excel- Book1 window. 2. Right-click the Sheet2 tab to display the shortcut menu. 3. Select the Delete option to delete the Sheet2 worksheet.

18. Moving a Worksheet In order to move a worksheet from one location to another, we need to perform the following steps: Open the Microsoft Excel - Book1 window. Right-click the Worksheet tab to display a shortcut menu. Select the Move or Copy option to display the Move or Copy dialog box. Select the location, say (move to end), from the Before sheet list, to move the current sheet before the selected one and press OK.

19. Editing the Worksheet In order to edit a worksheet in the workbook, we need to perform the following Open the Microsoft Excel – Book1 window. Double-click the cell in which we want to make the changes. Enter the new data in the cell.