Kanti and Kunja International College: MS Office Report (BBA 1st Sem)

This lab report, submitted by Anisha Acharya from Kanti and Kunja International College, provides an overview of Microsoft Office applications, specifically MS Word, MS Excel, and PowerPoint. The report begins with an introduction to MS Word, detailing its layout, features like editing, enhancement, and formatting, and the mail merge function. It then moves on to PowerPoint, explaining the layout, features such as animation and transitions, and slide layouts. Finally, the report covers MS Excel, including its layout, record and calculation capabilities, and the use of charts. The report is designed to fulfill the requirements of a BBA first-semester degree and includes acknowledgements and a table of contents to guide the reader through the software applications.

KANTI AND KUNJA INTERNATIONAL
COLLEGE
(AFFILIATED TO TRIBHUVAN UNIVERSITY)
NEW BANESHWOR KATHMANDU
A lab report based on application software package
 MS- WORD
 MS-EXCEL
 POWERPOINT
In the partial fulfillment of the requirement for the first
semester degree of bachelor in business administration
Submitted By: Submitted To:
Anisha Acharya Anil Lamichhane

ACKNOWLEDGEMENT
I gratefully acknowledge to almighty god for giving me wisdom, knowledge with
creativity for completing this report.
I would like to express my particular thanks of gratitude to my respected teacher sir
Anil Lamichhane who gave me the golden opportunity to do this wonderful report which
also help me in doing a lot of research and I came to know about so many new things I am
really thankful to them .
Secondly, A word of gratitude goes to my parents for giving me the best creativity and
suggestions and a note of thanks goes to my friends who helped me a lot in finalizing this
report within the limited time.

Table of Contents
ACKNOWLEDGEMENT..................................................................................................................2
CHAPTER- 1: INTRODUCTION TO MS-WORD............................................................................1
1.1 LAYOUT OF MS-WORD.........................................................................................................1
1.2 FEATURES OF MS-WORD....................................................................................................2
1.3 MAIL MERGE..........................................................................................................................9
CHAPTER-2 INTRODUCTION TO POWERPOINT.....................................................................10
2.1 LAYOUT OF POWERPOINT...............................................................................................10
2.2 FEATURES OF POWERPOINT...........................................................................................11
2.3 DESCRIPTION OF ANIMATION, TRANSITION, SLIDE LAYOUT..............................16
CHAPTER 3 INTRODUCTION TO MS-EXCEL..............................................................................19
3.1 EXCEL LAYOUT...................................................................................................................19
3.2 RECORD AND CALCULATE...............................................................................................20
3.3. ANY 3 CHARTS.....................................................................................................................23

CHAPTER- 1: INTRODUCTION TO MS-WORD
A word processor is a software program capable of creating, storing, and printing
documents. Unlike the standard typewriter, users using word processors have the ability of creating
a document and making any changes anywhere in the document. This document can also be saved
for modification at a later time or to be opened on any other computer using the same word
processor. Today, the word processor is one of the most frequently used programs or online
services used on a computer today. Some examples of word processing programs include
Microsoft Word, WordPerfect (Windows only), AppleWorks (Mac only), and OpenOffice.org.
Microsoft Word is a widely used commercial word processor designed by Microsoft. Microsoft
Word is a component of the Microsoft Office suite of productivity software, but can also be
purchased as a stand-alone product.
MS-Word window elements:
Various window elements of MS-word are:
 Title bar
 Menu bar
 Tool bars
 The work area
 Status bar
 Scroll bars
 Scroll boxes
 The ribbon
1.1 LAYOUT OF MS-WORD
1

Quick Access Toolbar: The top element of the Ms-word 2013 is quick access toolbar.
The quick access toolbar provides you with access to command you frequently use. By
default, save,
1. Undo and Redo appear on the Quick Access Toolbar. You can use save to save
your file, undo to rollback an action you have taken and redo to reapply an action
you have rolled back.
2. The Title Bar: The title bar displays the title of the document on which you are
currently working. Word names the first new document you open Document1. As
you open additional new document Word names them sequentially. When you save
your document, you assign the document a new name.
3. The File Menu: This is the only menu in Ms-word 2013. Earlier in 2007 is was
named as office button.
4. The Ribbon: We use The Ribbon to issue commands. The Ribbon is located near
the top of the screen, below the Quick Access toolbar. There are several tabs at the
top of the Ribbon; clicking a tab displays several related commands groups within
each group there are related commands buttons.
5. The Ruler: The ruler is found below the ribbon. You can use the ruler to change
the format of your document quickly. If your ruler is not visible, follow these steps
to make it visible.
6. The Text Area: Just below the ruler is a large area called the text area. You type
your document in the text area. The blinking vertical line in the upper-left corner
of the text area is the cursor. It marks the insertion point.
7. The Vertical and Horizontal Scroll Bars: The vertical and horizontal scroll bars
enable you to move up, down and across your window simply by dragging the
icon located on the scroll bar. The vertical scroll bar is located along the right side
of the screen. The horizontal scroll bar is located just above the status bar.
8. The Status Bar: The status bar appears at the very bottom of your window and
provides such information as the current page and the number of words in your
document
1.2 FEATURES OF MS-WORD
1.2.1 EDITING FEATURES
2

Editing features allow the user to locate, revise, correct, and rearrange text in a
document.
■ Copy: Copies selected text so it can be placed in another location, leaving the
original text unchanged.
■ Cut: Removes selected text from the current location.
■ Paste: Places selected text that has been copied or cut at another location.
■ Find: Locates a specified keystroke, word, or phrase in a document. Available Find
options include: – Find only occurrences that match the specified case. – Find only
whole words containing the specified text. – Find all forms of a specified word. – Find
specified text using the asterisk (*) and question mark (?) as wildcard (unspecified)
characters.
■ Replace: Finds a specified keystroke, word, or phrase, and then replaces it with
another keystroke, word, or phrase. All occurrences of the specified text can be
replaced at one time, or replacements can be made individually (selectively).
■ Select: Highlights text on which various operations may be performed. Use the
mouse and/or key combinations to select text. Once selected, the text can be bolded,
underlined, italicized, deleted, copied, moved, printed, saved, etc.
■ Spell-Check: Checks words, documents, or parts of documents for misspellings.
■ Undo: Reverses the last change made in the text. This feature restores moved text to
its original location.
■ Redo: Reverses the last Undo action.
■ Typeover. Replaces existing text with newly keyed text (also called Overstrike or
Overtype).
1.2.2 ENHANCEMENT FEATURES
Enhancement features improve the appearance of a document and/or emphasize
important words, phrases, or sentences.
■ Bold: Prints text darker than other copy as it is keyed. Bold may be added after text
has been keyed by first selecting the text.
■ Borders: Adds a border to any or all sides of a page, paragraph, or column, as well
as to a table or a cell within a table. Page border options may include small pictures.
3

Borders not only enhance appearance, but also make text easier to read by
emphasizing certain passages. Borders are most effective when used sparingly
■ Bullets: Highlights each item in a list with a heavy dot or other character, as
demonstrated in this list of features. Bullets add visual interest and emphasis.
■ Change Case: Changes capitalization. The lowercase option changes all selected
text to lowercase; the UPPERCASE option changes selected text to all capitals. The
Sentence case option capitalizes the first letter of the first word, and the Title Case
option capitalizes the first letter of each selected word.
■ Drop Cap: Formats paragraphs to begin with a large dropped capital letter. Drop
caps are objects (pictures) that can be formatted and sized.
■ Font: Consists of the typeface, style, size, and any effects used. Font features may
be changed before or after text is keyed. The number and size of fonts available
depends on the software and printer used.
– Typeface: Refers to the design of the characters. Examples include Times New
Roman, Courier New, and Arial
– Styles: Include bold and italic.
– Size: Measured in points such as 10 point or 12 point. One point is about 1⁄72 of
an inch.
– Effect: Added to give text a special look. Examples of effects are shadow, emboss,
and small caps. Effects should be used infrequently.
■ Italic: Prints letters that slope up toward the right. Italic may be added after text has
been keyed by first selecting the text.
■ Numbering: Shows the proper order of a series of steps or items. Use numbers
instead of bullets whenever the order of items is important.
■ Shading: Adds color or patterns to paragraphs or table cells to emphasize them and
focus the reader’s attention on the contents.
■ Superscript: Places text slightly higher than other text on a line. Superscript is
commonly used for footnotes and endnotes, and for mathematical formulas and
equations.
■ Underline: Underlines text as it is keyed. An underline may be added after text has
been keyed by first selecting the text.
4

■ Watermark: Prints any desired text or graphics behind the main text on document
pages.
1.2.3 FORMATTING FEATURES
Formatting features change the arrangement, or layout, of pages. These
features include aligning text vertically and horizontally, indenting and hyphenating
text, and changing margins and line spacing.
■ Alignment: Refers to the horizontal position of a line of text (also called
justification).
– Use left alignment to start text at the left margin (even left margin).
– Use right alignment to align text at the right margin (even right margin).
– Use center alignment to center text between the left and right margins.
– Use justify alignment for even left and right margins.
■ Center Page: Centers text between top and bottom margins of a page. This feature
leaves an equal (or nearly equal) amount of white space above and below text.
Inserting two hard returns below the last keyed line gives centered documents a better
appearance
■ Hyphenation: Automatically divides (hyphenates) words that would normally wrap
to the next line. When used with left-aligned text, hyphenation makes the right margin
less ragged, making text more attractive.
■ Indent: Moves text away from the left or right margin. – Left indent (paragraph
indent) moves the text one tab stop to the right (usually 0.5"), away from the left
margin. – Hanging indent moves all but the first line of a paragraph 0.5" (one tab stop)
to the right. Hanging indent is commonly used on bibliographies and reference pages.
■ Line Spacing: Changes the amount of blank space between lines of text.
■ Margins: Changes the amount of blank space at the top, bottom, right, and/or left
edges of a page. Default margin settings are not the same for all software.
■ Page Break: Inserts a soft page break automatically when the current page is full. A
hard page break can be inserted manually to start a new page before the current page is
full.
■ Tab: Aligns text according to the type of tab set. By default, most word processing
software programs have left tabs already set at half-inch (0.5") intervals from the left
margin. These preset tabs can be cleared and reset.
5

– Left tabs, commonly used to align words, align text evenly at the left by placing the
keyed text to the right of the tab setting.
– Right tabs, commonly used to align whole numbers, align text evenly at the right by
placing the keyed text to the left of the tab setting.
– Decimal tabs align numbers at the decimal point, regardless of the number of places
before or after the decimal point.
– Dot Leader tabs automatically place dot leaders (. . . .) between columns of
designated text. The leaders lead the reader’s eyes from text in the left column to text
in the right column.
■ Text Wrapping: Positions text in relation to an inserted object (graphic). Text may
appear above and below, around, behind, or in front of an object.
■ Widow/Orphan: Ensures that the first line of a paragraph does not appear by itself
at the bottom of a page (orphan line) or that the last line of a paragraph does not
appear by itself at the top of a page (widow line).
1.2.4 INSERT FEATURES
Various commands on the Insert menu are used to add page numbers, dates,
headers, footers, and footnotes and to insert symbols, clip art, files, pictures, shapes,
text boxes, and word art.
■ Shapes: Adds a variety of shapes (rectangles, stars, banners, arrows, flow chart
symbols, etc.) to a document.
■ Clip Art: Drawings, pictures, sounds, and video clips can be inserted into documents.
Collection of clip art files is provided with word processing software; additional clip
art can be purchased or downloaded from the Internet
■ Date: Automatically inserts the date into a document. Some software contains an
Update option that automatically replaces the previous date with the current date each
time the document is opened or printed.
■ Footnote and Endnote: Identifies sources quoted or paraphrased in the text or gives
extra information about the main text. Word processing software automatically
positions and prints each footnote at the bottom of the same page as the reference to it.
It prints endnotes on a separate page at the end of a report. When footnotes or endnotes
6

are edited, added, or deleted, the software feature automatically makes the necessary
changes in numbering, formatting, and page breaks.
■ Header and Footer: Adds text (such as a chapter title, date, filename, or name of a
person or company) or graphic (a company logo, for example) in the top margin (header)
or bottom margin (footer) of a page. Headers or footers often include page numbers.
■ Page Numbers: Places page numbers in a specified location on printed pages.
– Most software contains a variety of numbering styles from which to choose: Arabic
numerals (1, 2, 3), lowercase Roman numerals (i, ii, iii), uppercase Roman numerals (I, II,
III), uppercase letters (A, B, C), and lowercase letters (a, b, c).
– Numbers can be placed at the top or bottom of the page, and aligned at the left margin,
center, or right margin.
– The Hide or Suppress option keeps the page number from appearing on a specified
page.
■ Text Boxes: Frequently used for labels or callouts in a document. Once a text box is
inserted in a document, it can be formatted, resized, and moved.
■ Word Art : Changes text into a graphic object. Most word processing software
programs have a word art gallery that contains predefined styles such as curved or
stretched text
1.2.5 MISCELLANEOUS FEATURES
This group contains features included in most word processing software that make the
keying task easier and more efficient.
■ AutoFormat: Automatically formats headings, bulleted and numbered lists, borders,
numbers, symbols, and so on as a document is keyed. Table AutoFormat applies borders,
shading, font effects, etc., to tables.
■ AutoCorrect: Automatically corrects many common keying, spelling, and grammatical
errors. It can also insert certain text, graphics, and symbols automatically.
■ AutoComplete: Inserts entire items such as dates and AutoText (stored phrases) when a
few identifying characters are keyed.
7

■ Macro: Allows the user to save (record) keystrokes and/or commands for retrieval
(playback) later. Macros save time by eliminating repetitive keying and formatting.
■ Show: Displays marks in text showing where tabs, spaces, and hard returns are inserted.
Being able to see these marks helps when editing a document or solving formatting
problems. The marks do not print.
■ Split Window: Displays a document in two panes, each with its own scroll bars. This
feature can be useful when copying text between parts of a long document, or when it is
necessary to see text not visible in the window where you are keying.
■ Zoom: Increases or decreases the size of text and amount of a page appearing on the
screen. Zoom out (a rate below 100%) to see more of a page and smaller text; zoom in (a
rate above 100%) to see less page area and larger text.
1.2.6 SPECIAL FEATURES
The word processing features listed below are used to create specific kinds of
documents.
■ Merge: Combines information from two files into one merged file. The feature is often
used to merge a form letter (main document) with a name and address file (data source) to
create a personalized letter (merged file) to each recipient in the data source file.
■ Newspaper-Style Columns: Divides a page into two or more side-by-side columns to
create pamphlets, leaflets, brochures, and newsletters. The columns may be equal or
unequal width. As the document is keyed, text fills a column before moving to the next
column. Often, newspaper-style columns need to be balanced (equal or nearly equal in
length). The desired balance can be achieved by inserting column breaks as needed.
■ Outline: Automatically labels each topic (paragraph) with a number or letter. The
alphanumeric outlining system uses Roman and Arabic numbers and capital and lowercase
letters. For example, Level 1 items might be labeled I, II, III, etc. Level 2 would be A, B,
C, etc., and Level 3 would be labeled 1, 2, 3, etc.
■ Styles: Applies a predefined set of formatting options to text to add consistency to a
document.
8

■ Table: Creates a grid for arranging information in rows and columns. A table can be
used to summarize information and to arrange it into easily identifiable categories. Note:
Table features are discussed in the Tables section of this manual.
■ Web Page: Creates a new blank Web page in the document window. The file is saved
in HTML format so it can be viewed in a Web browser.
■ E-Mail: Creates a new e-mail message in the document window and sends the
document as the body of the e-mail.
1.3 MAIL MERGE
Mail merge consists in combining mail and letters and pre-addressed envelopes or
mailing labels for mass mailings from a form letter.
Microsoft Word can insert content from a database, spreadsheet, or table into Word
documents.
This feature is usually employed in a word processing document which contains
fixed text (which is the same in each output document) and variables (which act as
placeholders that are replaced by text from the data source).
Mail Merge is a powerful tool for writing a personalized letter or E-mail to many people at
the same time. It imports data from another source such as Excel and then uses that to
replace placeholders throughout the message with the relevant information for each
individual that is being messaged.
ADVANCE FEATURES
Money can be saved by pre-sorting on zip code and grouping by postal-
discount requirements (same ZIP code, same SCF).
A paperless approach is to use mail merge to format email. Going beyond words, in 2018
the New York Times detailed a further instance of "mass customization" - personalized
videos.
The mail merging process generally requires the following steps:
1. Creating a Main Document and the Template.
2. Creating a Data Source.
3. Defining the Merge Fields in the main document.
4. Merging the Data with the main document.
9

5. Saving/Exporting.
A common usage is for creating "personalized" letters, where a template is created, with a
field for "Given Name", for example. The template letter says "Dear <Given Name>", and
when executed, the mail merge creates a letter for each record in the database, so it appears
The letter is more personal. It is often used for variable data printing. It can also be used to
create address labels from a customer relationship management database, or for mass
emails with pertinent information in them, perhaps a username and password.
CHAPTER-2 INTRODUCTION TO POWERPOINT
Microsoft PowerPoint is a professional presentation program that allows the user
to create "presentation slides" that can be displayed on the computer screen or through a
projector that is plugged into the computer
MS-Power Point is a software package that can use to present pictures, texts, graphics,
transitions, video-clips, sounds etc. we use presentation package like power point that can
use for animations and transition of text and graphics. Power point is full featured
presentation program that is used to design presentation for the variety of mediums
computer based display shows and overhead projection transparencies. We can add sound
and animation to the slides. The main purpose of power point is for advertisements,
education, trainings etc. it gives the facilities for presenting documents in easier way.
A PowerPoint presentation is a good way to convey pieces of information, usually in the
form of an outline, to a large audience. Generally, PowerPoint presentations are appealing
to users because they are easy to create and edit and generally small enough to fit onto a
CD or a USB Jump Drive. Therefore, a user does not have to carry around any slides or
slide projector, and, if necessary, can make any last-minute changes to the presentation.
Today, we will be using Microsoft PowerPoint 2003 to explore the program. Microsoft
PowerPoint 2007 looks different, but works the exact same way.
2.1 LAYOUT OF POWERPOINT
A slide layout is an arrangement of placeholders which are designed to help you position
your slide content.
The layout refers to the way that the objects are arranged on the slides.
10

A slide layout will contain placeholder for particular objects (e.g. text, charts, clipart etc.).
Depending on which slide layout you use will depend on where PowerPoint positions your
content.
There are several different types of placeholder that can appear on your slide layouts:
Every slide has a slide layout that controls how the information is arranged on the slide.
A slide layout is just a collection of one or more placeholders which set aside an area of
the slide to hold certain information.
2.2 FEATURES OF POWERPOINT
1) ADDING SMART ART
Don’t confuse SmartArt with the similarly named WordArt. Where WordArt just
allows you to display text using a wide variety of different formats and effects, SmartArt is
a comprehensive and flexible business diagram tool that greatly improves upon the
‘Diagram Gallery’ feature found in previous versions of Office.
Click the insert Smart Chart Graphic to choose from a selection of options.
11

SmartArt can be used to create professional diagrams that include pictures and text or
combinations of the two. An obvious use of SmartArt would be to create an organization
chart but it can be used for many different kinds of diagrams and even to provide some
variety to slides using text bullet points.
2) INSERTING SHAPES
If you need to include some sort of diagram in your presentation, then the quickest and
easiest way is probably to use SmartArt. However, it is important to be able to include
shapes independently of SmartArt and worth being familiar with the various Drawing Tool
format options.
Not only will they be useful if you do need to manually draw a diagram (and SmartArt
doesn’t suit all diagrams), but they can also be applied to objects on a slide that you might
not immediately think of as shapes. For example the box that contains your slide title or
your content. This can be anything from text to a video, or even the individual shapes in a
SmartArt diagram.
12

As you can see, the gallery of available shapes is very extensive. Once you have selected
your chosen shape, you can just click in your slide to insert a default version of the shape
or, to set a particular size and position, click and drag with the mouse to create the shape
and size you want.
3) INSERTING AN IMAGE
13

Here are two content type icons which appear in new content Placeholders for inserting
pictures. You can Insert Picture from File or Insert Clip Art. Alternatively, the Illustrations
group of the Insert ribbon tab includes the same two tools. In addition, PowerPoint
2010 has a new ‘Screenshot’ option that allows you to capture an entire window or part of
a window for inclusion on a slide. You can also copy any image and just paste it directly to
a slide.
Insert Picture from File allows you to browse to an image file saved somewhere on your
system whereas Clip Art is held in an indexed gallery of different media types. Clip Art is
not limited to pictures: ‘The Results should be:’ box lets you choose between: ‘All media
file types’ and one or more of the following different types:
 Illustrations
 Photographs
 Video
 Audio
Once you have found the image you want to use, click on it to insert it into the current
slide. You can now re-size and move the image accordingly with further editing options
available when you right click the desired image.
4) SLIDE TRANSITIONS
14

Properly used, slide transitions can be make your presentations clearer and more
interesting and, where appropriate, more fun. Badly used, the effect of slide transitions can
be closer to irritating or even nauseating. Simple animation effects are often used to add
interest to bullet point text. Much more extreme animation effects are available but, in
most cases, should be used sparingly if at all.
Two main kinds of animation are available in a PowerPoint presentation: the transition
from one slide to the next and the animation of images/text on a specific slide.
In PowerPoint 2010 & 2013 there is also a separate Transitions ribbon tab that includes a
gallery of different transition effects. These can be applied to selected slides or all slides. If
you want to apply different transition effects to different groups of slides, then you might
want to choose ‘Slide Sorter’ view from the Presentation Views group of the View ribbon.
5) ADDING ANIMATIONS
Whereas the transition effects are limited to a single event per slide, animations can be
applied to every object on a slide – including titles and other text boxes. Many objects can
even have animation applied to different components, for example each shape in a
SmartArt graphic, each paragraph in a text box and each column in a chart. Animations
can be applied to three separate ‘events’ for each object:
Entrance – how the object arrives on the slide
15

Emphasis – an effect to focus attention on an object while it is visible
Exit – how the object disappears from the slide
To apply an animation effect, choose the object or objects to be animated, then choose
Animation Styles or Add Animation from the Animations toolbar.
Where an animation is applied to an object with different components (for instance a
SmartArt graphic made up of several boxes), the Effect Options tool becomes available to
control how each component will be animated. So for example, your animation can be
used to introduce elements of an organization chart to your slide one by one.
2.3 DESCRIPTION OF ANIMATION, TRANSITION, SLIDE LAYOUT
2.3.1 ANIMATION
16

An animation effect is a special visual or sound effect added to a text or an object on a
slide or chart. It is also possible to animate the text and the other objects using the buttons
on the Animation Effects toolbar. Animations can be applied to text boxes, bullet points,
and images so they move on the slide during a slide show. Animation presets in versions
of PowerPoint affect all the content on the slide. Entrance and exit animation effects are a
quick way to add movement to your slides. You can also apply a motion path to a text or
object to animate it’ll versions of PowerPoint have custom animation features to allow you
to decide which elements move and how they will move. The Animation Painter, which
was introduced in PowerPoint 2010, is a great animation tool that works much like the
Format Painter option in other Microsoft Office programs. It allows you to copy an
animation effect from one object to another with a single click or double-click to paint
multiple objects with the same animation format.
2.3.2 TRANSITION
Slide transitions are motion effects that occur in Slide Show view when you move from
one slide to the next during a presentation. You can control the speed, add sound, and even
customize the properties of transition effects. To add a transition first of all select a slide in
the left hand panel that contains the Slides and Outline tabs (I'd keep it simple and work in
the Slides tab). The transition will occur immediately before the selected slide is displayed.
Click Transitions > Transition to This Slide, and then click on the transition you want to
use. If you want to see a larger selection of transitions, click on the more button (the down
arrow at the bottom right of the group. When you hover over a thumbnail image of a
17

transition, you can see a live preview of it applied to your slide. When you move the
cursor away, the preview is removed.
SLIDE LAYOUT
Slide layout refers to design and placement of different elements on a slide. The
default slide layout is a title at the top of the slide, and text underneath the title. However,
this default can be modified to include alternate text, images, and even video. The slide
layout can be considered an overview of the information being presented by the user.
Slide layouts contain formatting, positioning, and placeholder boxes for all of the content
that appears on a slide. Placeholders are the dotted-line containers on slide layouts that
hold such content as titles, body text, tables, charts, SmartArt graphics, pictures, clip art,
videos, and sounds. Slide layouts also contain the colors, fonts, effects, and the
background (collectively known as the theme) of a slide.
18

CHAPTER 3 INTRODUCTION TO MS-EXCEL
Microsoft Excel is a spreadsheet program that is used to record and analyze numerical
data. Think of a spreadsheet as a collection of columns and rows that form a table.
Alphabetical letters are usually assigned to columns and numbers are usually assigned to
rows. The point where a column and a row meet is called a cell. The address of a cell is
given by the letter representing the column and the number representing a row.
The term spreadsheet refers to a large sheet of paper with multiple rows and columns for
record keeping and calculation. In the oldest time, the keeping of records with calculation
is the big problem that was solved be spread sheet calculation. The replacement of manual
sheet with electronic sheet is done by spreadsheet packages.
Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft
Windows, Mac OS, and iOS. It features calculation, graphing tools, pivot tables, and a
macro programming language called Visual Basic for Applications. It has been a very
widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it
has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of
Microsoft Office.
3.1 EXCEL LAYOUT
Figure: Excel Layout
19

As shown in figure excel comprises of rows and columns. A rows and columns together forms cell.
Rows starts from 1 and columns from A. so the cell named as A1 A2 …... and so on. Excel also
consist of multiple sheets options at the bottom so that we can add as many as 255 sheet.
3.2 RECORD AND CALCULATE
20
Menu Bar Colums
Cell
Row
Bar
Sheet

21

3.3. ANY 3 CHARTS
22

23

24