IT APPLICATION IN BUSINESS- LAB(BBA 111)

LAB MANUAL

Submitted in partial fulfillment of the requirement of Bachelor’s of

Business Administration (BBA)

Guru Gobind Singh Indraprastha University,Delhi

UNDER THE GUIDANCE OF: SUBMITTED BY:

Mrs. Reema Agrawal ANSHAJ SINGH

(Assistant Professor)
(05925501722)

BBA BATCH 2022-2025

JIMS ENGINEERING MANAGEMENT TECHNICAL CAMPUS

48/4 KNOWLEDGE PARK III,GREATER NOIDA-201306(U.P.)

IT ASSIGNMENT BY ANSHAJ SINGH

STUDENT’S UNDERTAKING

I hereby certify that this is my original work and it has never been
submitted elsewhere.

NAME – ANSHAJ SINGH

ENROLLMENT NUMBER - 05925501722

1|P age
IT ASSIGNMENT BY ANSHAJ SINGH

CERTIFICATE OF COMPLETION

This is to certify that Mr. Anshaj Singh of

BBA has competed his file on “IT Application
in Business-Lab” on his own. His work is up
to my satisfaction.

Mrs. Reema Agrawal

2|P age
IT ASSIGNMENT BY ANSHAJ SINGH

INDEX
S.NO. TOPIC

1 MICROSOFT WORD

2 MS WORD RIBBONS & TABS

3 MICROSOFT EXCEL

4 MS EXCEL RIBBONS &TABS

5 MICROSOFT
POWERPOINT
6 MS POWERPOINT RIBBONS
& TABS

3|P age
IT ASSIGNMENT BY ANSHAJ SINGH

MICROSOFT Word
Microsoft Word is a computer application program written by
Microsoft. It is mainly used to design text for presentation.

Microsoft Word is word processing software. It is developed by

Microsoft and is part of Microsoft Office Suite. It enables you to
create, edit and save professional documents like letters and
reports.

Microsoft word was released in 1983 as Multi-Tool Word. Its first

version was based on the framework of Bravo which was world's
first graphical writing program.

Microsoft renamed Multi Tool Word to Microsoft Word, and then in

October 1983, Microsoft released its first version for the IBM PC.

In 1985, Microsoft ported it to the Macintosh which was different

from its DOS- based counterpart, i.e. Macintosh offered various
major interface changes. In 1989, Microsoft released a new version
of Word for its Windows operating systems. It was the Microsoft
Word who introduced the concept of WYSIWYG (What You See Is
What You Get), i.e. it allowed to create and display bold and italics
text.

4|P age
IT ASSIGNMENT BY ANSHAJ SINGH

Ribbon and Tabs

The Ribbon is a user interface element which was introduced by Microsoft in
Microsoft Office 2007. It is located below the Quick Access Toolbar and the Title
Bar. It comprises seven tabs; Home, Insert, Page layout, References, Mailing,
Review and View. Each tab has specific groups of related commands. It gives
you quick access to the commonly used commands that you need to complete a
task.

HOME TAB:

The Home tab is the default tab in Microsoft Word. It has five groups of related
commands; Clipboard, Font, Paragraph, Styles and Editing. It helps you change
document settings like font size, adding bullets, adjusting styles and many other
common features. It also helps you to return to the home section of the document.

P1: Print ‘ANSHAJ SINGH’ in 10 different fonts & sizes –

S.no. Name
1 ANSHAJ SINGH
2 ANSHAJ SINGH
3 ANSHAJ SINGH
4 ANSHAJ SINGH
5 ANSHAJ SINGH
6
ANSHAJ SINGH

5|P age
IT ASSIGNMENT BY ANSHAJ SINGH

7
ANSHAJ SINGH
8
ANSHAJ SINGH
9
ANSHAJ SINGH
ANSHAJ SINGH
10

P2: Print ‘ANSHAJ SINGH’ in all different alignments –

LEFT ALIGNMENT CENTRE ALIGNMENT RIGHT ALIGNMENT JUSTIFY

(Ctrl + L) (Ctrl + E) (Ctrl + R) (Ctrl + J)
ANSHAJ SINGH ANSHAJ SINGH ANSHAJ SINGH ANSHAJ SINGH

P3: Show the use of bullet points –

 TYPES OF CAR ENGINE:

1. PETROL
2. DIESEL

INSERT TAB:
Insert Tab is the second tab in the Ribbon. As the name suggests, it is used to insert
or add extra features in your document. It is commonly used to add tables,
pictures, clip art, shapes, page number, etc. The Insert tab has seven groups of
related commands; Pages, Tables, Illustrations, Links, Header & Footer, Text and
Symbols.

6|P age
IT ASSIGNMENT BY ANSHAJ SINGH

P1: INSERT A TABLE WITH 4ROWS AND 6COULMNS & SHOW HOW TO DELETE OR INSERT A
ROW/COLUMN –

TO DELETE A ROW OR COLUMN, SELECT THE ROW/COLUMN AND PRESS Ctrl + X

TO INSERT A ROW/COLUMN, RIGHT CLICK ON MOUSE, SELECT INSERT A ROW/ COLUMN

ABOVE/BELOW/RIGHT/LEFT.

P2: INSERT ILLUSTRATIONS –

INSERTED A PICTURE FROM GALLERY INSERTED A TEXT BOX & A PICTURE ONLINE

P3: INSERT SHAPES AND SMART ART & CHARTS –

7|P age
IT ASSIGNMENT BY ANSHAJ SINGH

Chart Title Chart Title

Series 1 Series 2 10
0
01-…
40
012-0… 01-…
0 Series 1 Series 2
01-… 01-…
Series 3

P3: INSERT AN ONLINE VIDEO -

P4: INSERT A HYPERLINK – Top of the Document

P5: INSERT A CROSS REFERENCE- 2

P6: INSERT HEADER AND FOOTER TO THIS PAGE- (INSERTED)

P7: INSERT PAGE NUMBER ON THE RIGHT FOOT OF THE PAGE- (INSERTED)
7 𝑛 𝑛 𝑘 𝑛−𝑘
𝑛

P8: INSERT A FORMULA - ∫2 (𝑥 + 𝑎) = ∑ (𝑘)𝑥 𝑎

𝑘=0

8|P age
IT ASSIGNMENT BY ANSHAJ SINGH

PAGE LAYOUT TAB:

It is the third tab in the Ribbon. This tab allows you to control the look and feel
of your document, i.e. you can change the page size, margins, line spacing,
indentation, documentation orientation, etc. The Page Layout tab has five groups
of related commands; Themes, Page Setup, Page Background, Paragraph and
Arrange.

9|P age
IT ASSIGNMENT BY ANSHAJ SINGH

REFERENCES TAB:
It is the fourth tab in the Ribbon. It allows you to enter document sources,
citations, bibliography commands, etc. It also offers commands to create a table
of contents, an index, table of contents and table of authorities. The References
tab has six groups of related commands; Table of Contents, Footnotes, Citations
& Bibliography, Captions, Index and Table of Authorities.

Use this to insert footnote.

10 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

Mailings tab:
It is the fifth tab in the ribbon. It is the least-often used tab of all the tabs available
in the Ribbon. It allows you merge emails, writing and inserting different fields,
preview results and convert a file into a PDF format. The Mailings tab has five
groups of related commands; Create, Start Mail Merge, Write & Insert Fields,
Preview Results and Finish.

Review tab:
It is the sixth tab in the Ribbon. This tab offers you some important commands to
modify your document. It helps you proofread your content, to add or remove
comments, track changes, etc. The Review tab has six groups of related commands;
Proofing, Comments, Tracking, Changes, Compare and Protect.

View tab:
The View tab is located next to the Review tab. This tab allows you to switch
between Single Page and Two Page views. It also enables you to control various
layout tools like boundaries, guides, rulers. Its primary purpose is to offers you
different ways to view your document. The View tab has five groups of related
commands; Document Views, Show/Hide, Zoom, Window and Macros.

11 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

MICROSOFT
EXCEL
Microsoft Excel is a computer application program written by Microsoft.
It mainly comprises tabs, groups of commands, and worksheets. It stores
the data in tabular form and allows the users to perform manipulation
operations on them.
Microsoft Excel is an office use application designed by Microsoft. It
comes with Office Suite with several other Microsoft applications, such as
Word, Powerpoint, Access, Outlook, and OneNote, etc. It is supported in
Windows as well as Mac operating system too.
Microsoft Excel is one of the most suitable spreadsheet programs that help
us to store and represent the data in tabular form, manage and manipulate
data, create optically logical charts, and more. Excel provides you the
worksheet to create a new document in it. You can save the Excel file
with .xls extension.

12 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

Worksheet:
A worksheet is made of rows and columns that intersect each other to form cells
where data is entered. It is capable of performing multiple tasks like calculations,
data analysis, and integrating data.

In Excel worksheet, rows are represented by numbers and columns by alphabets.

A single Excel workbook can consist of several sheets, named Sheet1,

Sheet2, Sheet3… SheetN. You can add one or more sheets to your Excel
document.

Microsoft Excel Features:

There are several features that are available in Excel to make our task more
manageable. Some of the main features are:
13 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

1. AutoFormat: It allows the Excel users to use predefined table formatting options.

2. AutoSum: AutoSum feature helps us to calculate the sum of a row or

column automatically by inserting an addition formula for a range of cells.
3. List AutoFill: It automatically develops cell formatting when a new
component is added to the end of a list.
4. AutoFill: This feature allows us to quickly fill cells with a repetitive or
sequential record such as chronological dates or numbers and repeated
documents. AutoFill can also be used to copy functions. We can also alter
text and numbers with this feature.
5. AutoShapes: AutoShapes toolbar will allow us to draw some geometrical
shapes, arrows, flowchart items, stars, and more. With these shapes, we can
draw our graphs.

14 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

6. Wizard: It guides us to work effectively while we work by displaying

several helpful tips and techniques based on what we are doing. Drag and
Drop feature will help us to reposition the record and text by simply
dragging the data with the help of the mouse.
7. Charts: This feature will help you to present the data in graphical form by
using Pie, Bar, Line charts, and more.
8. PivotTable: It flips and sums data in seconds and allows us to execute data
analysis and generating documents like periodic financial statements,
statistical documents, etc. We can also analyse complex data relationships
graphically.
9. Shortcut Menus: The shortcut menu helps users to make the work done
through shortcut commands that need a lengthy process

How to Open Microsoft Excel?

In Windows 10 operating system, click on the Start button and search for
the MS Excel application. If it is already installed in your system, it will appear
here like this.

15 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

16 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

Double-tap on this icon to open the Excel.

When the Excel opens, an interface will appear like this. From here, you can
create a new workbook, choose a template, and access your recently edited
workbooks.

Create a new workbook:

To create a new workbook, click on the Blank Workbook here.

17 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

18 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

A blank Excel worksheet will open and display to you.

19 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

After the first 26 column headings (A through Z), the next

26 column headings are AA through AZ. The column headings
continue through column XFD, for a total of 16,384 columns:

Callout 1: Column headings are indicated by letters.Callout 2: Row

headings are indicated by numbers.

Worksheets are divided into columns, rows, andcells. That's the

grid you see when you open up a workbook.

Columns go from top to bottom on the worksheet, vertically. Rows go from left
to right on the worksheet, horizontally. A cell is the space where one column
and one row meet

D
o
w
n
l
o
a
d
e
d
b
y
h
e
y
b
i
t
c
h
(
j
b
1
1
6
6
3
2
@
g
m
a 20 | P a g e
i
l
.
c
o
m
IT ASSIGNMENT BY ANSHAJ SINGH

RIBBON AND TABS IN EXCEL

Excel ribbon is the row of tabs and icons at the top of the Excel window that
allows you to find, understand and use commands for completing a certain task.
Excel ribbon is the primary interface that contains every command and feature.
The Ribbon has multiple display options according to your preferences.

In Excel Ribbon, the buttons and icons are grouped into different tabs based on
the category of their functionalities. It contains seven tabs: Home, Insert, Page
Layout, Formulas, Data, Review, and View.

Each tab has its specific groups of related commands. These groups have several
additional commands that can view by clicking the arrow at the right bottom
corner of any group.

The Ribbon first appeared in Excel 2007, replacing the traditional toolbars and
pull-down menus found in previous versions. In Excel 2010, Microsoft added the
ability to personalize the Ribbon.

In Excel, the Ribbon is made up of these four basic components, such as:

1. Ribbon tab: It contains multiple commands logically subdivided into groups.

2. Ribbon group: A set of closely related commands normally performed as part of a
larger task.
3. Dialog launcher: A small arrow in the lower-right corner of a group brings
up more related commands. Dialog launchers appear in groups that contain
more commands than available space.
4. Command button: It is the button you click to perform a particular action.
21 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH
EXCEL RIBBON TABS
The standard Excel ribbon contains the following tabs, from left to right:

o File: It allows you to jump into the backstage view that contains the
essential file-related commands and Excel options.
o Home: It contains the most frequently used commands such as copying
and pasting, sorting and filtering, formatting, etc.
o Insert: It is used for adding different objects in a worksheet such as images,
charts, PivotTables, hyperlinks, special symbols, equations, headers, and
footers.
o Draw: It depends on the device type you're using. It lets you draw with a
digital pen, mouse, or finger.
o Page Layout: It provides tools to manage the worksheet appearance, both
onscreen and printed. These tools control theme settings, gridlines, page
margins, object aligning, and print area.
o Formulas: It contains tools for inserting functions, defining names, and
controlling the calculation options.
o Data: It holds the commands for managing the worksheet data as well as
connecting to external data.
o Review: It allows you to check spelling, track changes, add comments and
notes, protect worksheets and workbooks.
o View: It provides commands for switching between worksheet views,
freezing panes, viewing, and arranging multiple windows.
o Help: It only appears in Excel 2019 and Office 365. This tab provides quick
access to the Help Task Pane and allows you to contact Microsoft support,
send feedback, suggest a feature, and get quick access to training videos.

22 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

o Developer: It provides access to advanced features such as VBA

macros, ActiveX and Form controls, and XML commands. This tab is
hidden by default, and you have to enable it first.
o Add-ins: It appears when you open an older workbook or load an add-in
that customizes the toolbars or menu.

FEATURES OF TABS IN EXCEL

The ribbon is designed to assist in quickly finding Excel commands to complete a
task. The commands are grouped together in logical groups, which are collected
together under tabs.

Commands related to working with Excel workbook content are represented as

buttons on the tabs that make up the groups. The Home tab is activated by default
when Excel is opened. Within each tab, except the File Tab, the buttons are
organized into groups. In some groups, the button that might be used most often
is larger than the other buttons.

Less common commands can be accessed by clicking the Dialog Box or Task
Pane Launcher button located in the lower right corner of the group about the
command.

Many tabs are available on the Ribbon in Microsoft Excel, such as Home, Insert,
Page Layout, Formula, Data, Review, and View, and each tab has different
features.

HOME TAB
The excel Home Tab is used to execute regular instructions like bold, underline,
copy, and paste. It is also used to apply formats to cells in a worksheet. It contains
Clipboard, Font, Alignment, Number, Cells, and Editing.

23 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

1. Clipboard: This Clipboard Group is primarily used for Cut copy and paste. It
means, if you want to transfer data from one place to another, then you have two
choices, either COPY (preserves the data in the original location) or CUT (deletes
the data from the original location).

2. Fonts: This font group within the Home tab is used for choosing the desired
Font and size. There are hundreds of fonts available in the dropdown, which we
can use for.

In addition, you can change the font size from small to large, depending on your
requirements. Also helpful is the feature of Bold (B), Italics (I), and Underline
(U) of the fonts.

3. Alignment: This group is used to align tabs, such as Top, Middle, or Bottom
alignment of text within the cell. And there are other standard alignment options
like Left, middle, and right alignment. There is also an orientation option that can
be used to place the text vertically or diagonally.

4. Number: This group provides options for displaying number format. There are
various formats available, such as general, accounting, percentage, comma style
in excel, etc. You can also increase and decrease the decimals using this group.

5. Styles: You can have various styles for cells like Good, Bad, and Neutral. Other
sets of styles are available for Data and Models like Calculation, Check, Warning,
etc.

In addition, you can make use of different Titles and Heading options available within
Styles.

o The format Table allows you to convert mundane data into an

aesthetically pleasing data table quickly.
o Conditional formatting is used to format cells based on certain
predefined conditions. These are very helpful in spotting the patterns
across an excel sheet.

24 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

6. Cells: This group is used to modify the cell according to its height and width
etc. Also, you can hide and protect the cell using Format Feature. You can also
insert and delete new cells and rows from this group.

7. Editing: This group within the Home Tab is useful for Editing the data on an
excel sheet. The most prominent of the commands here is the Find and Replace
in Excel Also, you can use the sort feature to analyse your data (sort from A to Z
or Z to A), or you can do a custom sort here.

P1: Print ‘ANSHAJ SINGH’ in all different alignments –

LEFT ALIGNMENT CENTRE ALIGNMENT RIGHT ALIGNMENT JUSTIFY

(Ctrl + L) (Ctrl + E) (Ctrl + R) (Ctrl + J)
ANSHAJ SINGH ANSHAJ SINGH ANSHAJ SINGH ANSHAJ SINGH

P2: Print ‘ANSHAJ SINGH’ in 10 different fonts & sizes –

S.no. Name
1 ANSHAJ SINGH
2 ANSHAJ SINGH
3 ANSHAJ SINGH
4 ANSHAJ SINGH
5 ANSHAJ SINGH
6
ANSHAJ SINGH
7
ANSHAJ SINGH
8
ANSHAJ SINGH
9
ANSHAJ SINGH
ANSHAJ SINGH
10

25 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

INSERT TAB
The Insert Tab is used to insert distinct features like tables, pictures, clip art, shapes, charts,
page numbers, word art, headers, and footers into a document. It contains Tables, Illustrations,
Add-Ins, Charts, Tours, Sparklines, Filters, Links, Text, and Symbols groups. The below table
describes each of the teams and buttons present on this tab.

1. Tables: This group provides an excellent way to organize the data. You can use a table to
sort, filter, and format the data within the sheet. You can also use Pivot Tables to analyze
complex data very easily.

2. Illustrations: This group provides a way to insert pictures, shapes, or artwork into excel.
You can insert the pictures directly from the computer or use Online Picture Option to search
for relevant pictures.

o The shapes provide additional ready-made square, circle, arrow kinds of shapes that
can use in excel.
o SmartArt provides an awesome graphical representation to visually communicate data
in List, organizational charts, Venn diagrams, and process diagrams.

3. Charts: It helps you visualize the data in a graphical format. You can make graphs on your
own, and excel provides various options like Pie-chart, Line Chart, Column Chart in Excel,
Bubble Chart k in Excel, combo chart in excel, Radar Chart in Excel, and Pivot Charts in Excel.
Recommended charts allow Excel to come up with the best possible graphical combination.

26 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

4. Hyperlink: This is a great tool to provide hyperlinks from the excel sheet to an external
URL or files. Hyperlinks can also use to create a navigation structure with the excel sheet that
is easy to use.

5. Text: This group is used to text in the desired format, such as add header and footer.

o WordArt allows you to use different styling for text.

o You can also create your signature using the Signature line
o Symbols are special characters that we may want to insert in the excel sheet for better
representation.

o The equation allows you to write mathematical equations that we cannot ordinarily write in an
Excel sheet.

P1: INSERT A TABLE WITH 5ROWS AND 5COULMNS & SHOW HOW TO DELETE OR INSERT A
ROW/COLUMN –

TO DELETE A ROW OR COLUMN, SELECT THE ROW/COLUMN AND PRESS Ctrl + X

TO INSERT A ROW/COLUMN, RIGHT CLICK ON MOUSE, SELECT INSERT A ROW/ COLUMN
ABOVE/BELOW/RIGHT/LEFT.

P2: INSERT ILLUSTRATIONS –

INSERTED A PICTURE FROM GALLERY

INSERTED A TEXT BOX & A PICTURE ONLINE

27 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

P3: INSERT SHAPES AND SMART ART & CHARTS –

Chart Title Chart Title

Series 1 Series 2 10
0
01-…
40
2 0
01-… 01-…
0 Series 1 Series 2
01-… 01-…
Series 3

o P4: INSERT A HYPERLINK – Top of the Document

o P5: INSERT A CROSS REFERENCE- 2

o P6: INSERT HEADER AND FOOTER TO THIS PAGE- (INSERTED)

o P7: INSERT PAGE NUMBER ON THE RIGHT FOOT OF THE PAGE- (INSERTED)

𝑛
o P8: INSERT A FORMULA - (𝑥 + 𝑎)𝑛 = ∑ (𝑛 )𝑥𝑘𝑎𝑛−𝑘
𝑘
𝑘=0

28 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

PAGE LAYOUT TAB

The Page Layout Tab holds all the choices that permit you to rearrange your document pages
simply in the manner you wish them. You can set margins, apply themes, manage page
orientation and size, add sections and line breaks, show line numbers, and set paragraph
indentation and lines. It contains Themes, Page Setup, Scale to fit, Sheet Options, Arrange.

1. Themes: Themes allow you to change the style and visual look of excel. You can choose
various styles available from the menu. You can also customize the colors, fonts, and effects
in the excel workbook.

2. Page Setup: This is an important group primarily used along with printing an excel sheet.

o You can choose margins for the print.

o You can choose your printing orientation from Portrait to Landscape.
o You can choose the size of paper like A3, A4, Letterhead, etc.
o The print area allows you to see the print area within the excel sheet and helps make the
necessary adjustments.

o We can also add a break where we want the next page to begin in the printed copy.
o Also, you can add a background to the worksheet to create a style.

29 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

o Print Titles is like a header and footer in excel that we want them to be repeated on each printed
copy of the excel sheet.

3. Scale to Fit: This option is used to stretch or shrink the printout of the page to a percentage
of the original size. You can also shrink the width as well as height to fit in a certain number
of pages.

4. Sheet Options: It is another useful feature for printing. If we want to print the grid, then we
can check the print gridlines option. If we want to print the Row and column numbers in the
excel sheet, we can also do the same using this feature.

5. Arrange: Here, we have different options for objects inserted in Excel like bring forward,
Send Backward, Selection Pane, Align, Group Objects, and Rotate.

30 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

FORMULA TAB
The formula tab is used to insert functions, outline the name, produce the name, review the
formula, etc. In the ribbon, the Formulas tab has vital and most helpful functions to form
dynamic reports. It contains Function Library, Defined Names, Formula Auditing, and
Calculation.

1. Function Library: This is a very useful group that contains all the formulas that one uses
in excel. This group is subdivided into important functions like Financial Functions, Logical
Functions, Date & Timing, Lookup & References, Maths and Trignometry, and other functions.
One can also make use of Insert Function capabilities to insert the function in a cell.

2. Defined Names: This feature can be used to name the cell, and these named cells can be
called from any part of the worksheet without working about its exact locations.

3. Formula Auditing: This is used for auditing the flow of formulas and their linkages.

o It can trace the precedents (origin of data set) and show which dataset depends on this.
o Show formula can also use to debug errors in the formula.
o The Watch window in excel is also useful for keeping a tab on their values as you update other
formulas and datasets in the excel sheet.

4. Calculations: The option selected for calculation is automatic. However, one can also
change this option to manual.

31 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

DATA TAB
The data tab contains options mainly for filtering, sorting, and manipulating data. It has options
for importing external data.

1. Get External Data: This option is used to import external data from various sources like
Access, Web, Text, SQL Server, XML, etc.
2. Power Query: This is an advanced feature used to combine data from multiple sources and
present it in the desired format.
3. Connections: This feature is used to refresh the excel sheet when the data in the current excel
sheet comes from outside sources. You can also display the external links as well as edit those
links from this feature.
4. Sort & Filter: This feature can be used to sort the data from A to Z or Z to A, and also you can
filter the data using the dropdown menus. Also, one can choose advanced features to filter using
complex criteria.
5. Data Tools: This is very useful for advanced excel users. One can create various scenario
analyses using Whatif analysis - Data Tables, Goal Seek in Excel, and Scenario Manager. Also,
one can convert Text to Column, remove duplicates and consolidate from this group.
6. Forecast: This Forecast function can be used to predict the values based on historical values.
7. Outline: One can easily present the data in an intuitive format using the Group and Ungroup
options.

32 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

REVIEW TAB
The review tab contains tools mainly for spell checking, thesaurus, sharing, protecting, and
tracking changes in Excel Worksheets.

1. Proofing: Proofing allows you to run spell checks in excel. In addition to spell checks, one can
also use a thesaurus if you find the right word. There is also a research button that helps you
navigate the encyclopedia, dictionaries, etc., to perform tasks better.
2. Language: You can translate the excelsheet from English to any other language by using this
feature.
3. Comments: This feature is used to write an additional note for important cells. It helps the
user understand clearly the reasons behind your calculations etc.
4. Changes: If you want to keep track of the changes made, one can use the Track Changes option.
Also, you can protect the worksheet or the workbook using a password from this option.

33 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

VIEW TAB
View tab contains mainly commands to view the Excel worksheet, like change views, freeze
panes, arrange multiple windows, etc.

1. Workbook Views: You can choose the viewing option of the excel sheet from this group. You
can view the excel sheet in the default normal view, or you can choose Page Break view, Page
Layout view, or any other custom view of your choice.
2. Show: This feature can be used to show or not show Formula bars, grid lines, or Heading in
the excel sheet.
3. Zoom: Sometimes, an excel sheet may contain a lot of data, and you may want to change zoom
in or zoom out desired areas of the excel sheet.
4. Window: The new window is a helpful feature that allows the user to open the second window
and work on both simultaneously. Also, freeze panesare another useful feature that allows
freezing of particular rows and columns such that they are always visible even when one scrolls
to the extreme positions. You can also split the worksheet into two parts for separate navigation.
5. Macros: This is again a fairly advanced feature, and you can use this feature to automate certain
tasks in Excel Sheet. Macros are nothing but a recorder of actions taken in excel, and they can
execute the same actions again if required.

34 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

MICROSOFT
POWERPOINT
Microsoft PowerPoint is a computer application
program written by Microsoft. It mainly used to Design
for Presentation.
Microsoft PowerPoint, usually just called the PowerPoint, is a software
program developed by Microsoft to produce effective presentations. It
is a part of Microsoft Office suite. The program comprises slides and
various tools like word processing, drawing, graphing and outlining.
Thus it can display text, table, chart, graphics and media in the slides.

35 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

FEATURES OF POWERPOINT
Microsoft PowerPoint is a professional presentation
program that allows the user to create a "presentation
slide" that can be displayed on the computer screen
through a projector that is plugged into the computer.
There are three main features of the Microsoft
PowerPoint window that you need to focus upon while
learning PowerPoint. These features are Microsoft
Office Button, Quick Access Toolbar and Ribbon. Some
of the other important features of PowerPoint are:
o Ribbon: PowerPoint has a new, intuitive user
interface called the Ribbon that helps you create
better presentations much more quickly than you
could in earlier versions of PowerPoint.
o Live Preview: PowerPoint takes advantage of the
live preview feature to review your formatting
choices before you apply them.
o Create Dynamic Presentations: PowerPoint
quickly creates dynamic and great looking
presentations using the redesigned user interface and
new graphics capabilities.
o Video Capabilities: One of the attractive features of
Microsoft PowerPoint is that it allows you to use
video in your presentations. With this software, you
36 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

can embed a video clip into one of your slides and

use it during the slideshow. When you embed the
video, you can also perform a number of editing
functions which will allow you to alter the video to
your needs for the presentation.
o Apply a consistent look and feel in one click:
PowerPoint themes help you change the look and
feel of your entire presentation with just one click.
PowerPoint comes with new themes, layouts and
Quick Styles that offer you a wide range of options
when you are formatting your presentations.
Changing the theme of your presentation not only
changes the background colour but the colour of a
diagram, table etc and even the style of any bullet
points within a presentation.
o Sharing: Another feature of Microsoft PowerPoint
is the ability to share presentations with other
individuals in different locations.
o Dynamically modify shapes, text, and graphics
with new tools and effects: You can now
manipulate and work with your text, tables, charts
and other presentation elements in much richer ways
than ever before.
o Special Effects: When creating a presentation, one
of your jobs as a presenter is to keep the attention of
37 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

your audience. If you create a plain presentation

without any flair, your subjects may not pay
attention for long. With Microsoft PowerPoint, you
can use a number of special effects to enhance the
quality of your presentations.
o Reduce your document sizes and improve file
recovery at the same time: The new compressed
Microsoft PowerPoint XML Format offers a
dramatic reduction in file size, while offering an
improvement in data recovery for damaged files.
o Support other file formats: PowerPoint enables
support for other file formats, such as PDF and XPS.

38 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

RIBBON AND TABS

o Ribbon is located on the top of the PowerPoint window
just below the Title bar. It is made up of seven tabs; Home,
Insert, Design, Animations, Slide Show, Review and
View. Each tab is divided into groups of related
commands that are displayed on the Ribbon. To view
additional commands of a group click the arrow at the
right bottom corner of the group.

FEATURES OF THE TABS

HOME TAB
The features of Home tab are Clipboard, Slides, Font, Paragraph, Drawing and Editing.

39 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

You can add a new slide by clicking on the new slide option in the
slides section in the Home tab

40 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

INSERT TAB
The features of Insert tab are Tables, Illustrations, Links, Text and Media Clips.

You can insert pictures from the system, online pictures, screenshots and photo albums -

41 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

DESIGN TAB
The features of Design tab are Page Setup, Themes and Background.

42 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

You change the background of the slides, adjust its

colour and fill, you can add a design to all the
slides, and the size of the slides can be changed.

43 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

ANIMATIONS TAB
The features of Animations tab are Preview, Animations and Transition to This Slide.

44 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

SLIDESHOW TAB
The features of Slide Show tab are Start Slide Show, Set Up and Monitors

45 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

REVIEW TAB
The features of Review tab are Proofing, Comments and Protect.

You can translate the data into some other language using the translate option in the review
tab. You can check your spellings, add new comments.

46 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

VIEW TAB
The features of View tab are Presentation Views, Show/Hide, Zoom, Color/Grayscale, Window
and Macros.

47 | P a g e
IT ASSIGNMENT BY ANSHAJ SINGH

THANK YOU
I am grateful for getting this opportunity of
making this project, which enhanced my
knowledge and skills.

- Anshaj Singh

48 | P a g e