Microsoft Excel 2021

Introduction to Microsoft Excel 2021

What is Microsoft Excel 2021

• Microsoft Excel 2021 is also called a spreadsheet application.

• It is used for Balance Sheets, Bills, Marksheets, Salary Slips, etc.

Features of Excel 2021

Workbook and Worksheet

• An Excel file is called a workbook.

• A workbook contains multiple worksheets.

• In Excel 2021:

  • Rows: 1,048,576

  • Columns: 16,384

  • Sheet = Worksheet

Note: Headings and gridlines do not appear in print.

How to Open Excel 2021

1.Start Menu → Microsoft Office → MS Excel 2021

2.Windows Key + R → Run Box → Type Excel → OK

3.Search Box → Type Excel

Important Properties and Functions in Excel

Auto-Fill Property

• Automatically fills values like months, week names, numbers, and series.

• Enter the first value → Drag Fill Handle → Excel fills the rest.

Adjusting Rows and Columns

Increase Column Width

• Home Menu → Format → Column Width → Enter Value → OK

Increase Row Height

• Right Click Row → Row Height → Enter Value → OK

Shortcut Keys

• Copy data to the cell below. → Ctrl + D

• Copy data to the right cell. Ctrl + R

Insert and Delete Options

Insert Column and Row

• Home Menu → Cells Tab → Insert → Insert Sheet Column/Row

Delete Column and Row

• Home Menu → Cells Tab → Delete → Delete Sheet Column/Row

Insert and Edit Cells

• Insert New Cell → Home Menu → Cells Tab → Insert Cells

• Edit Cell → Double Click the Cell

Sheet Management in Excel

Insert a New Sheet

1. Click “+” button near the last sheet

2. Right Click → Insert → Worksheet → OK

Delete a Sheet

1. Right-click on Sheet → Delete

2. Home Menu → Cells Tab → Delete → Delete Sheet

Move or Duplicate Sheet

• Drag the sheet tab to change position

• Hold Ctrl while dragging to duplicate the sheet

Conclusion

Microsoft Excel 2021 is a powerful spreadsheet tool for students, teachers, and professionals. With features like Auto-Fill, Sheet Management, Row/Column adjustments, and shortcuts, Excel makes data entry, calculation, and reporting fast and easy.

EXCEL INTRODUCTION IN HINDI 

Thanks To Google

Thanks to ChatGPT