Bachelor of Business Administration (BBA-111)

Practical File on
IT Applications in Business Lab

Bachelor of Business Administration (BBA-111)
Guru Gobind Singh Indraprastha University, Delhi
Submitted To Submitted By:

Ms. Chitra Nasa Name: Devansh Maheshwari
(Assistant Professor, IT Department) EnrlNo. ……………..
Mr. Ashish Kumar Nayyar Class: BBA 1st M3

(Assistant Professor, IT Department) Batch: 2021-2024
Institute of Information Technology & Management

Approved By AICTE
Affiliated to Guru Gobind Singh Indraprastha University, Dwarka,
New Delhi
New Delhi – 110058
Batch (2021-2024)
ITB LAB FILE | BBA 1ST M3
INDEX
Sr. No. Practical Name Page Date
No.
1. Create a PowerPoint presentation on any topic of 3 8/12/21
ITB syllabus which is having 10 slides containing
clipping, hyperlink image, formatting and animation
style, etc.
2. Create a Document on Computer and its components 4 15/12/21
that should be properly aligned with paragraph
formatting and insert image of Block diagram of
computer also. Apply bullets in characteristics of
computer and numbering in applications of
computer. Document must contain header and footer
on each & every page.
 Use the “Replace All” option in Find and
Replace to replace each instance of some
word.
 Save and protect your document.
 Write Shortcut keys of MS Word.
3. Insert a 7-column,6-row table to create a calendar 12 22/12/21
for the current month.
a. Enter the names of the days of the week in
the first row of the table.
b. Centre the day names horizontally and
vertically.
c. Change the font and font size as desired.
d. Insert a row at the top of the table.
e. Merge the cells in the row and enter the
current month and year using a large font
size.
f. Shade the row.
g. Enter and right-align the dates for the month
in the appropriate cells of the table.
h. Change the outside border to a more
decorative border. Identify two important
dates in the calendar and shade them.
4. Create a table in MS-Word with the following 13 22/12/21
entries:
S. No, Name, M1,M2,M3,M4,M5 and apply the
following operations on it
1) Calculate the minimum marks in M1 & M3.
2) Calculate the maximum marks in M2 & M5.
3) Find the sum of total marks obtained in Each
subject.
4) Insert a new column named grade in the Table.
5) Sort the table with respect to the column M6.
6) Convert the table into text
5. : Create a document that shows usage of Bookmark 29/12/21
and include hyperlink also.
6. Send a PTM Invitation Letter to 5 different People 5/1/2022
2
using Mail Merge. Write steps corresponding to it.

7. Create a macro using toolbar for creating a table or 12/1/2022
applying formatting .Write steps of the same.
8. Create a spreadsheet of the purchases made by a 12/1/2022
customer in a super mart having the following
fields:.
• S.no
• Product ID
• Product Name
• Product type(food, clothes, toys etc)
• Quantity
• Price per unit
Note: All the field names should be bold and
underlined. Also Insert Borders to the spreadsheet.
9. Create a record of ten students consisting of S.no, 19/1/2022
name and marks in two subjects (M1,M2) and
perform the following operations:
• Find the maximum marks in M2
• Find the minimum marks in M1
• Find the total marks obtained by each student
• Find the average marks of each student
• Sort the records in ascending order of marks
M1
• Sort the record according to descending
order of names
• Find the minimum marks and replace it by
the text “put more efforts”.
• Apply filter on name column
• Create a new field named "percentage" and
calculate it
• Sort the table according to total marks.
10. 1. Create the Column Chart for the sales report 2/2/2022
of the ABC Pvt Ltd.
2. Draw the Pie Chart for the sales report of the
ABC Pvt. Ltd for last 3 years in M.S. Excel and
explore the properties such as add Label, Color etc.
3. Create a Bar graph for 5 states for 3 years
depicting the literacy rate
For the graph created above perform the following
• Switch Row/Column
• Fill Colour
• Add Borders
• Change size
11. Create the student grade (A, B, C & D) report using 2/2/2022
IF and IF Else condition in M.S. Excel. Now
using the conditional formatting fill the A grade as -
pink, B grade as blue, C grade as yellow, D grade as
Green and F as Red.
12. Create a student performance report using 9/2/2022
Conditional formatting in M.S. Excel the following
3
specifications:
• Greater than
• Less than
• Equal to
• Between
• Data bar
• Colour Scales
13. Create the Pivot Chart for the sales laptop of KCL 2/2/2022
Pvt. Ltd for the last 5 years.
14. Define what- if-analysis in Excel. Implement 16/2/2022
Scenario Manager and Goal Seek.
15. To Perform Mathematical Functions, Statistical 23/2/2022
Functions, Financial Functions, Text Functions and
Date and Time Functions.
16. To Implement Various Windows Commands 2/3/2022
4
Practical – 1
Aim: Create a PowerPoint presentation on any topic of ITB syllabus which is having 10
slides containing clipping, hyperlink image, formatting and animation style, etc.
5
6
7
Practical – 2
Aim: Create a Document on Computer and its components that should be properly aligned
with paragraph formatting and insert image of Block diagram of computer also. Apply
bullets in characteristics of computer and numbering in applications of computer. Document
must contain header and footer on each & every page.
 Use the “Replace All” option in Find and Replace to replace each instance of some
word.
 Save and protect your document.
 Write Shortcut keys of MS Word.
Theory:
Computer: A computer is an electronic device that manipulates information, or data. It has
the ability to store, retrieve, and process data. You may already know that you can use a
computer to type documents, send email, play games, and browse the Web. You can also use
it to edit or create spreadsheets, presentations, and even videos.
Components of Computer:
 Input Device: An input device is any hardware device that sends data to a computer,
allowing you to interact with and control it.
 Output Device: An output device is any piece of computer hardware equipment
which converts information into a human-readable form.
 CPU: the portion of a computer that retrieves and executes instructions.
 RAM: Random-access memory is a form of computer memory that can be read and
changed in any order, typically used to store working data and machine code.
 Storage: Computer data storage is a technology consisting of computer components
and recording media that are used to retain digital data.
Block Diagram of Computer:
8
Characteristics of Computer:
 Speed: A computer is a very fast device. It can process the instructions in a fraction of
seconds. The speed of the computer is measured in a microsecond, nanosecond, or
even picoseconds.
 Accuracy: A computer never commits an error in processing. i.e. computer is a 100%

accurate machine. A computer can only give wrong output if we (users) provide
wrong input or instruction to the computer. So, a computer is also called
GIGO (Garbage In Garbage Out) machine
.
 Versatility: Versatility refers to a computer’s ability to perform a variety of tasks
with the same accuracy and performance. A computer is a multitasking machine,
which can perform several types of work at the same time.
 Diligence: The computer is free from the tiredness, lack of concentration. It can work
for hours without creating any errors. Diligence is the property of a computer, so that
computer will never feel tired of doing repetitive tasks again and again. Also, it will
perform every task with the same accuracy.
 Reliability: The output/results obtained by the computer are very reliable. Computer
reliability is defined as the ability of a computer system to perform its required
function for a given period of time with the same accuracy.
 Memory: The computer has an in-built memory where it can store a large amount of
data. We can also store data in a secondary storage device like Hard-disk.
9
Applications of computer:
1. Business: The computer has a high speed of calculation and accuracy which made it an
integrated part of all business organizations. Furthermore, computers assist businesses in
forecasting future revenue, earnings, expenses, and other factors, allowing them to be more
precise in their accounting. Computers have much more influence than numbers alone in
conveying knowledge. Different types of Graphs, Pie-charts, Tables, etc. are used to
represent business ideas in an easy and engaging way.
2. Banking & Financial Sector: The banking sector has dramatically improved its services.
Now it is possible to transfer money within a matter of few seconds, using just a smartphone.
the computer help bankers in keeping track of bank record, customer forms, inventory
management, analysis, loan management & several other tasks as well.Account management
3. Education: Learning with computers has been shown to be more efficient, which is why a
variety of new teaching methods have been implemented. Computer education in schools,
colleges, or other education sectors plays a very important role in student career
development. Following are the samples of how computers are revolutionalizing the
education pattern around the world:
 Student can learn new skills at their own place. [ E-learning / distance learning ]
 They can easily acquire knowledge or showcase their creativity to the rest of the
world.
 Planning and timing problems are reduced or eliminated.
 Students get chance to collaborate with Global professors, and global students. Hence,
they can easily learn the Global Culture of Education.
4. Home: Computers can be used at Home entertainment or they can be used to handle the
home expenses and budget. And most importantly – connect with others in the rest of the
planet.
5. Health and medicine: Computer technology is radically changing the way the Medication
department works. All medical information can now be digitalized. Software is now able to
compute the risk of disease.
6. Entertainment: People can find entertainment on the internet like Watching movie,
Listening songs, download different stuffs, playing games with online partners, Live matches
on the internet etc.
7. Computer in Government Sector: Nowadays, Computers are used in government sectors

to process data, maintain a citizen database, and promote a paperless society. Computers have
significantly aided the country’s defence organizations in the development of missiles,
rockets, and rocket launches. Furthermore, they are used to predict the weather, maintain
10
parks and historical places produce social security checks, collect taxes, Electricity bill pay,
Digital card, Digital Driving license, MRP passports, etc.
 Use the “Replace All” option in Find and Replace to replace each instance of
some word.
Before Applying Replace Option: Computer: A computer is an electronic device that
manipulates information, or data. It has the ability to store, retrieve, and process data. You
may already know that you can use a computer to type documents, send email, play games,
and browse the Web. You can also use it to edit or create spreadsheets, presentations, and
even videos.
After Applying Replace Option: Computer: A computer is an electronic machine that
manipulates information, or data. It has the ability to store, retrieve, and process data. You
may already know that you can use a computer to type documents, send email, play games,
and browse the Web. You can also use it to edit or create spreadsheets, presentations, and
even videos.
 Save and protect your document.
1. Open MS Word
2. Click on file tab
3. Go to Info option, select protect document option
4. A dialogue box will open for asking password for protecting the document,
provide it
5. Again the dialogue box will open for confirmation of the password
11
 Write Shortcut keys of MS Word.
 Ctrl+0 Toggles 6pts of spacing above the paragraph.
 Ctrl+A Select all contents of the page.
 Ctrl+B Bold highlighted selection.
 Ctrl+C Copy selected text.
 Ctrl+D Open the font preferences window.
 Ctrl+E Aligns the line or selected text to the center of the screen.
 Ctrl+F Open find box.
 Ctrl+I Italic highlighted selection.
 Ctrl+J Aligns the selected text or line to justify the screen.
 Ctrl+K Insert a hyperlink.
 Ctrl+L Aligns the line or selected text to the left of the screen.
 Ctrl+M Indent the paragraph.
 Ctrl+N Opens new, blank document window.
 Ctrl+O Opens the dialog box or page for selecting a file to open.
 Ctrl+P Open the print window.
 Ctrl+R Aligns the line or selected text to the right of the screen.
 Ctrl+S Save the open document. Like Shift+F12.
 Alt+F, A Save the document under a different file name.
 Alt+X Show the Unicode code of a highlighted character.
 Ctrl+T Create a hanging indent.
 Ctrl+U Underline the selected text.
 Ctrl+V Paste.
 Ctrl+W Close the currently open document.

 Ctrl+X Cut selected text.
 Ctrl+Y Redo the last action performed.
 Ctrl+Z Undo last action.
 Ctrl+Shift+A Sets the selected text to all capital letters.
 Ctrl+Shift+D Adds double underline to the selected text.
12
 Ctrl+Shift+E Enable or disable revision tracking.
 Ctrl+Shift+F Opens Font window to change the font.
 Ctrl+Shift+L Quickly create a bullet point.
 Ctrl+Shift+> Increase selected font +1pts up to 12pt and then increase font +2pts.
 Ctrl+] Increase selected font +1pts.
 Ctrl+Shift+< Decrease selected font -1pts if 12pt or lower; if above 12, decreases font
by +2pt.
 Ctrl+[ Decrease selected font -1pts.
 Ctrl+/+C Insert a cent sign (¢).
 Ctrl+'+<char> Insert a character with an accent (acute) mark, where <char> is the
character you want. For example, if you wanted an accented é you would use Ctrl+'+e
as your shortcut key. To reverse the accent mark, use the opposite accent mark, often
found on the tilde key.
 Ctrl+Shift+* View or hide non printing characters.
 Ctrl+Left arrow Moves one word to the left.
 Ctrl+Right arrow Moves one word to the right.
 Ctrl+Up arrow Moves to the beginning of the line or paragraph.
 Ctrl+Down arrow Moves to the end of the paragraph.
 Ctrl+Del Deletes word to right of cursor.
 Ctrl+Backspace Deletes word to left of cursor.
 Ctrl+End Moves the cursor to the end of the document.
 Ctrl+Home Moves the cursor to the beginning of the document.
 Ctrl+Spacebar Reset highlighted text to the default font.
 Ctrl+1 Single-space lines.
 Ctrl+2 Double-space lines.
 Ctrl+5 1.5-line spacing.
 Ctrl+= Set selected text as subscript.
 Ctrl+Shift+= Set selected text as superscript.
 Ctrl+Alt+T Insert trademark (TM) symbol.
 Ctrl+Alt+1 Changes text to heading 1.
13
 Ctrl+Alt+F2 Open new document.
 Ctrl+F1 Open the Task Pane.
 Ctrl+F2 Display the print preview.
 Ctrl+Shift+> Increases the font size of selected text by one point.
 Ctrl+Shift+< Decreases the font size of selected text by one point.
 Ctrl+Shift+F6 Switches to another open Microsoft Word document.
 Ctrl+Shift+F12 Prints the document.
 F1 Open help.
 F4 Repeat the last action performed (Word 2000+).
 F5 Open the Find, Replace, and Go To window in Microsoft Word.
 F7 Spellcheck and grammar check selected text or document.
 F12 Save As.
 Shift+F3 Change the text in Microsoft Word from uppercase to lowercase or a capital
letter at the beginning of every word.
 Shift+F7 Runs a Thesaurus check on the selected word.
 Shift+F12 Save the open document. Like Ctrl+S.
 Shift+Enter Create a soft break instead of a new paragraph.
 Shift+Insert Paste.
 Shift+Alt+D Insert the current date.
 Shift+Alt+T Insert the current time
14
Practical – 3
Aim: Insert a 7-column,6-row table to create a calendar for the current month.
i. Enter the names of the days of the week in the first row of the table.
j. Centre the day names horizontally and vertically.
k. Change the font and font size as desired.
l. Insert a row at the top of the table.
m. Merge the cells in the row and enter the current month and year using a large font
size.
n. Shade the row.
o. Enter and right-align the dates for the month in the appropriate cells of the table.
p. Change the outside border to a more decorative border. Identify two important dates
in the calendar and shade them.
December, 2021
Mon Tue Wed Thus Fri Sat Sun
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
x-Mas
27 28 28 30 31
B’Day
15
Practical – 4
Aim: Create a table in MS-Word with the following entries S.No, Name, M1M2,M3,M4,M5
and apply the following operations on it
1) Calculate the minimum marks in M1 & M3.
2) Calculate the maximum marks in M2 & M5.
3) Find the sum of total marks obtained in Each subject.
4) Insert a new column named grade in the Table.
5) Sort the table with respect to the column M6.
6) Convert the table into text.
Table for Operation:

Sr. No. Name M1 M2 M3 M4 M5
1 Himani 89 79 78 98 69
2 Aanya 67 58 89 99 65
3 Garima 76 79 81 82 73
4 Rahul 78 89 99 83 56
5 Anish 77 75 74 56 78
1. Calculate the minimum marks in M1 & M3

1 Himani 89 79 78 98 69
2 Aanya 67 58 89 99 65
3 Garima 76 79 81 82 73
4 Rahul 78 89 99 83 56
5 Anish 77 75 74 56 78
Minimum Marks 67 74
16
2. Calculate the maximum marks in M2 & M5

1 Himani 89 79 78 98 69
2 Aanya 67 58 89 99 65
3 Garima 76 79 81 82 73
4 Rahul 78 89 99 83 56
5 Anish 77 75 74 56 78
Minimum Marks 89 78
3. Find the sum of total marks obtained in Each subject.
Sr. No. Name M1 M2 M3 M4 M5 Total

1 Himani 89 79 78 98 69 413
2 Aanya 67 58 89 99 65 378
3 Garima 76 79 81 82 73 391
4 Rahul 78 89 99 83 56 405
5 Anish 77 75 74 56 78 360
17
4. Insert a new column named grade in the Table.
Sr. No. Name M1 M2 M3 M4 M5 Total Grade

1 Himani 89 79 78 98 69 413
2 Aanya 67 58 89 99 65 378
3 Garima 76 79 81 82 73 391
4 Rahul 78 89 99 83 56 405
5 Anish 77 75 74 56 78 360
5. Sort the table with respect to the column M6.
Sr. No. Name M1 M2 M3 M4 M5 Total

2 Aanya 67 58 89 99 65 378
5 Anish 77 75 74 56 78 360
3 Garima 76 79 81 82 73 391
1 Himani 89 79 78 98 69 413
4 Rahul 78 89 99 83 56 405
18
6. Convert the table into text.
1 Himani 89 79 78 98 69
2 Aanya 67 58 89 99 65
3 Garima 76 79 81 82 73
4 Rahul 78 89 99 83 56
5 Anish 77 75 74 56 78
19
Practical-5
Aim: Create a document that shows usage of Bookmark and include hyperlink also.
Theory:
Hyperlink: A link from a hypertext document to another location, activated by clicking on a

highlighted word or image.
3 ways to create hyperlink:
 Within the same document (demonstrating with example of keyboard)

 Some other document resides at different location (demonstrating with example of
mouse)
 Web address (demonstrating with example of joystick)
Demonstration of hyper link
3 input devices
 Keyboard
 Mouse
 Joystick
Keyboard:
A keyboard is a peripheral device that enables a user to input text into a computer or any
other electronic machinery. A keyboard is an input device and is the most basic way for the
user to communicate with a computer. This device is patterned after its predecessor, the
typewriter, from which the keyboard inherited its layout, although the keys or letters are
arranged to function as electronic switches. The keys include punctuation, alphanumeric and
special keys like the Windows key and various multimedia keys, which have specific
functions assigned to them.
20
Mouse:
21
Joystick:
22
Bookmark: A bookmark in Word serves the same purpose as the bookmark you put in place
in a book. The bookmark marks a place that you want to find easily, and one that you want to
return to when you need. When people ask what is the use of bookmarks in Microsoft ® Word,
let's refer to the bookmarks you use in books.
Output Devices: The output device displays the result of the processing of raw data that is
entered in the computer through an input device. There are a number of output devices that
display output in different ways such as text, images, hard copies, and audio or video.
Monitor
A monitor is an electronic output device that is also known as a video display terminal (VDT)
or a video display unit (VDU). It is used to display images, text, video, and graphics
information generated by a connected computer via a computer's video card. Although it is
almost like a TV, its resolution is much higher than a TV. The first computer monitor was
introduced on 1 March 1973, which was part of the Xerox Alto computer system.
23
Printer
A printer is a hardware output device that is used to generate hard copy and print any
document. A document can be of any type such as a text file, image, or the combination of
both. It accepts input command by users on a computer or on other devices to print the
documents. For example, if you have to submit a project report at your college, you need to
create a soft copy of your report and print it with the help of the printer.
Plotter
A plotter is a printer that interprets commands from a computer to make line drawings on
paper with one or more automated pens. Unlike a regular printer, the plotter can draw
continuous point-to-point lines directly from vector graphics files or commands. There are a
number of different types of plotters: a drum plotter draws on paper wrapped around a drum
24
which turns to produce one direction of the plot, while the pens move to provide the other
direction; a flatbed plotter draws on paper placed on a flat surface; and an electrostatic plotter
draws on negatively charged paper with positively charged toner.
25
Practical - 6
Aim: Send a PTM Invitation Letter to 5 different People using Mail Merge. Write steps
corresponding to it.
Theory:
Steps to Mail Merge:
 Open MS word
 Open a blank document
 Go to mailing tab
 Click on start mail merge option select step by step wizard option
 Select the document type and click on next

 Create a recipient list
 Select type a new list, click on create
 Write your letter
26
 Insert address block
 Insert greeting line
27
 Complete mail merge
28
Practical-7
Aim: Create a macro using toolbar for creating a table or applying formatting .Write steps of
the same.
Theory:
Macro: In word, you can automate frequently used tasks by creating and running macros. A
macro is a series of commands and instructions that you group together as a single command
to accomplish a task automatically.
For example: We can assign Alt + C as a function to make a table, as Alt + C is not shortcut
foe anything.
Steps to perform Macro:
 Open MS word
 Open new document, click on view tab
 Click on macros and select record macros
 Assign a name to the Macro.
 Choose a key combination that is not assigned to do any task then after
choosing a key combination click assign button then finally click on OK
button.
29
 Recording will start by showing a cassette symbol near mouse icon.
 While the Cassette like cursor is present on the screen create a table of 3*5
and apply formation styles to it.
 Then click on Stop Recording.
 Macro will be created as soon as you stop the recording. You can check by
pressing the shortcut key combination you assigned earlier.
 Press ALT + C shortcut and the table will be created.
30
Practical-8
Aim: Create a spreadsheet of the purchases made by a customer in a super mart having the
following fields:
 S.no
 Product ID
 Product Name
 Product type(food, clothes, toys etc)
 Quantity
 Price per unit
Note: All the field names should be bold and underlined. Also Insert Borders to the
spreadsheet.
For the spreadsheet created above, find the total bill, using the auto sum facility of Ms Excel.
And mention the cell reference range and copy formula also.
Steps to do task:
 Open MS Excel
 Do the entries as specified above and apply the formatting also
 Table created
Purchase List of Super Market

S.No. Product ID Product Name Product Type Quantity Price Total Sum
1 P1 burger food 10 30
2 P2 jacket cloth 13 3000
3 P1 pizza food 14 200
4 P3 puzzle toy 12 100
5 P1 pasta food 5 250
6 P3 teddy toy 9 670
 To calculate amount select the cell and put = after that select E3 cell,* symbol
and then select F3 cell, press enter to execute the formula.
31
 To apply auto fill all the entries in amount column select 1st cell which
contain formula and then drag and drop from right corner displaying a + symbol.
 Apply auto sum facility select all cell containing amount and then select the
auto sum facility in excel
32
Practical- 9
Aim: Create a record of ten students consisting of S.no, name and marks in two subjects
(M1,M2) and perform the following operations:
 Find the maximum marks in M2

 Find the minimum marks in M1
 Find the total marks obtained by each student
 Find the average marks of each student
 Sort the records in ascending order of marks M1
 Sort the record according to descending order of names
 Find the minimum marks and replace it by the text “put more efforts”.
 Apply filter on name column
 Create a new field named "percentage" and calculate it
 Sort the table according to total marks.
Solution
Master Table
33
 Find the maximum marks in M2
 Find the minimum marks in M1
34
 Find the total marks obtained by each student
 Find the average marks of each student
35
 Sort the records in ascending order of marks M1
36
 Sort the record according to descending order of names
 Find the minimum marks and replace it by the text “put

efforts”.
37
 Apply filter on name column
 Create a new field named "percentage" and calculate it
38
 Sort the table according to total marks.
39
Practical -10
Aim:
1. Create the Column Chart for the sales report of the ABC Pvt Ltd.
2. Draw the Pie Chart for the sales report of the ABC Pvt. Ltd for last 3 years in M.S.
Excel and explore the properties such as add Label, Color etc.
3. Create a Bar graph for 5 states for 3 years depicting the literacy rate
 Switch Row/Column
 Fill Colour
 Add Borders
 Change size
Master Table
1. Create the Column Chart for the sales report of the ABC Pvt Ltd.
Column Chart
40
2. Draw the Pie Chart for the sales report of the ABC Pvt. Ltd for last 3 years in M.S.
Excel and explore the properties such as add Label, Colour etc
Pie Chart
3. Create a Bar graph for 5 states for 3 years depicting the literacy rate.
 Switch Row/column,
 fill colour
 add borders
 change size
41
Practical -11
Aim: Create the student grade (A, B, C & D) report using IF and IF Else condition in M.S.
Excel. Now using the conditional formatting fill the A grade as -pink, B grade as blue, C
grade as yellow, D grade as Green and F as Red.
1. Master Table
2. After Calculating Percentage
42
3. After applying if formula
4. After Applying Conditional Formatting
43
44
Practical-12
Aim: Create a student performance report using Conditional formatting in M.S. Excel the
following specifications:
 Greater than
 Less than
 Equal to
 Between
 Data bar
 Colour Scales
Master table
1. Find those students/ Highlight the cells those have greater than 80 marks in M1
Subjects.
45
2. Find those students who have lesser than 60 marks in M2 Subjects.
46
3. Find those students who have marks in between 50 to 70 from M3 to M5

Subjects.
4. Find those students who were absent in any subject.
47
5. Find those students who scored top 3 in M4 Subject.
48
6. Apply Data Bar in Total Column to show the effects.
7. Apply Color Scale to M5 Subject to show the effects
49
8. Apply Icon Set on Total Column to show the effects.
50
Practical-13
Aim: Create the Pivot Chart for the sales laptop of KCL Pvt. Ltd for the last 5 years.
Master Table
Steps to create pivot table:

1. Select data, go to Insert Tab
2. Click on Pivot Table
3. Drag & Drop year in Rows Column and Months in Column Labels and total in
Values. See the summarized table
4. Then if you want to see summarized on different aspects ,, then drag and drop
quantity also in values label and you can change the formula on the basis of which
it does summarizing.
51
Pivot first is used to show the total sale of each year
52
1. Pivot table 2 display a consolidated report of sale in each year and month.
53
2. Pivot 3 display a consolidated sales report of each report in last 5 year.
54
55
Practical-14
Aim: Define what- if-analysis in Excel. Implement Scenario Manager and Goal Seek.
Theory:
What if analysis:
By using What-If Analysis tools in Excel, you can use several different sets of values in one
or more formulas to explore all the various results. For example, you can do What-If Analysis
to build two budgets that each assumes a certain level of revenue. Or, you can specify a result
that you want a formula to produce, and then determine what sets of values will produce that
result. Excel provides several different tools to help you perform the type of analysis that fits
your needs.
Problem Statement:
Assume you taken a loan whose principal amount is 4000/-.. How the Interest changes if you
change principal, rate and time.
Scenario Manager:
Is used to compare data side by side and also swap multiple sets of data within a worksheet.
In simple words when you have multiple variables and you want to see their effect on the
final result, and also want to estimate between two or more desired budgets you can use
Scenario Manager. It is built-in functionality in excel and can be spotted under the head
What-If Analysis. It allows users to change input values up to a maximum of 32 cells.
Steps to Implement Scenario Manager:
Master Table
1. On the Data Tab, in the Forecast group, click What-if Analysis
2. Click Scenario Manager
The Scenario Manager Dialog box appears
3. Add a Scenario by Clicking on ADD
56
4. Type a name s1, select cell B2 to B4 for the cells and click Ok
5. Enter the corresponding value and click on OK again
57
6. Next, add 2 other scenarios from s1 to s2

Finally your Scenario Manager should be consistent with the picture below
Note: To see the result of a scenario, select the scenario and click on the Show button.
Excel will change the value of cell B5 accordingly for you to see the corresponding
result on the sheet.
Scenario Summary:
To easily compare the results of these scenarios, execute the following steps.
1. Click the Summary, button in the Scenario Manager.
2. Next, select B5 (total Interest) for the result cell and click on Ok
58
Result:
59
Goal Seek:
Problem Statement: What if you want to know how much amount you should take
if you need to pay this loan for the minimum interest, to obtain a Minimum Interest of
exactly 2400? You can use Excel's Goal Seek feature to find the answer.
Steps:
1. On the Data tab, in the Forecast group, click What-If- Analysis.
2. Click Goal Seek
3. Select cell B5
4. Click in the ‘To value’ box and type 2500
5. Click in the ‘By changing cell’ and select cell B4
6. Click OK
60
61
Practical - 15
Aim: To Perform Mathematical Functions Statistical Functions, Financial Functions, Test
Functions and Date and Time Functions.
MS EXCEL FILE:
Master Table
Mathematical Functions: It is used to calculate values based on what is in cells, perform

operations on a cell content, fetch values after an operational based on your search criteria
and much more.
1. Sum:
It is used to calculate values based on what is in cells, perform operations on a cell
content, fetch values after an operation based on your search criteria and much more.
62
2. Sum if: SUMIF function to sum the values in a range that meet criteria that you
specify
3. Round: The ROUND function rounds a number to a specified number of digits.
63
4. Integer: It is a numerical data type that can hold whole numbers without decimal
positions.
5. Random RAND returns an evenly distributed random real number greater than or
equal to 0 and less than 1
64
6. ABS: the ABS function removes the minus sign (-) from a negative number, making
it positive.
7. PRODUCT:
65
8. Quotient The Excel QUOTIENT function returns the integer portion of division
without the remainder.
9. SQRT: The Excel SQRT function returns the square root of a positive number.
66
10. LOG: The LOG function returns the logarithm of a given number, using the provided
base.
Statistical Function
The COUNT function is used to count the number of cells containing a number
1. Count
The COUNT function counts the number of cells that contain numbers, and counts numbers
within the list of arguments.
67
2. Count A
The COUNTA function counts the number of cells that are not empty in a range.
3. Count Blank
COUNT BLANK function, count the number of empty cells in a range of cells.
68
4. Count If
The COUNTIF function is a premade function in Excel, which counts cells as
specified.
5. Max
MAX will return the largest value in a given list of argument
69
6. Min
MIN will return the minimum value in a given list of arguments
7. Average
Average, which is the arithmetic mean, and is calculated by adding a group of

numbers and then dividing by the count of those numbers.
70
Date and Time Function:

Excel Date and Time functions can be used to extract information from, and perform
operations on, Excel Dates and Times.\
1. Date
The DATE function returns a serial number that corresponds to an Excel date. The DATE
function accepts numeric input only and will return #VALUE if given text.
2. Month Function is used to get month number from date.

This is the most obvious and easiest way to convert date to month in Excel.
3. Day
The Excel DAY function returns the day of the month as a number between 1 to 31
from a given date. You can use the DAY function to extract a day number from a date
into a cell. You can also use the DAY function to extract and feed a day value into
another function, like the DATE function.
71
4. Year
The Excel YEAR function returns the year component of a date as a 4-digit number.
You can use the YEAR function to extract a year number from a date into a cell or to
extract and feed a year value into another formula, like the DATE function.
5. Time
The Excel TIME function is a built-in function that allows you to create a time with
individual hour, minute, and second components. The TIME function is useful when
you want to assemble a proper time inside another formula. Create a time with hours,
minutes, and seconds.
72
Text Function:
The TEXT function lets you change the way a number appears by applying formatting
to it with format codes. It's useful in situations where you want to display numbers in
a more readable format, or you want to combine numbers with text or symbols.
1. Left
The Excel LEFT function extracts a given number of characters from the left side
of a supplied text string. For example, LEFT("apple",3) returns "app". Extract text
from the left of a string. One or more characters.
2. Right
RIGHT returns the last character or characters in a text string, based on the
number of characters you specify.
3. Len
The LEN function returns the number of characters in a given text string. LEN
takes just one argument, text. LEN counts the number of characters in text,
including space and punctuation, and returns a number as the result. If text is an
empty string ("") or text is a reference to an empty cell, LEN returns zero.
73
4. Mid
The Excel MID function extracts a given number of characters from the middle of
a supplied text string. For example, =MID ("apple",2,3) returns "ppl".
74
5. Find
The Microsoft Excel FIND function returns the location of a substring in a string.
The search is case-sensitive. The FIND function is a built-in function in Excel that
is categorized as a String/Text Function. It can be used as a worksheet function
(WS) in Excel.
6. Proper
The Microsoft Excel PROPER function sets the first character in each word to
uppercase and the rest to lowercase. The PROPER function is a built-in function
in Excel that is categorized as a String/Text Function. It can be used as a
worksheet function (WS) in Excel.
75
7. Upper
The UPPER function is an Excel Text function. This cheat sheet covers 100s of
functions that are critical to know as an Excel analyst, that will convert text to all
capital letters (UPPERCASE). Thus, the function converts all characters in a
supplied text string into upper case.
8. Lower
The Excel LOWER function converts a text string to all lowercase letters. Text in
lower case. =LOWER (text) text - The text that should be converted to lower case.
76
9. Concatenate
Use CONCATENATE, one of the text functions, to join two or more text strings
into one string.
10. Rept
The Microsoft Excel REPT function returns a repeated text value a specified
number of times. The REPT function is a built-in function in Excel that is
categorized as a String/Text Function. It can be used as a worksheet function
(WS) in Excel.
Financial Functions:
The excel financial functions have been made available to execute a variety of financial
calculations, including calculations of yield, investment valuations, interest rates, internal rate
of return, asset depreciation, and payments.
1. FV Functions
The Excel FV function is a financial function that returns the future value of an
investment. You can use the FV function to get the future value of an investment
assuming periodic, constant payments with a constant interest rate. .nper - The total
number of payment periods. pmt - The payment made each period
77
2. FV Schedule
The Excel FVSCHEDULE function returns the future value of a single sum based on
a schedule of given interest rates. FVSCHEDULE can be used to find the future value
of an investment with a variable or adjustable rate. Get future value of principal
compound interest
78
3. Rate
The RATE function is an Excel Financial function that is used to calculate the interest
rate charged on a loan or the rate of return needed to reach a specified amount on an
investment over a given period. For a financial analyst, the RATE function can be
useful to calculate the interest rate on zero coupon bonds.
4. PV Function
The Excel PV function is a financial function that returns the present value of an
investment. You can use the PV function to get the value in today's dollars of a series
of future payments, assuming periodic, constant payments and a constant interest rate.
79
Practical - 16
To Implement Windows Commands.
1. Click on start button
2. Type cmd and do a right click run as administration
3. Date: this command display the current date setting and provide way to reset
the date.
80
4. Time: this command is used to display and set the current system time
5. Cls: this command is used to clear the screen

Before cls
81
After cls
6. Cd: this command is used to move from one directory to another
82
6. Vol: this command is used to show the volume and serial number of root of
working directory
7. Label : this is command is used to create ,change or delete a volume label on

logical drive
83
8. Ver: This command is used to name and version of operating system installed
in pc
11. Copy con: its command is used to create file . the name of the file ,which is to be
created ,is written after the copy con leaving one space between
 Type a copy space con space file name .extension and press enter
 Type whatever is to be typed in the file
 Press F6 function or ctrl +z keys will display on the screen , which indicates that file
is complete
 Press enter and after that the dos will save the file and will display the message “ 1
file copied”
84
12. MD: this is command is used to make a new directory is specified location in MS dos
13. RD: this command is used to remove empty directories in MS dos this is also known
RD
85
14. DIR: this is very powerful command in ms dos which is used to display files and
subdirectory inside the specialized location
15. DEL: this command is used for erasing and file from disk
86
16. REN: this command is used to change the name of any file or directory
17. TYPE: this command is used to display the content or text of any file or directory
87
18. Path: this command is used for display or set directories for executable file
19. Copy: the copy command allows user to copy one or more files to an alternative
Location
88
20. Change the console color: this is used for changing the color for the console foreground
and background
21. Exit: this command is used for close or exit the window
89
22. Display the host name : this command will display the domain details of specified IP
address
23. Pause the execution: this command allow the computer to pause the currently running
batch file until the user press any key
90
24. Start: the start program to open files or directories using the default program
25. Display IP network setting : this command display the basic ip addressing for each
network interface on the windows system
91
26. Ping the network: this command is used to test the ability of source of computer
28. Display the attributes: It display, sets or remove the read only ,hidden and archive files
attributes assigned for a file or directory
92
29. Compare the file the content: it can compare singles files or the contents of directories,
when the diff command is run on regular files and when it compare the text files in different
directories , the diff command tells which lines must be changed in the files so that they
match
30. Shut down: this command allows you to shut down a windows computer from
the command line
93

Bachelor of Business Administration (BBA-111)

Uploaded by

Copyright:

Available Formats

Bachelor of Business Administration (BBA-111)

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Bachelor of Business Administration (BBA-111)

Uploaded by

Copyright:

Available Formats

Practical File on

IT Applications in Business Lab

Guru Gobind Singh Indraprastha University, Delhi

Submitted To Submitted By:

Mr. Ashish Kumar Nayyar Class: BBA 1st M3

Institute of Information Technology & Management

using Mail Merge. Write steps corresponding to it.

Block Diagram of Computer:

 Accuracy: A computer never commits an error in processing. i.e. computer is a 100%

 Planning and timing problems are reduced or eliminated.

7. Computer in Government Sector: Nowadays, Computers are used in government sectors

 Save and protect your document.

 Write Shortcut keys of MS Word.

 Ctrl+0 Toggles 6pts of spacing above the paragraph.

 Ctrl+A Select all contents of the page.

 Ctrl+B Bold highlighted selection.

 Ctrl+C Copy selected text.

 Ctrl+D Open the font preferences window.

 Ctrl+F Open find box.

 Ctrl+I Italic highlighted selection.

 Ctrl+J Aligns the selected text or line to justify the screen.

 Ctrl+K Insert a hyperlink.

 Ctrl+M Indent the paragraph.

 Ctrl+N Opens new, blank document window.

 Ctrl+P Open the print window.

 Ctrl+S Save the open document. Like Shift+F12.

 Alt+F, A Save the document under a different file name.

 Alt+X Show the Unicode code of a highlighted character.

 Ctrl+T Create a hanging indent.

 Ctrl+U Underline the selected text.

 Ctrl+W Close the currently open document.

 Ctrl+Y Redo the last action performed.

 Ctrl+Z Undo last action.

 Ctrl+Shift+A Sets the selected text to all capital letters.

 Ctrl+Shift+D Adds double underline to the selected text.

 Ctrl+Shift+E Enable or disable revision tracking.

 Ctrl+Shift+F Opens Font window to change the font.

 Ctrl+Shift+L Quickly create a bullet point.

 Ctrl+] Increase selected font +1pts.

 Ctrl+/+C Insert a cent sign (¢).

 Ctrl+Left arrow Moves one word to the left.

 Ctrl+Right arrow Moves one word to the right.

 Ctrl+Up arrow Moves to the beginning of the line or paragraph.

 Ctrl+Down arrow Moves to the end of the paragraph.

 Ctrl+Del Deletes word to right of cursor.

 Ctrl+Backspace Deletes word to left of cursor.

 Ctrl+End Moves the cursor to the end of the document.

 Ctrl+Home Moves the cursor to the beginning of the document.

 Ctrl+Spacebar Reset highlighted text to the default font.

 Ctrl+1 Single-space lines.

 Ctrl+2 Double-space lines.

 Ctrl+5 1.5-line spacing.

 Ctrl+= Set selected text as subscript.

 Ctrl+Shift+= Set selected text as superscript.

 Ctrl+Alt+T Insert trademark (TM) symbol.

 Ctrl+Alt+1 Changes text to heading 1.

 Ctrl+Alt+2 Changes text to heading 2.

 Ctrl+Alt+3 Changes text to heading 3.

 Ctrl+Alt+F2 Open new document.