Scribd
Upload
12 views4 pages

Ms Excel Notes

MS Excel is a spreadsheet software developed by Microsoft for storing, organizing, calculating, and analyzing data. It features data storage, calculations, chart creation, and sorting/filtering options, and is commonly used for tasks like preparing marksheets and salary sheets. Key components include the workbook, worksheet, and various functions for data manipulation, alongside important shortcuts for efficiency.

Uploaded by

smog.duels141
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views4 pages

Ms Excel Notes

MS Excel is a spreadsheet software developed by Microsoft for storing, organizing, calculating, and analyzing data. It features data storage, calculations, chart creation, and sorting/filtering options, and is commonly used for tasks like preparing marksheets and salary sheets. Key components include the workbook, worksheet, and various functions for data manipulation, alongside important shortcuts for efficiency.

Uploaded by

smog.duels141
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

📊 MS EXCEL – BASIC NOTES

1. Definition of MS Excel

MS Excel (Microsoft Excel) is a spreadsheet software developed by Microsoft.


It is used to store, organize, calculate and analyse data.

2. Features of MS Excel

• Stores large amount of data

• Performs calculations using formulas

• Creates charts and graphs

• Provides sorting and filtering options

3. Uses of MS Excel

• Preparing marksheet

• Making salary sheet

• Creating bills and reports

• Data analysis and calculations

4. Parts of MS Excel Window

(a) Title Bar

It shows the name of the workbook.

(b) Ribbon

It contains tabs like Home, Insert, Page Layout, etc.

(c) Quick Access Toolbar

It contains options like Save, Undo and Redo.

(d) Worksheet Area

It is the area where data is entered.

(e) Status Bar

It shows information like sum, average, etc.

5. Basic Terms in Excel

(a) Workbook

A workbook is a file in Excel.

(b) Worksheet
A worksheet is a single page in a workbook.

(c) Row

Horizontal line of cells (1, 2, 3...)

(d) Column

Vertical line of cells (A, B, C...)

(e) Cell

Intersection of row and column.

(f) Cell Address

The name of a cell (Example: A1, B2)

6. Data Types in Excel

• Text (Name, City)

• Number (Marks, Salary)

• Date (01/01/2024)

7. Entering Data

• Click on a cell

• Type data

• Press Enter

8. Formula

A formula is used to perform calculations in Excel.


It always starts with (=) sign.

Example: =A1+B1

9. Basic Functions

(a) SUM

Used to add numbers.


Example: =SUM(A1:A5)

(b) AVERAGE

Used to find average.


Example: =AVERAGE(A1:A5)

(c) MAX

Finds maximum value.


Example: =MAX(A1:A5)

(d) MIN
Finds minimum value.
Example: =MIN(A1:A5)

10. Cell Formatting

Used to change appearance of data:

• Font size

• Color

• Borders

11. Save and Open

Save: Stores the file for future use.


Shortcut: Ctrl + S

Open: Opens an existing file.


Shortcut: Ctrl + O

12. Insert Row and Column

Insert Row: Adds a new row


Insert Column: Adds a new column

13. Delete Row and Column

Delete Row: Removes a row


Delete Column: Removes a column

14. Sorting

Sorting is used to arrange data in order (Ascending or Descending).

15. Filtering

Filtering is used to show only selected data.

16. Charts

Charts are used to represent data graphically.

Examples:

• Bar Chart

• Pie Chart

• Line Chart
17. Important Shortcuts

• Ctrl + S → Save

• Ctrl + Z → Undo

• Ctrl + Y → Redo

• Ctrl + Arrow Keys → Move quickly in data

• F2 → Edit cell

18. Important Points

• Always start formula with (=)

• Check data before calculation

• Save your work regularly

You might also like