SHREE SWAMI ATMANAND SARASWATI

INSTITUTE OF TECHNOLOGY
INTEGRATED M.SC IT DEPARTMENT
Laboratory Plan
Subject Name & Code: Introduction to PC Package & Operating System (1310304)
Class: IMSC IT 1st Year (1st Semester)

Sr. List of Experiment PAGE DATE SIGN

No. NO
1. To study about MS Office and working with MS word
Type the paragraph below as it is using “Calibri font”, font size 12.
MS WORD
Microsoft Word is a word processor developed by Microsoft. It was first released in 1983 under
the name Multi-Tool Word for Xenix systems. MS Word is a popular word-processing program
used primarily for creating documents such as letters, brochures, learning activities, tests, quizzes
and students’ homework assignments. There are many simple but useful features available in
Microsoft Word to make it easier for study and work. That’s why so many people would prefer
to convert the read-only PDF to editable Word and edit PDF in Word.
1) Change the font type to “Lucida Calligraphy” and size to 14.
2) Alignment to your paragraph to right margin.
3) Save this file as ms-word.doc in “my document” folder using save as option.
4) Edit some part of your document and save again using save option.
5) Close the file.
6) Open this file again using open option from office button.
7) View the file you have created using print preview option.
8) Take a print out of this document through print option.
2. 1) Create a new file using new option.
2) Select some part of your document of PRACTICAL -2 and copy it to new file created in
bullet 1. Use shortcut keys for copy and paste.
3) Highlight “Microsoft Word” is a word processor developed by Microsoft”.
4) Search for word “documents” using find option.
5) Replace the word “Microsoft” with “MS”.
6) Select your document by using select all option and change the font size 12 of your
document.
7) Underline the “Microsoft-word” using underline option.
8) Draw a line through the middle of the selected text Xenix systems using strikethrough
option.
9) Create small number below the text baseline of the word “Multi-Tool” using subscript
(ctrl+=)as shown below
Multi-Tool1
10) Create small number above the text baseline using superscript (ctrl +shift + +)as shown
below.
Multi-Tool2
11) View your document in portrait and landscape view using orientation in page layout
menu.
12) Change the color of the text using font color option.
3. 1) Create a bulleted list : MS Word, Power point, Excel, Access
2) Using the insert>break option insert a page break in your document.
3) Insert a table.
4) Draw the borders of the table using draw table option.
5) Select the last row of the table and deleted the entire row.
6) Insert some more columns to the right in the table.
7) Insert a picture in the file.
8) Place the picture into the center of the page.
9) Add a thick red border around the picture.
10) Crop the picture 0.5 inches from the left.
11) Insert caption to the picture.

4. 1) Insert a clip art of computer in the file using clipart option.

2) Create the following flow chart using drawing tools in MS-Word.
3) Draw Cycle using SmartArt option and add some text in the figure.
4) Insert date & time and symbol date option &symbol option.
5) Using WordArt, Write the following “THANK YOU”. Use any style you wish and give
it a font size of 20 points.
6) Insert header& footer using the header and footer option.
7) Draw a text box and insert the following text in the textbox.
8) “Computer is an electronic device that performs complex calculations easily.”
9) Insert excel worksheet using object option in insert menu.
10) Create a hyperlink & attach a file to the hyperlink.
11) Insert bookmark using bookmark option in insert menu.
12) Choose the paper size for the document using size option.
13) Using Practical-2 paragraph split the text in three column option.
5. 1) Type the following lines and give numbers to that lines using line numbers option.
Computer is a device.
Computer is a machine.
Computer is an electronic device
Computer is very useful.
2) Make the word “MS WORD” as the watermark of the document.
3) Change the border of the page using page border option.
4) Change the spacing between paragraphs by adding 1.5 space in Practical-2 paragraph.
5) Add the table of contents to the document.

1. Create table(font size 16,font style Times new roman)

2. Use marge wrap text,Border,color fill
3. Use sum,avg,max,min function
4. Conditional entry pass/fail for
5. Create a header that includes your name in the left section, and your ID number in the
right section.

6. Objectives:
 Introduction to MS Excel files, Workbooks, Worksheets, Columns and Rows.
 Formatting Worksheets.
 AutoFill, Numeric Formats, Previewing Worksheets.
 1. Create a new workbook as shown below and save the file
2. Enter the labels and values in the exact cells locations as desired.

3. Use Autofill to put the Employee Numbers into cells A6:A8.

4. Set the columns width and rows height appropriately.
5. Set labels alignment appropriately.
6. Use warp text and merge cells as desired.
7. Apply borders, gridlines and shading to the table as desired.
8. Format cells B2 to Short Date format.
9. Format cells E4:G8 to include Rs sign with two decimal places.
10. Calculate the Gross pay for employee; enter a formula in cell E4 to multiply Hourly
Rate by Hours Worked.
11. Calculate the Social Security Tax (S.S Tax), which is 6% of the Gross Pay, enter a
formula in cell F4 to multiply Gross Pay by 6%.
12. Calculate the Net Pay; enter a formula in cell G4 to subtract Social Security Tax from
Gross Pay.
13. Set the work sheet vertically and horizontally on the page.
14. Save your work.

7. Objectives:
Working with the IF statement.
1. For the given table find the following:

2. Tax (if ITEM PRICE is LESS than 100,TAX is 50, otherwise it should be 100)
3. TOTAL PRICE BEFORE TAX=NO.OF ITEMS*ITEM PRICE.
4. TOTAL PRICE AFTER TAX= TOTAL PRICE BEFORE TAX+TAX.
 5. RATE (IF TOTAL PRICE AFTER TAX>3500 then the rate is “HIGH”, otherwise
it is REASONABLE.
6. Find Count of Items, Min item PRICE and Max item PRICE.
8. Objectives:
 Working with Sum If and Count If statements.
 Inserting Charts.

1. Create the worksheet shown above.

2. Set the Text alignment, Columns width and high appropriately.
3. Use AutoFill to put the Series Numbers into cells A5:A7.
4. Format cells C3:G7, C8:E11, C13:E13 to include dollar sign with two decimal places.
5. Find the Average Sales and Maximum Sales for each City.
6. Find the Total Sales for each Month.
7. Calculate the Profit for each month , where profit= Total Sales – Cost.
8. Calculate the 10% Bonus, which is 10% of the Profit.
9. Find the Total Sales for each Month; only for sales greater than 30,000.
10. Find the No of Sales for each Month; only for sales greater than 30,000.
11. Create the following Charts:

9. Objectives:
 Working with Sum IF and Count IF statements.
 Inserting Charts.
 1. Open a new workbook and create the above worksheet.
2. Make sure that your worksheet looks like the picture (Alignment, shedding, Borders,
Wrap, text, Orientation…).
3. Find the entire customer IDs.
4. Format Colum E & F to Currency with dollar sign and two decimal places.
5. Find the Total Annual Purchases for each City.
6. Find the Average Annual Purchases for each Education.
7. Find the total number of customers from each gender.
8. Find the total annual salary for each gender in each city.
9. Create the following Chart:

10. Develop Stock management in Excel

In out balance
Color qty month Color qty month color qty

red 10 09-Jan red 3 03-Mar red ?

blue 10 08-Feb black 5 04-May blue ?

black 10 10-Feb blue 2 05-May black ?

red 5 15-Feb
black 5 25-Feb
 Text Functions
Problem:
Given the below worksheet Write appropriate text functions in excel to
calculate first name, last name and email id.

11. Problem:
Convert Lowercase, Uppercase, Proper
discover the LENGTH of a cell
Surnam LENGTH
Name e Address Upper Lower of Address
Alice Peter Oak, Florida, United States ALICE alice 27
Jerry Patel Florida Gulf Coast University JERRY jerry 29

Ferry Arora Annapolis, Maryland, United States FERRY ferry 34

SUMPRODUCT

In this example, we'll use SUMPRODUCT to return the total sales for a given item and size:
 We wish to find out the total sales for the West region. & The weighted average
SUMPRODUCT formula is:

12. Linux commands :- bc, cal, cat, cd, clear, cmp, cp, mv, date, find, ls, pwd, mkdir, more,
rm, rmdir, chgrp, chmod, chown, tty, wc, who, whois, grep, telnet, vi editor, Permissions
and Ownerships,