Scribd
Upload
16 views2 pages

Ms Excel Notes

MS Excel is a versatile tool used for database management, accounting tasks, and educational purposes such as attendance and results. It features a Quick Access Toolbar, Menu Bar with various functionalities, and supports extensive data manipulation through formulas and formatting options. Users can open Excel via the Run command and utilize its various tools for editing, inserting, and reviewing data.

Uploaded by

siddhidhage1128
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
16 views2 pages

Ms Excel Notes

MS Excel is a versatile tool used for database management, accounting tasks, and educational purposes such as attendance and results. It features a Quick Access Toolbar, Menu Bar with various functionalities, and supports extensive data manipulation through formulas and formatting options. Users can open Excel via the Run command and utilize its various tools for editing, inserting, and reviewing data.

Uploaded by

siddhidhage1128
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

1. INTRODUCTION OF MS EXCEL :
I. MS EXCEL is used for maintaining database of a particular system.
II. It is also used for handling all work which is related to accounting fields.
III. It is used in school, colleges for making attendance sheets, results & much more.
IV. Extension name of every excel file is : .xlsx
V. By default name of page is Book or Sheet1.
VI. Each and every excel sheet contains 1048576 Rows and 16384 Columns.
2. How to open MS Excel?
I. Go to Start
II. Click on Run Command
III. Type= “excel”
IV. Press “OK”
3. Contents of MS Excel :
I. Quick Access Toolbar: Using Quick Access Toolbar we can easily and quickly access all
data and files.

II. Menu Bar: Menu’s present below the Quick Access Toolbar.
1. HOME :
a. Clip Board = It works same as ms words clipboard.
b. Font = It is used to change font styles, colors and much more.
c. Alignment = We can set word alignments to left, right and to center.
d. Number = It is used to giving numbers format like currencies,
accounting ,short date, long date and all formats which related to
accounting fields.
e. Styles :
 Conditional Formatting = There are various conditions are
presents through that conditions we can give the formats for
any data.
 Format as a Table = In this we can set different types of
formats or designs to tables.
 Cell Style = we can give many styles to each and every cell in
the table.
f. Cell =
 Insert = it is used to insert or add rows and columns in sheet.
 Delete = it is used to delete selected rows or columns.
 Format = Using this we can set the size of any cell, we can
also hide or unhide any cell and we can do all works related
to sheet like delete sheet, rename sheet and much more.
 Editing = In this we can find or replace any particular data
from sheet, we can sort data with ascending or descending
order.
2. Insert :
a. Using insert we can add pictures, charts, clip arts, tables, shapes, link
and much more.
3. Page Layout :
a. It contains all setting which are related to page.
4. Formula
a. It contains different formulas like auto sum, financial, logical, text,
lookup and references, date and time, mathematical, and
trigonometric functions.
5. Data
a. Data validation: it use to give a limitation at a particular cell
according to respective formulas.
b. Data table : it is used for creating table of a given number.
6. Review
a. Proofing :
 It is used for checking spelling and grammars and meaning of
a word.
b. Comments
 It is used for give a comment to a particular cell.
7. View
a. It is used to give proper format to the page before printout.

You might also like