It practical
Subject Code: BCOM 113
Subject Name: Information Technology for Commerce (Lab Based)
Faculty Name: Dr Ruchi Singhal
Student Name: Ashish Panwar
Enrollment Number:3847
IT Assignment
Q1. Creating a folder of your name at the Desktop then save the word files in that folder.
Rename the saved files in your folder to any new name and then move (cut) them to the
desktop.Create a folder of your name on Desktop and create 5 Subfolder inside that folder
Sol. Step 1: Right-click on the desktop and from the menu click on New. Next select Folder.
Step 2: A New Folder will appear on the desktop.
Step 3: Backspace the blue highlighted portion and type your name. Once the folder is created, double
click to open it.
1
IT Assignment
Q2 Create a folder of your name on Desktop and create five subfolders that folder.
Step 1: Open the folder already created by double clicking on it.
Step 2: Right click on page then go to new and select Folder.
Step 3: Repeat the same step 5 time
2
IT Assignment
Q3.Check the System Hardware Configuration of your computer.
Sol. Step 1:Open Settings on your computer and click on System
Step 2: Click on About and you will find system configuration
3
IT Assignment
Q4 Write a paragraph in MS Word and use formatting features bold , italic and underline. The
font type should be arial and fort size should be 12points. set the page margins bottom top left
and right to 1.15.
Generally Accepted Accounting Principles (GAAP or US GAAP) are a collection of
commonly-followed accounting rules and standards for financial reporting. The
specifications of GAAP, which is the standard adopted by the U.S. Securities and
Exchange Commission (SEC), include definitions of concepts and principles, as well as
industry-specific rules. The purpose of GAAP is to ensure that financial reporting is
transparent and consistent from one organization to another.
4
IT Assignment
5
IT Assignment
6
IT Assignment
Q5 Insert picture in MS Word and adjust brightness and contrast of the picture.
Sol. Steps:-
1. Go to Insert Tab and click on Picture.
2. Select the picture required.
3. Go to Format Tab.
4. Under Adjust Group choose Compress to compress the picture
5. Now choose Correction option from the same tab and same group to change the brightness.
7
IT Assignment
8
IT Assignment
9
IT Assignment
10
IT Assignment
Q6 Create a three-page document in MS Word and use the Header and Footer. Header should
contain the Title Name in the middle. Footer should contain the page number at the left side.
Sol. Steps:-
1. Under the Insert tab go to the Header & Footer group.
2. Click on header and pick any header template of your choice.
3. Now click on page number and pick any template of your choice.
11
IT Assignment
12
IT Assignment
Q7 Create a Book Index in MS Word using Bullets and Numbering (use any book index as
source).
● Mathematical foundations
● Algorithms and data structures
● Artificial intelligence
● Communication and security
● Computer architecture
● Computer graphics
● Concurrent, parallel, and distribution systems
13
IT Assignment
● Database
14
IT Assignment
Steps:-
1. Write the name of all the topics to be mentioned in the index.
2. Go to the Home Tab and under the Paragraph group select the Bullet option after selecting
the written content.
Q7Create a Table In Ms-Word document, the table should contain student database like name,
address, course and mobile number. Change the border of the table..
Sol. Step 1: On the taskbar, click on the Insert option.
15
IT Assignment
Step 2: Click on the Table option and create a 4x5 table.
NAME ADDRESS COURSE NUMBER
ANIL KRISHNA BCOM XXX*999
NAGAR
BANTI JOR BHAG BBA 546*XXX
16
IT Assignment
RIYA SOUTH EX BCOM 679*XXX
NANDITA DWARKA BBA XXX*958
Q9 Create a letter in MS Word and use the Mail Merge feature to add recipients.
Sol.
17
IT Assignment
18
IT Assignment
19
IT Assignment
20
IT Assignment
21
IT Assignment
Steps:-
1. Under the Mailing Tab select StartMail Merge.
2. Click on the Step By Step Mail Merge wizard.
3. Click on Letters and then on next: starting documents.
4. Then select the type of starting document from the set provided.
5. Write the letter and then select TheRecipients.
6. Type the names and addresses of recipients as per your need.
7. Save the created list on the desktop.
8. Insert the information by clicking on Insert Merge Field under Write & Insert field.
Q16 Write a short note on the main features of MS Word.
Sol. The main features of MS Word are:
1. Home - Under this tab, there are the basic features like:
a. Font
Font Size
Font Styling: Includes features like Bold, Italics, Underline, Strikethrough, subscript,
superscript
Text Effects and Typography
Text Highlight
Font Colour
Clear all Formatting
Change Case
b. Clipboard
Paste
Cut
Copy
22
IT Assignment
Format Painter
c. Paragraph
Bullets
Numbering
Multi-level list
Decrease Indent/ Increase Indent
Left Align, Centre Align, Right Align, Justified
Line and Paragraph
Shading
Borders
Sort
Show/Hide paragraphs marks and other formatting symbols
d. Styles
2. Insert– This tab includes:
a. Pages
Cover Page
Blank Page
Page Break
b. Table
c. Illustrations
Pictures
Shapes
Icons
3D Models
SmartArt
Chart
Screenshot
d. Reuse Files
e. Media
Online Videos
f. Add Ins
Browse Add ins
Insert an Add in
Wikipedia
g. Links
h. Comments
i. Header & Footer
o Header
o Footer
o Page Number
j. Text
Text Box
Insert Word Art
Add a Drop Cap
Insert a Signature Line
Insert Date and Time
Object – Insert an embedded object, such as another word document or an
Excel Chart
k. Symbols
23
IT Assignment
Equation
Symbol
3. Design– This tab contains:
a. Themes
Paragraph Spacing
Effects, Colours and Font
b. Page Background
Watermark
Page Colour
Page Borders
4. Layout –
a. Page Setup
Margins
Orientation
Size
Columns
Breaks
Line Numbers
Hyphenation
b. Paragraph
Indent – Left, Right
Spacing – Before, After
c. Arrange
Position
Wrap Text
Bring Forward
Send Backward
Selection Pane
Align
Group
Rotate
5. References –
a. Table of Contents – To provide an overview of the document. Under this tab are:
Add Text
Update Table
b. Footnotes – Add a note at the bottom of the page to give more information about the
document. This includes:
Inserts Footnote
Insert Endnote
Next Footnote
Show Notes
c. Citations & Bibliography – Create a source of information by citing a book, article or
any other material that comes along. This tab includes:
Insert Citation
Manage Sources
Style
Bibliography
d. Captions – Label any picture in the document. It can later be used as a cross reference
anywhere inside the document.
24
IT Assignment
Insert Caption
Insert Table of Figures
Update Table
Cross-reference
e. Index – Make an index listing key words and the page numbers they appear on
Mark Entry
Insert Index
Update Index
f. Table of Authorities – Add a list of cases and statuses and other authorities cited in
the document.
Mark Citation
Insert Table of Authorities
g. Insights
Acronyms – Displays definitions found for acronyms in the documents
6. Mailings –
a. Create
o Envelopes
o Labels
b. Start Mail Merge – Create one document and send it to multiple people with different
labels
o Start Mail Merge
o Select Recipients
o Edit Recipients
c. Write & Insert Fields – Add a field from your recipient list to the document, such as
Last Name, Phone Number or Company Name. When you finish mail merge word
will replace these fields with the actual information entered in the recipients list. This
tab includes:
o Highlight Merge Fields
o Address Block
o Greeting Line
o Insert Merge Field
o Rules
o Match Field
o Update Labels
d. Preview Results – View the merged data and see how the final document will look
like. This option includes:
o Find Recipient
o Check for Errors
e. Finish
7. Review –
a. Proofing – Checking the document for errors and mistakes. This option includes:
Editor
Thesaurus
Word Count
b. Speech – Word can read the document out for you.
c. Accessibility – Control who can access the document.
d. Language – Translate, change the language of the document as per your
requirements.
e. Comments –
25
IT Assignment
New Comment
Delete
Previous
Next
Show Comments
f. Tracking
Track Changes
Show Markup
Reviewing Pane
g. Changes – You can either accept or reject the changes, move to previous or next one.
h. Compare – For comparing two different documents and finding differences between
them.
i. Protect – For protecting the document and disable editing from inappropriate users.
j. Ink– To hide ink in the document.
Q17 Short Note on Main Features of Ms-Excel.
1. Add Header and Footer
MS Excel allows us to keep the header and footer in our spreadsheet document.
2. Find and Replace Command
MS Excel allows us to find the needed data (text and numbers) in the workbook and also replace the
existing data with a new one.
3. Password Protection
It allows the user to protect their workbooks by using a password from unauthorized access to their
information.
4. Data Filtering
Filtering is a quick and easy way to find and work with a subset of data in a range. A filtered range
displays only the rows that meet the criteria you specify for a column. MS Excel provides two
commands for filtering ranges:
• AutoFilter; which includes filter by selection, for simple criteria
• Advanced Filter; for more complex criteria
5. Data Sorting
Data sorting is the process of arranging data in some logical order. MS Excel allows us to sort data
either in ascending or descending order.
6. Built-in formulae
MS Excel has got many built-in formulae for sum, average, minimum, etc. We can use those formulae
as per our needs.
7. Create different charts (Pivot Table Report)
MS Excel allows us to create different charts such as bar graph, pie- charts, line graphs, etc. This
helps us to analyze and compare data very easily.
8. Automatically edits the result
MS Excel automatically edits the result if any changes are made in any of the cells.
9. Formula Auditing
Using formula auditing we can graphically display or trace the relationships between cells and
formulas with blue arrows. We can trace the precedents (the cells that provide data to a specific cell)
or the dependents (the cells that depend on the value in a specific cell).
26
IT Assignment
27
