UNIT IV – MICROSOFT EXCEL APPLICATION
Microsoft Excel is an electronic spreadsheet application in Windows. It allows you to create
many types of spreadsheets for Reports, budgets and other projects.
A spreadsheet is a computer application that simulates a paper worksheet. It displays multiple
cells that together make up a grid consisting of rows and columns, each cell containing either
alphanumeric text or numeric values. A spreadsheet cell may alternatively contain a formula that defines
how the contents of that cell is to be calculated from the contents of any other cell (or combination of
cells) each time any cell is updated. Spreadsheets are frequently used for financial information because
of their ability to re-calculate the entire sheet automatically after a change to a single cell is made.
The Cell -Each rectangle in a worksheet is called a cell. A cell is the intersection of a row and a
column. Cells are the basic building blocks of a worksheet. Cells can contain a variety of content
such as text, formatting attributes, formulas, and functions.
Worksheet – The primary document that you use in Excel to store and work with data called a
spreadsheet. It is consists of cells that are organized into columns (16, 384) and rows
(1,048,576); a worksheet(UNLIMITED) is always stored in a workbook.
Workbook - refers to the Microsoft excel file which consists of infinite number worksheets which
depends on the capacity of the hardware.
PARTS OF MICROSOFT EXCEL WINDOW 2010
Name Box /
Cell Address
Formula Bar
Column Headings
Row Headings Fill Handle
Active Cell
Sheet Tabs
Disclaimer: This module is owned by ISAT University. Unauthorized reproduction or
distribution without the consent of the university and the module writer is
strictly prohibited.
1. Worksheet – is a single sheet 6. Column Headings - are the letters only at the
2. Workbook Window – is the entire excel file top of the spreadsheet
3. Name Box - displays the column letter and row 7. Row Headings - are the numbers on the left
number that designates the active cell side of the spreadsheet
4. Active cell - is the currently selected cell, 8. Fill Handle - is the small black square on the
displayed with a thick black border around the bottom right side of the border around the
cell active cell
5. Formula Bar - provides information about the 9. Sheet Tabs - identify the current worksheet.
active cell. Formulas can be added or edited in
the formula bar.
1. HOME TAB
1 2 3 4 5 6 7
a. Clipboard : Cut, Copy, Paste, Format Painter
b. Font : Font, Font Size, Grow Font, Shrink Font, Clear Formatting , Bold, Italic, Underline,
Borders , Text Highlight Color, Font Color
c. Alignment : Top Align, Middle Align, Bottom Align, Align Text Left, Align Text Center, Align Text
Right , Increase Indent, Decrease Indent, Wrap Text, Merge and Center
d. Number :Dollar Number Format, Percent Style, Comma Style, Increase Decimal, Decrease Decimal
e. Styles : Conditional Formatting, Format as Table, Cell Styles
f. Cells : Insert, Delete, Format
g. Editing : Auto Sum, Fill, Clear, Sort and Filter, Find and Select
2. INSERT TAB
4 5 6
1 2 3 7 8
a. Tables : PivotTable, Table
b. Illustrations : Picture, Clip Art, Shapes, SmartArt, Screenshot
c. Charts : Column, Line, Pie, Area, Scatter, Other charts,
d. Sparklines : Line Column, Win/Loss
e. Filter :Slicer
f. Links : Hyperlink
g. Text : Text Box, Header and Footer, WordArt, Signature Line,
h. Symbol : Equation, Symbol
Disclaimer: This module is owned by ISAT University. Unauthorized reproduction or
distribution without the consent of the university and the module writer is
strictly prohibited.
3. PAGE LAYOUT TAB
1 2 3 4 5
a. Themes : Themes, Colors, Fonts, Effects
b. Page Setup : Margins, Orientation, Size, Print Area, Breaks, Background, Print Titles
c. Scale to Fit : Width, Height, Scale
d. Sheet Options : Gridlines (View, Print), Headings (View, Print)
e. Arrange : Bring to Front , Send to Back, Selection Pane, Align, Group, Rotate
4. FORMULA TAB
1 2 3 4
a. Functional Library : Insert Function, Auto Sum, Recently Used, Financial, Logical, Text, Data and
Time, Lookup and
Reference, Math and Trig, More Functions
b. Defined Names : Name Manager , Define Name, Use Formula, Create from Selection
c. Formula Auditing :Trace Precedents, Trace Dependents, Remove Arrows, Show Formulas, Error
Checking, Evaluate
Formula, Watch Window
d. Calculation : Calculation Options, Calculate Now , Calculate Sheet
5. DATA TAB
1 2 3 4 5
a. Get External Data : From Access, From Web, From Text , From Other Sources, Existing Connections
b. Connections : Refresh All, Connections, Properties, Edit Links
c. Sort and Filter : Sort, Filter, Clear, Reapply, Advanced
Disclaimer: This module is owned by ISAT University. Unauthorized reproduction or
distribution without the consent of the university and the module writer is
strictly prohibited.
d. Data Tools : Text to Columns, Remove Duplicates, Data Validation, Consolidate , What-If
Analysis
e. Outline : Group and Ungroup, Subtotal, Show Detail, Hide Detail
6. REVIEW TAB
1 2 3 4
a. Proofing : Spelling, Research, Thesaurus
b. Language : Translate
c. Comments : New, Delete, Previous, Next, Show/Hide Comment, Show All Comments, Show
Ink
d. Changes : Protect Sheet, Protect Workbook, Share Workbook, Protect/Share
Workbook, Allow User to
Edit Ranges, Track Changes
7. VIEW TAB
6
1 2 3 4 5
a. Workbook View: Normal, Page Layout, Page Break View, Customs Views, Full Screen
b. Show : Ruler, Gridlines, Formula Bar, Headings
c. Zoom : Zoom, Zoom to Selection
d. Window : New Window, Arrange All, Freeze Panes, Split, Hide, Unhide, Save work Space,
Switch
Windows
e. Macro : Macros
Disclaimer: This module is owned by ISAT University. Unauthorized reproduction or
distribution without the consent of the university and the module writer is
strictly prohibited.
