DiSHA COMPUTER INSTITUTE

GOREGAON(W) BRANCH

Ms-Excel
Steps:

1. Start → All Program →Microsoft Office→Ms-Excel.

2. Start → Run → Excel.

Extension: .Xlsx.
Default Name: Book 1.

Total Rows In Ms-Excel: 10, 48,576.

Total Columns In Ms-Excel: 16,384.

Default Sheets: 3.

About MS-Excel:
In A New Results-Oriented User Interface, Microsoft Office Excel Provides
Powerful Tools and Features That You Can Use To Analyze, Share, and Manage
Your Data with Ease

Uses of MS-Excel:
1. To Create a Students Mark sheet In Schools.
2. To Create Salary Sheets Of Employees In Companies.
3. To Create a Bill Sheets In Shops Or In Stores.
4. To Make an Expenses Sheet.
5. And So On.
 DiSHA COMPUTER INSTITUTE
GOREGAON(W) BRANCH

About Menu Bar

❖ Home :
Paste: Paste the Content of the Clipboard.

Cut: Cut The Selection From The Documented Put It On The Clipboard.

Copy: Copy The Selection And Put It On The Clipboard.

Format Painter: Copy Formatting From One Place And Apply It To the Another.

Font: To Change The Type Of Writing.

Font Size: To Change The Size Of Text.

Borders: For Give The Borders To Selected Cells.

Clear Formatting: To Remove All Effects Of Sentences.

Orientation: Rotate Text to Diagonal or Vertical Angle Orientation.

Wrap Text: Make All Content Visible Within A Cell By Displaying It On Multiple
Lines.

Merge & Center: Join The Selected Cell Into One Larger Cell And Center Contents
In The New Cell.

Conditional Formatting: Highlight Interesting Cells, Emphasize Unused Values,

And Visualize Data in Data bars, Color Scale, And Icon Sets Based on Criteria.

Format As Table: Quickly Format A Range Of Cells And Convert It To Table By

Choosing A Pre-Defined Style.

Cell Styles: Quickly Format A Cell By Choosing A Pre-Defined Style.

Insert Cells: For Insert Cell, Rows, and Columns into the Sheet.

Delete Cells: For Deleting A Cells, Rows, And Columns From Sheet.
 DiSHA COMPUTER INSTITUTE
GOREGAON(W) BRANCH

Format: Change The Row Height, Or Column Width, Organize Sheets.

Auto sum: Display The Result of Simple Calculation, Such As Average or Maximum
Values after the Selected Cells.

Sort & Filter: Arrange The Data So That Easier To Analyze.

Find & Select: Find And Select A Specific Text, Formatting, Or Type Of Information
Within The Workbook.

❖ Insert :
Pivot Table: Summarize Data Using A Pivot Table. Pivot Table Make It Easy To
Arrange And Summarize Complicated Data And Drill Down On Details.

Table: Insert Or Draw A Table Into The Sheet.

Picture: Insert A Picture From A File.

Clip Art: Insert Clip Art into the Document, Including Drawings, Movies, Sounds,
or Stock Photography to Illustrate a Specific Concept.

Shapes: Insert Readymade Shapes, Such As Rectangle And Circles, Arrows, Lines,
Flowchart Symbols, And Callouts.

Smart Art Graphics: Insert A Smart Art Graphics To Visually Communicate

Information.

Chart: Insert A Chart To Illustrate And Compare Data.

Hyperlink: Create A Link To A Webpage, A Picture, An E-Mail Address, Or A

Program.

Text Box: Insert The Text Box That Can Be Positioned Anywhere In Document.

Word Art: Insert Decorative Text in the Document.

Header: The Content In The Header Will Appear At Top Of Each Printed Page.
 DiSHA COMPUTER INSTITUTE
GOREGAON(W) BRANCH

Footer: The Content In The Footer Will Appear At Bottom Of Each Printed Page.

Signature Line: Insert A Signature Line That Specifies The Individual Who Must
Sign.

Object: Insert An Embedded Object.

Symbol: Insert A Symbol That Are Not On Your Keyboard, Such As Copyright
Symbols, Trademark Symbols, Paragraph Marks, And Unicode Characters.

❖ Page Layout :
Themes: Change The Overall Design Of The Entire Document, Including Colors,
Fonts, And Effects.

Margins: Select The Margin Size For Entire Document Or The Current Section.

Orientation: Switch The Pages Between Portrait And Landscape Layout.

Paper Size: Choose The Paper Size For The Current Section.

Print Area: Mark The Specific Area For A Printing.

Breaks: Add Page, Section, Or Column breaks To the Document.

Background: For Give Background Image to Current Sheet.

Bring To Front: Bring The Selected Object In Front Of All Other Objects So That No
Part Of It Is Hidden Behind Another Object.

Send To Back: Send The Selected Object Behind All Other Object.

Rotate: Rotate Or Flip The Selected Object.

❖ Review:
Spelling & Grammar: Check The Spelling And Grammar Of Text In The Document.

Research: To Search Reference Materials, Such As Dictionaries,

 DiSHA COMPUTER INSTITUTE
GOREGAON(W) BRANCH

Thesaurus: Suggests Other Word With A Similar Meaning to The Word We Have
Selected.

Translate: Translate The Selected Text Into A Different Languages.

New Comment: Add Comment About The Selection.

Delete: Delete The Selected Comment.

Previous: Navigate the Previous Comment in the Document.

Next: Navigate The Next Comment In The Document.

❖ View :
Normal View: View the Document in Normal View.

Page Layout: View the Document as It Will Appear On the Printed Page.

Page Break View: View the Preview Where the Page Are Break When This
Document Printed.

Full Screen View: View the Document in Full Screen Mode.

Ruler: View The Rulers, Used To Measure And Line Up Objects In The Document.

Gridlines: Turn On Gridlines To Which You Can Align Objects In The Document.

Formula Bar: View Formula Bar, In Which You Can Enter Text and Formulas into
Cells.

Heading: Show Row and Column Headings.

Zoom: To Specify The Zoom Level Of The Document.

Zoom To Selection: Zoom the Worksheet So That the Currently Range of Selected
Cells Fills the Entire Window.

New Window: Open A New Window Containing a view Of the Current Document.
 DiSHA COMPUTER INSTITUTE
GOREGAON(W) BRANCH

Arrange All: Tile All Open Program Windows Side-By-Side On The Screen.

Freeze Panes: Keep the Portion of the Sheet Visible While Rest Of the Sheet
Scrolls.

Split: Split The Window Into Multiple Resizable Panes Congaing Views Of Our
Worksheet.

Hide: Hide It Current Window So That Cannot Be Seen.

View Side-By-Side: To View To Document Side-By-Side So That You Can Compare

Their Content.

Synchronous Scrolling: For Scroll Together.

Reset Window Position: Reset The Window Position Of The Document Being
Compared Side-By-Side So That They Share The Screen Equally.

Save Workspace: Save The Current Layout Of All Windows As A Workspace So

That It Can Restored Later.

Switch Windows: Switch to Different Currently Open Windows.

Macros: For Give The Same Formatting.

 DiSHA COMPUTER INSTITUTE
GOREGAON(W) BRANCH

Disha Computer Institute

Formulas
❖ Mark sheet :
Total: =Sum (Select All Sub. Marks) + Enter.

Percentage: =Select Total /[Link] Sub. + Enter.

Average: =Average (Select All Sub. Marks) + Enter.

Maximum: =Max (Select All Sub. Marks) + Enter.

Minimum: =Min (Select All Sub. Marks) + Enter.

Grade 1: =If (Select Percent. >35, “Pass”, “Fail”) + Enter.

Grade 2: =If (Select Percent. >70, “Distinction”, If(Select Percent. >60, “First
Class”, If (Select Percent. >50, “Second Class”, If (Select Percent. >35, “Pass”,
“Fail”)))) + Enter.

Grade 3: =If (And (Min (Select All Sub. Mark) > 35), “Pass”, “Fail”) + Enter.
 DiSHA COMPUTER INSTITUTE
GOREGAON(W) BRANCH

❖ Salary Sheet :

1. Hra (House Rent Allowance) : = Basic Salary * 15% + Enter.

2. Ta (Travelling Allowance) : = Basic Salary *14% + Enter.
3. Da : = Basic Salary *13% + Enter.
4. Ma (Medical Allowance) : = Basic Salary * 11% + Enter.
5. Total Allowance : = Sum(Basic Salary + Hra + Ta + Da + Ma) + Enter.
6. Pf (Provident Fund) : = Basic Salary *12.5% + Enter.
7. Lic (Life Insurance) : =Basic Salary *12% + Enter.
8. It : = Basic Salary *3% + Enter.
9. Total Deduction : = Sum(Pf + Lic + It) + Enter.
10. Net Salary : =Total Allowance – Total Deduction + Enter.

Bill Sheet:

11. Amount: = Quantity * Rate + Enter.

12. Discount: = Amount * 20% + Enter.
13. Net Amount: = Amount – Discount + Enter.

Disha Computer Institute