Basic_assignment.pdf

Microsoft Windows Class Assignments

Windows Class Assignment

Lecture No.1 L 1 - Assignment No.1 1. 2. 3. 4. 5. 6. 7. 8.

Create a folder ‘Class Assignments’ in D: drive Find all the files having extension .txt from C drive. Copy any 2 files, which you found having extension txt & paste it to Class Assignments folder. Create a folder L1 in Lab assignments folder and cut one file from Class Assignments into L1 Rename the copied file in L1 as file1.txt Create the shortcut to file1.txt in L1 on desktop Delete the all the files & folder in ‘Class Assignments’ Recover the deleted files and folder in Class assignments from recycle bin

L 1 - Assignment No.2 1.

Plug in the pen drive and check the size of the pen drive and how much space is occupied and how much is free. 2. create a folder backup in pen drive 3. Make the zip file for all files & folders in the D:/Class Assignments 4. Copy zipped files to backup folder in pen drive 5. Then safely remove the pen drive 6. Delete the folder Class assignments and also from recycle bin 7. Now again plug in pen drive 8. Create a folder restore in d: 9. Open the zip file from backup folder in pen drive and extract the contents in d:/restore folder 10. Now safely remove the pen drive

L 1 - Assignment No.3 1. 2. 3.

Right click on my computer on desktop and select properties. Now check CPU, RAM and OS details and close it Open my computer right click on D: go to properties, check the size of the c: drive and how much space is free Double click on time on the task bar check the date time is proper, change it if it is not proper and select time zone GMT +5.30.

Page 1 of 1

Microsoft Windows Lab Assignments

Windows Lab Assignment

Lecture No.1 L 1 - Assignment No.1 1. 2. 3. 4. 5. 6. 7. 8.

Create a folder ‘Lab Assignments’ in D: drive Find all the files having extension .bmp from C drive. Copy any 2 files, which you found having extension bmp & paste it to Lab Assignments folder. Create a folder L1 in Lab assignments folder and cut one file from lab assignments into L1 Rename the copied file in L1 as file1.bmp Create the shortcut to file1.bmp in L1 on desktop Delete the all the files & folder in lab assignments Recover the deleted files and folder in lab assignments from recyclebin

L 1 - Assignment No.2 1.

Plug in the pen drive and check the size of the pen drive and how much space is occupied and how much is free 2. Create a folder backup in pen drive and another folder in backup folder with name as today’s date e.g. 1-Jan-2009 3. Make the zip file for all files & folders in the D:/Lab Assignments 4. Copy zipped files to folder created in step 1 in backup folder in pen drive 5. Then safely remove the pen drive 6. Delete the folder Lab assignments and also from recycle bin 7. Now again plug in pen drive 8. Create a folder daily backup in d: 9. Open the zip file from folder created in step 1 in backup folder from pen drive and extract the contents in d:/daily backup folder 10. Now safely remove the pen drive

L 1 - Assignment No.3 1. 2. 3.

Right click on my computer on desktop and select properties. Now check CPU, RAM and OS details and close it Open my computer right click on C: go to properties, check the size of the c: drive and how much space is free Double click on time on the task bar check the date time is proper, change it if it is not proper and select time zone GMT +5.30.

Page 1 of 1

Microsoft Word Class Assignments

Microsoft Word Class Assignments

Lecture No. 1 L 1 - Assignment No.1 Objective: Open a new word file and write a paragraph and format it as show in the output below. View the document in different layouts i.e. Web, Print, Outline, Normal and save the document in d:/myassignments folder with name assign1 and save as a copy in the same location as webpage with name assign.html Command to be used: 1. Bold, Underline, Italics. 2. Normal, Print Layout, Web Layout, Outline. Output:

Document Design On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick Styles gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls ofer a choice of using the look from the current theme or using a format that you specify directly. To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template. Page 1 of 35

Microsoft Word Class Assignments

L 1 - Assignment No. 2 Objective: Open a new word file and write the text as given below, cut the first line of the paragraph and paste at the end of the paragraph and make 4 copies of the paragraph

On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Command to be used: 1. Copy 2. Cut 3. Paste Output:

You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. On the Insert Page 2 of 35

Microsoft Word Class Assignments

tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document.

Page 3 of 35

Microsoft Word Class Assignments

Lecture No.2 L 2 - Assignment No.1 Objective: Open new word file and find the word ‘of’ and replace it with ‘off’ and search the location of the word ‘and’ from the given passage. Save the files.

Therac-25 where between 1985 and 1987 six people (at least) suffered serious radiation overdoses because of software-related malfunctions of the Therac-25 radiation therapy machine. Three of them are thought to have died of the overdoses. An important root cause was a lack of quality assurance, which led to an over-complex, inadequately tested, under-documented system being developed, and subsequently to the failure to take adequate corrective action. Command to be used: 1. Find. 2. Replace. Output:

Therac-25 where between 1985 and 1987 six people (at least) suffered serious radiation overdoses because off sofftware-related malfunctions off the Therac25 radiation therapy machine. Three off them are thought to have died off the overdoses. An important root cause was a lack off quality assurance, which led to an over-complex, inadequately tested, under-documented system being developed, and subsequently to the failure to take adequate corrective action. L 2 - Assignment No. 2 Objective: Type the text as shown below and apply bullets and numbering as shown in output

What's new in Microsoft Office Word 2007 Page 4 of 35

Microsoft Word Class Assignments

Spend more time writing, less time formatting A new, results-oriented interface presents tools to you when you need them, in a clear and organized fashion: Save time and get more out of the powerful Word capabilities by selecting from galleries of predefined styles, table formats, list formats, graphical effects, and more. Word eliminates the guesswork when you apply formatting to your document. The galleries of formatting choices give you a live visual preview of the formatting in your document before you commit to making a change. Add preformatted elements with just a few clicks Office Word 2007 introduces building blocks for adding preformatted content to your documents: When you are working on a document from a particular template type, such as a report, you can select from a gallery of preformatted cover pages, pull quotes, and headers and footers to make your document look more polished. If you want to customize the preformatted content, or if your organization often uses the same piece of content, such as legal disclaimer text or customer contact information, you can create your own building blocks that you select from the gallery with a single click. Command to be used: 1. Bullets & Numbering Output:

What's new in Microsoft Office Word 2007 1. Spend more time writing, less time formatting a. A new, results-oriented interface presents tools to you when you need them, in a clear and organized fashion: Page 5 of 35

Microsoft Word Class Assignments

b. Save time and get more out of the powerful Word capabilities by selecting from galleries of predefined styles, table formats, list formats, graphical effects, and more. c. Word eliminates the guesswork when you apply formatting to your document. The galleries of formatting choices give you a live visual preview of the formatting in your document before you commit to making a change. 2. Add preformatted elements with just a few clicks a. Office Word 2007 introduces building blocks for adding preformatted content to your documents: b. When you are working on a document from a particular template type, such as a report, you can select from a gallery of preformatted cover pages, pull quotes, and headers and footers to make your document look more polished. c. If you want to customize the preformatted content, or if your organization often uses the same piece of content, such as legal disclaimer text or customer contact information, you can create your own building blocks that you select from the gallery with a single click.

What's new in Microsoft Office Word 2007 1. Spend more time writing, less time formatting  A new, results-oriented interface presents tools to you when you need them, in a clear and organized fashion:  Save time and get more out of the powerful Word capabilities by selecting from galleries of predefined styles, table formats, list formats, graphical effects, and more.  Word eliminates the guesswork when you apply formatting to your document. The galleries of formatting choices give you a live visual preview of the formatting in your document before you commit to making a change. 2. Add preformatted elements with just a few clicks Page 6 of 35

Microsoft Word Class Assignments

 Office Word 2007 introduces building blocks for adding preformatted content to your documents:  When you are working on a document from a particular template type, such as a report, you can select from a gallery of preformatted cover pages, pull quotes, and headers and footers to make your document look more polished.  If you want to customize the preformatted content, or if your organization often uses the same piece of content, such as legal disclaimer text or customer contact information, you can create your own building blocks that you select from the gallery with a single click.

What's new in Microsoft Office Word 2007  Spend more time writing, less time formatting  A new, results-oriented interface presents tools to you when you need them, in a clear and organized fashion:  Save time and get more out of the powerful Word capabilities by selecting from galleries of predefined styles, table formats, list formats, graphical effects, and more.  Word eliminates the guesswork when you apply formatting to your document. The galleries of formatting choices give you a live visual preview of the formatting in your document before you commit to making a change.  Add preformatted elements with just a few clicks Office Word 2007 introduces building blocks for adding preformatted content to your documents:  When you are working on a document from a particular template type, such as a report, you can select from a gallery of preformatted cover pages, pull quotes, and headers and footers to make your document look more polished.

Page 7 of 35

Microsoft Word Class Assignments

 If you want to customize the preformatted content, or if your organization often uses the same piece of content, such as legal disclaimer text or customer contact information, you can create your own building blocks that you select from the gallery with a single click. L 2 - Assignment No.3 Objective: Create a new document and type the text given below and modify the print setting using page setup option as follows.

1. Margins – Top - 1.5” Bottom-1.5” 2. Page Size – B4. 3. Orientation- Landscape

Right-1.5”

Left-1.5”.

View the document in print preview to check the print setting

Google's mission is to organize the world's information and make it universally accessible and useful. As a first step to fulfilling that mission, Google's founders Larry Page and Sergey Brin developed a new approach to online search that took root in a Stanford University dorm room and quickly spread to information seekers around the globe. Google is now widely recognized as the world's largest search engine -- an easy-to-use free service that usually returns relevant results in a fraction of a second. When you visit www.google.com or one of the dozens of other Google domains, you'll be able to find information in many different languages; check stock quotes, maps, and news headlines; lookup phonebook listings for every city in the United States; search billions Page 8 of 35

Microsoft Word Class Assignments

of images and peruse the world's largest archive of Usenet messages -- more than 1 billion posts dating back to 1981. Command to be used: 1.

Page Setup.

Output:

Page 9 of 35

Microsoft Word Class Assignments

L 2 - Assignment No. 4 Objective: Create a new document and type the below text and make 4 copies of it using copy paste option and give different alignment to each paragraph

On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Command to be used: 1. Paragraph. Alignment Output: Left

On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Center On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look.

Page 10 of 35

Microsoft Word Class Assignments

Right

On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Justified

On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look.

Page 11 of 35

Microsoft Word Class Assignments

Lecture No.3 L 3 - Assignment No. 1 Objective: Open a new file and use border and shading on the passage given below.

Our Training methodology: •

Application based Training.

•

Useful reference material.

•

OHP based training.

•

On-Line Class room Assignments.

•

Training by industry professionals.

•

Support/Consultancy after Training.

Command to be used: 1. Bullets. 2. Border and Shading Output:

Our Training methodology:  Application based Training.  Useful reference material.  OHP based training.  On-Line Class room Assignments.  Training by industry professionals.  Support/Consultancy after Training. Page 12 of 35

Microsoft Word Class Assignments

L 3 - Assignment No. 2 Objective: Open a new file and write a passage as given below which should start with large capital letter. Write the title with some effects.

Information and Technology Today, the industries depend on their information system for growth. The position of a company in front of its competitors is very necessary to understand. And we are also aware that computers are the only tool for solutions to information system the it industry has been creating wonders for companies in their growth. But, the right & efficient use of computer is a most for this. We are one of those companies offering it solutions. After successfully educating individuals at a professional level for 2 years, we have now ventured in the areas of corporate training, software development and consultancy. With our professional approach and a solutions to corporate and private companies. Our business thrust has always been computer education. Command to be used: 1. Drop Cap Effect. 2. Word Art. Output:

Oday, the industries depend on their information system for growth. The position of a company in front of its competitors is very necessary to understand. And we are also aware that computers are the only tool for solutions to information system the it industry has been creating wonders for companies in their growth. But, the right & efficient

T

Page 13 of 35

Microsoft Word Class Assignments

use of computer is a most for this. We are one of those companies offering it solutions. After successfully educating individuals at a professional level for 2 years, we have now ventured in the areas of corporate training, software development and consultancy. With our professional approach and a solutions to corporate and private companies. Our business thrust has always been computer education L 3 - Assignment No.3 Objective: Type the text given below and create two columns and do the following rd 1. Using column break shift the text from 3 Paragraph onwards to next column. rd 2. Using page break shift the text from 3 Paragraph onwards to next page.

Khoj Chem Pvt. Ltd. 12/9/96, MIDC, Tarapur-Boisar, Thane-Dist, Maharashtra-401506 St. Angelo’s Computer Education 6th Floor Jyoti Plaza, SV Road Kandivali(W) M/s. Chem-Flow Engineers C-1. Plot No.617 Sector-VI, Charkop, Kandivli (w) Bombay-67 Telephone number 8066770 Indo German computer institute Gora Gandhi colony, Chandawarkar road, Borivali (w) Page 14 of 35

Microsoft Word Class Assignments

Command to be used: 1. Column Break. Output:

Khoj Chem Pvt. Ltd. 12/9/96, MIDC, Tarapur-Boisar, Thane-Dist, Maharashtra-401506

M/s. Chem-Flow Engineers C-1. Plot No.617 Sector-VI, Charkop, Kandivli (w) Bombay-67 : 8066770

St. Angelo’s Computer Education 6th Floor Jyoti Plaza, SV Road Kandivali(W)

Indo German computer institute Gora Gandhi colony, Chandawarkar road, Borivali (w)

2. Page Break.

Page 15 of 35

Microsoft Word Class Assignments

Lecture No.4 L 4 - Assignment No.1 Objective: Open a new word files and uses different styles in the given passage.

Document Design To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template. Command to be used: 1. Heading2. 2. No Spacing. Output:

Document Design To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template.

Page 16 of 35

Microsoft Word Class Assignments

L 4 - Assignment No.2 Objective: Create document to make resume using Template. Command to be used: 1. Templates. 2. Resumes and CV Output

Contact Tel : 000-0000-0000 e-mail : [email protected] m

Your Name

Profile Objective

Education Qualification

I am seeking a position within the Information Technology department, possibly with an international perspective.

Year Of Passing

Percentage University

Graduation 12th 10th

Page 17 of 35

Microsoft Word Class Assignments

Key Skills Proficient or familiar with a vast array of programming languages, concepts MS Office, C ,C++,Java,.NET Activities and Interests Reading Books Listening To Music

Personal INFORMATION Father’s Name : Date of Birth : Languages Known : Permanent Address : Nationality :

Page 18 of 35

Microsoft Word Class Assignments

L 4 - Assignment No.3 Objective: Type the text given below and insert hyper link on word computer to a file with name computer.docx and on word yahoo.com to website www.yahoo.com

Today, the industries depend on their information system for growth. The growth of IT industry as given in the chart. The position of a company in front of its competitors is very necessary to understand. And we are also aware that computers are the only tool for solutions to information system the it industry has been creating wonders for companies in their growth. But, the right & efficient use of computer is a most for this. We are one of those companies offering it solutions. The computer system is very important in today’s world. According to yahoo.com estimation up to date 2 million. Command to be used: 1. Hyper Link. Output:

Page 19 of 35

Microsoft Word Class Assignments

Lecture No. 5 L 5 - Assignment No.1 Objective: Open a new file and insert chart, clip art, date and time in the file.

Today, the industries depend on their information system for growth. The growth of IT industry as given in the chart. The position of a company in front of its competitors is very necessary to understand. And we are also aware that computers are the only tool for solutions to information system the it industry has been creating wonders for companies in their growth. But, the right & efficient use of computer is a most for this. We are one of those companies offering it solutions. The computer system is very important in today’s world. According to estimation up to date 2 million. Command to be used: 1. Insert chart, 2. Clip Board 3. Data and Time. Output:

100 80 60

East

40

West

20

North

0 1st Qtr

Page 20 of 35

2nd Qtr

3rd Qtr

4th Qtr

Microsoft Word Class Assignments

Today, the industries depend on their information system for growth. The growth of IT industry as given in the chart. The position of a company in front of its competitors is very necessary to understand. And we are also aware that computers are the only tool for solutions to information system the it industry has been creating wonders for companies in their growth. But, the right & efficient use of computer is a most for this. We are one of those companies offering it solutions. The computer system is very important in today’s world. According to estimation up to date 2 million computers are sold. We are one of those companies offering it solutions. The computer system is very important in today’s world. According to estimation up to date 4/2/2009 2 million computers are sold. L 5 - Assignment No.2 Objective: Create a document and type the text given below and save it, now turn on track changes option and make modifications as shown in output, then accept all inserted text and keep deleted text.

Today, the industries depend on their information system for growth. The growth of IT industry as given in the chart. The position of a company in front of its competitors is very necessary to understand. And we are also aware that computers are the only tool for solutions to information system the it industry has been creating wonders for companies in their growth. But, the right & efficient use of computer is a most for this. We are one of those companies offering it solutions. The computer system is very important in today’s world. According to yahoo.com estimation up to date 2 million. Command to be used: 1. Track changes.

Page 21 of 35

Microsoft Word Class Assignments

Output:

L 5 - Assignment No.3 Objective: Open a new document and write the text given below and save. Now make document protected by adding password to open and modify.

Over the past year, Tata has been building hype for a car that would cost a mere 100,000 rupees (roughly $2,500) and bring automotive transportation to the mainstream Indian population. It has been nicknamed the “People’s Car.” Over the course of the New Delhi Auto Expo, which this week, anticipation had grown. With the theme from “2001: A Space Odyssey” playing, Ratan Tata, chairman of Tata Motors drove the small white bubble car on Tata’s show stage, where it joined two otherwise. “They are not concept cars, they are not prototypes,” Mr. Tata announced when he got out of the car. “They are the production cars that will roll out of the Singur plant later this year.”

Page 22 of 35

Microsoft Word Class Assignments

Command to be used: 1. Protect document Output:

Page 23 of 35

Microsoft Word Class Assignments

Lecture No.6 L 6 - Assignment No.1 Objective: Type the text given below and correct the spellings and grammer, make sure that you remove all red and green underlines

These document iis specialy created to chesk spelling cheiking facility of MS Word. The limitation of spell check facility is that is does not report errrorr, if the spelling is correctt , butt sentence is rong. For example , the following statements are correct for spell check. A bait was kept on fishing line A fish was attracted to the bat. A bait files at night. Command to be used: 1. Spelling & Grammar. Output:

This document is specially created to check spelling checking facility of MS Word. The limitation of spell check facility is that is does not report error, if the spelling is correct, but sentence is wrong. For example, the following statements are correct for spell check. Bait was kept on fishing line A fish was attracted to the bat. A bait files at night Page 24 of 35

Microsoft Word Class Assignments

L 6 - Assignment No.2 Objective: Open a new file.Write the passage as given below and made the entry of St. Angelo’s computers Ltd. As SACL.

C O M PA N Y P RO F I LE St. Angelo's Computers Ltd. is one of the leading IT group in India. St. Angelo's was established in the year 1993 & today it has grown up to be one of the largest IT organizations in Mumbai. Having started its operations with a single computer operation, it is now spanning the length and breadth of Mumbai and has currently more than 40 branches across Mumbai and Pune. The company has diversified operations into Computer Education, IT & Management Training for Corporate, Software Development, E-Learning Solutions and Networking Solutions. The company has an expertise in areas like Project Management, Consulting, Client Services, Business Development and Marketing. St. Angelo's Computer Ltd. has strategic tie-ups with various business establishments, schools and colleges for IT training & services as well as promotional activities. This has proved to be a major cause of spreading IT literacy in Mumbai Command to be used:

1. Auto Correct.

Page 25 of 35

Microsoft Word Class Assignments

Output:

L 6 - Assignment No.3 Objective: Open a new file.Write the passage as given below and header display text “Word Assignment” and in the footer display page number and align it right for odd pages and right aligned for even pages

While the company has done exactly that in more than one hundred languages, Google’s quest continues as it seeks to add millions of library books, television broadcasts, and more to its searchable database. Readers will learn about the amazing business acumen and computer wizardry that started the company on its astonishing course; the secret network of computers delivering lightning-fast search results; the unorthodox approach that has enabled it to challenge Microsoft’s dominance and shake up Wall Street. Even as it rides high, Google wrestles with difficult choices that will enable it to continue expanding while sustaining the guiding vision of its founders’ mantra. Google's mission is to organize the world's information and make it universally accessible and useful.

Page 26 of 35

Microsoft Word Class Assignments

As a first step to fulfilling that mission, Google's founders Larry Page and Sergey Brin developed a new approach to online search that took root in a Stanford University dorm room and quickly spread to information seekers around the globe. Google is now widely recognized as the world's largest search engine -- an easy-to-use free service that usually returns relevant results in a fraction of a second. When you visit www.google.com or one of the dozens of other Google domains, you'll be able to find information in many different languages; check stock quotes, maps, and news headlines; lookup phonebook. Command to be used: 1. Insert Header, 2. Footer 3. Page Number. Output: 1.

Page 27 of 35

Microsoft Word Class Assignments

Page 28 of 35

Microsoft Word Class Assignments

Lecture No.7 L 7 - Assignment No.1 Objective: Create a table as shown below. Insert a new column on right side and a new row at the end of the table. And format it using auto-format option, also calculate total of products and city as shown in output City Delhi Calcutta Chennai

Product A 1100 1400 1500

Product B 4300 3000 3500

Product C 3000 2800 3200

Command to be used: 1. Tables. Output: City Delhi Calcutta Chennai Bangalore Total

Product A 1100 1400 1500 1300 5300

Product B 4300 3000 3500 3700 14500

Product C 3000 2800 3200 3300 12300

Product D 3500 3100 3300 3500 13400

Total 11900 10300 11500 11800 45500

L 7 - Assignment No.2 Objective: Create a table as shown below. Delete the row, column and cells in the table. City Delhi Calcutta Chennai Bangalore

Product A 1100 1400 1500 1300

Product B 4300 3000 3500 3700 Page 29 of 35

Product C 3000 2800 3200 3300

Product D 3500 3100 3300 3500

Microsoft Word Class Assignments

Command to be used: 1. Delete the third row. 2. Delete the second column. 3. Delete the last cell of the third row. Output: City Delhi Chennai Bangalore

Product B 4300 3500 3700

Product C 3000 3200 3300

Product D 3500 3500

L 7 - Assignment No.3 Objective: Create a table as shown below. Find out total of product and city. Also convert that table into text separated by tabs. City Bombay Delhi Calcutta Chennai Total

Product A 1200 1100 1400 1500 (Formula)

Product B 3400 4300 3000 3500 (Formula)

Product C 3200 3000 2800 3200 (Formula)

Total (Formula) (Formula) (Formula) (Formula)

Command to be used: 1. Enter the formula of sum. 2. Convert table into text. Output:

1. City Bombay Delhi Calcutta Chennai Total

Product A 1200 1100 1400 1500 5200

Product B 3400 4300 3000 3500 14200 Page 30 of 35

Product C 3200 3000 2800 3200 12200

Total 7800 8400 7200 8200

Microsoft Word Class Assignments

2. City Bombay Delhi Calcutta Chennai Total

Product A 1200 1100 1400 1500 5200

Product B 3400 4300 3000 3500 14200

Page 31 of 35

Product C 3200 3000 2800 3200 12200

Total 7800 8400 7200 8200

Microsoft Word Class Assignments

Lecture No.8 L 8 - Assignment No.1 Objective: Using mail merge option in the MS word, create a letter and a database with fields (Name, Designation, Address1, Address2) mail to multiple users and merge it. Name Rajesk Kamar

Designation CEO

Pawan Thakur

Head Operation

Hari Prasad

Manager

Address1 Jai nagar, malad, Mumbai Sai naagar, kandliwali, Mumbai Goregaon(E), Mumbai

Address2 400061 400062 400063

Type a letter as follows: To, < Insert field: Name > < Insert field: Designation > < Insert field: Address1> < Insert field: Zipcode> Date: (Type date here) Kind attention : < insert field name > We have pleasure to announce that you have been one of the first five lucky winners in the draw of the lucky students of Grafi - Tech. A cheque of Rs < insert field: Amount> is attached along with this letters, which please acknowledge. Thanking you, Page 32 of 35

Microsoft Word Class Assignments

Yours Sincerely, For St.Angelo’s computers Ltd. (Type your name) Contest Manager Encl. A cheque of RS < insert field: Amount > L 8 - Assignment No.2 Objective: Using mail merge option in the MS word, write a letter to your friend for birthday invitation.

Type a letter as follows: Your Name: (name) Address: (your address) Date :( type date) Hello, You are cordially invited in my birthday party on (type date) at my house. I hope you will come with your family.

With Regards (You’re Name)

Page 33 of 35

Microsoft Word Class Assignments

L 8 - Assignment No.3 Objective: Create a macro to find text Mumbai and make it bold and highlighted, assign a shortcut key to run it.

C O M PA N Y P RO F I LE St. Angelo's Computers Ltd. is one of the leading IT group in India. St. Angelo's was established in the year 1993 & today it has grown up to be one of the largest IT organizations in Mumbai. Having started its operations with a single computer operation, it is now spanning the length and breadth of Mumbai and has currently more than 40 branches across Mumbai and Pune. The company has diversified operations into Computer Education, IT & Management Training for Corporate, Software Development, E-Learning Solutions and Networking Solutions. The company has an expertise in areas like Project Management, Consulting, Client Services, Business Development and Marketing. St. Angelo's Computers Ltd. has strategic tie-ups with various business establishments, schools and colleges for IT training & services as well as promotional activities. This has proved to be a major cause of spreading IT literacy in Mumbai Command to be used: 1. Macros.

C O M PA N Y P RO F I LE St. Angelo's Computers Ltd. is one of the leading IT group in India. St. Angelo's was established in the year 1993 & today it has grown up to be one of the largest IT organizations in Mumbai. Having started its operations with a single computer operation, it is now spanning the length and breadth of Mumbai and has Page 34 of 35

Microsoft Word Class Assignments

currently more than 40 branches across Mumbai and Pune. The company has diversified operations into Computer Education, IT & Management Training for Corporate, Software Development, E-Learning Solutions and Networking Solutions. The company has an expertise in areas like Project Management, Consulting, Client Services, Business Development and Marketing. St. Angelo's Computers Ltd. has strategic tie-ups with various business establishments, schools and colleges for IT training & services as well as promotional activities. This has proved to be a major cause of spreading IT literacy in Mumbai

Page 35 of 35

Microsoft Word Lab Assignments

Microsoft Word Lab Assignments

Lecture No.1 L 1 - Assignment No.1 Objective: Open a new word file and write a paragraph and format it as show in the output below. View the document in different layouts i.e. Web, Print, Outline, Normal and save the document in d:/myassignments folder with name labassign1 and save as a copy in the same location as webpage with name labassign.html Command to be used: 1. Bold, Underline, Italics. 2. Normal, Print Layout, Web Layout, Outline. Output:

Banks are critical to our economy. The primary function of banks is to put their account holders' money to use by lending it out to others who can then use it to buy homes, businesses, send kids to college. When you deposit your money in the bank, your money goes into a big pool of money along with everyone else's, and your account is credited with the amount of your deposit. When you write checks or make withdrawals, that amount is deducted from your account balance. Interest you earn on your balance is also added to your account. L 1 - Assignment No. 2 Objective: Open a new word file and write the text as given below, 1. Cut the first point and paste at the end of the last point. 2. Copy the second point and paste it after third point.

Page 1 of 35

Microsoft Word Lab Assignments

1. The 2007 Microsoft Office system spelling checker includes the postreform French dictionary. In Microsoft Office 2003, this was an add-in that had to be separately installed. 2. An exclusion dictionary is automatically created for a language the first time that language is used. Exclusion dictionaries let you force the spelling checker to flag words that you want to avoid using. They are handy for avoiding words that are obscene or that don't match your style guide. 3. The spelling checker can find and flag some contextual spelling errors. Have you ever typed a mistake similar to the following? I will see you their. In Office Word 2007, you can enable the Use contextual spelling option to get help with finding and fixing this type of mistake. This option is available when checking the spelling of documents in English, German, or Spanish. 4. You can disable spelling and grammar checking for a document or for all documents that you create. Command to be used: 1. 2. 3.

Cut Copy Paste

Output:

2

An exclusion dictionary is automatically created for a language the first time that language is used. Exclusion dictionaries let you force the spelling checker to flag words that you want to avoid using. They are Page 2 of 35

Microsoft Word Lab Assignments

handy for avoiding words that are obscene or that don't match your style guide. 3 The spelling checker can find and flag some contextual spelling errors. Have you ever typed a mistake similar to the following? I will see you their. In Office Word 2007, you can enable the Use contextual spelling option to get help with finding and fixing this type of mistake. This option is available when checking the spelling of documents in English, German, or Spanish. 2 An exclusion dictionary is automatically created for a language the first time that language is used. Exclusion dictionaries let you force the spelling checker to flag words that you want to avoid using. They are handy for avoiding words that are obscene or that don't match your style guide. 4 You can disable spelling and grammar checking for a document or for all documents that you create. 1 The 2007 Microsoft Office system spelling checker includes the postreform French dictionary. In Microsoft Office 2003, this was an add-in that had to be separately installed.

Page 3 of 35

Microsoft Word Lab Assignments

Lecture No.2 L 2 - Assignment No.1 Objective: Create a new document and type the text given below and modify the print setting using page setup option as follows.

1. Margins – Top - 1” Bottom-1” 2. Page Size – B5. 3. Orientation- Portrait.

Right-0.75”

Left-0.75”.

View the document in print preview to check the print setting.

Banking is all about trust. We trust that the bank will have our money for us when we go to get it. We trust that it will honor the checks we write to pay our bills. The thing that's hard to grasp is the fact that while people are putting money into the bank every day, the bank is lending that same money and more to other people every day. Banks consistently extend more credit than they have cash. That's a little scary; but if you go to the bank and demand your money, you'll get it. However, if everyone goes to the bank at the same time and demands their money (a run on the bank), there might be problem. Command to be used:

1. Page Setup.

Page 4 of 35

Microsoft Word Lab Assignments

Output:

L 2 - Assignment No. 2 Objective: Create a new document and type the below text and give different alignment to each paragraph as shown below.

Sunit K.V.N. Mumbai May 2, 2009 Dear Sunit, I am writing to inform you that Cynthia will be absent from school from December 12 through 14. She will be attending the funeral of her grandmother with the rest of our family.Our aim is that this absence from class not affect Cynthia’s academic performance. Please let me know if she will need to complete Page 5 of 35

Microsoft Word Lab Assignments

any assignments before she leaves. My wife and I will make every effort to ensure that Cynthia completes her schoolwork while she’s away.Please e-mail me at [email protected] with Cynthia’s assignments for the days that she will be absent. Thank you for your cooperation and understanding. Sincerely XYZ Command to be used: 1.

Paragraph

Output:

Sunit K.V.N. Mumbai May 2, 2009 Dear Sunit, I am writing to inform you that Cynthia will be absent from school from December 12 through 14. She will be attending the funeral of her grandmother with the rest of our family. Our aim is that this absence from class not affect Cynthia’s academic performance. Please let me know if she will need to complete any assignments before she leaves. My wife and I will make every effort to ensure that Cynthia completes her schoolwork while she’s away. Please e-mail me at [email protected] with Cynthia’s assignments for the days that she will be absent. Thank you for your cooperation and understanding. Sincerely XYZ

Page 6 of 35

Microsoft Word Lab Assignments

L 2 - Assignment No.3 Objective: Open new word file and find the word ‘Internet’ and replace it with ‘INTERNET’ and search the location of the word ‘and’ from the given passage. Save the files.

The Internet is one of the 20th century's greatest communications developments. It allows people around the world to send e-mail to one another in a matter of seconds, and it lets you read, among other things, the articles on HowStuffWorks.com. We're all used to seeing the various parts of the Internet that come into our homes and offices -- the Web pages, e-mail messages and downloaded files that make the Internet a dynamic and valuable medium. But none of these parts would ever make it to your computer without a piece of the Internet that you've probably never seen. In fact, most people have never stood "face to machine" with the technology most responsible for allowing the Internet to exist at all the router. Command to be used: 1. Find. 2. Replace. Output:

The INTERNET is one of the 20th century's greatest communications developments. It allows people around the world to send e-mail to one another in a matter of seconds, and it lets you read, among other things, the articles on HowStuffWorks.com. We're all used to seeing the various parts of the INTERNET that come into our homes and offices -- the Web pages, e-mail messages and downloaded files that make the INTERNET a dynamic and valuable medium. But none of these parts would ever make it to your computer without a piece of the INTERNET that you've probably never seen. In fact, most people have never stood "face to machine" with the technology most responsible for allowing the INTERNET to exist at all the router. Page 7 of 35

Microsoft Word Lab Assignments

L 2 - Assignment No. 4 Objective: Open a new file and type the text given below. Courses Programming C C++ SAD PLT Hardware and Networking MCSE CCNA Command to be used: 1. Bullets & Numbering. Output: Courses 1. Programming i. ii. iii. iv.

C C++ SAD PLT

2. Hardware and Networking i. MCSE

ii. CCNA

Page 8 of 35

Microsoft Word Lab Assignments

Courses  Programming  C  C++  SAD  PLT  Hardware and Networking  

MCSE CCNA

Courses ∗ Programming

∗

(a) C (b) C++ (c) SAD (d) PLT Hardware and Networking (a) MCSE (b) CCNA

Page 9 of 35

Microsoft Word Lab Assignments

Lecture No.3 L 3 - Assignment No. 1 Objective: Open a new file and use border and shading on the passage given below.

Advantage of Internet ∗ ∗ ∗ ∗

∗

Communication Information Entertainment Services E-Commerce

Command to be used:

1. Bullets and numbering. 2. Border and Shading. Output:

Advantage of Internet A. Communication B. Information C. Entertainment D. Services E. E-Commerce

Page 10 of 35

Microsoft Word Lab Assignments

L 3 - Assignment No.2 Objective: Type the text given below and create two columns and do the following rd 1. Using column break shift the text from 3 Paragraph onwards to next column. rd 2. Using page break shift the text from 3 Paragraph onwards to next page. 2nd flr ,Opp Andheri Post Office, S.V. Road Andheri(W). D-101, Galaxy Heights Link Road Goregaon (W). Silverline Co-Op-Soc, Opp Bhayander Station Bhayander (E). Shop No 1 & 2, Shreej Shopping Arcadce, M.G.Road Borivali (E). Command to be used: 1. Column Break. Output: 2nd flr ,Opp Andheri Post Office, S.V. Road Andheri(W).

Silverline Co-Op-Soc, Opp Bhayander Station Bhayander(E).

D-101, Galaxy Heights Link Road Goregaon (W).

Shop No 1 & 2, Shreej Shopping Arcadce,M.G.Road Borivali(E).

Page 11 of 35

Microsoft Word Lab Assignments

1. Page Break. Output:

L 3 - Assignment No. 3 Objective: Open a new file and write a passage as given below which should start with large capital letter. Write the title with some effects.

Telecommunication When you make a telephone call to someone on the other side of the country, the telephone system establishes a stable circuit between your telephone and the telephone you're calling. The circuit might involve a half dozen or more steps through copper cables, switches, fiber optics, microwaves and satellites, but those steps are established and remain constant for the duration of the call. This circuit approach means that the quality of the line between you and the person you're calling is consistent throughout the call, but a problem with any portion of the circuit -- maybe a tree falls across one of the lines used, or there's a power problem with a switch -- brings your call to an early and abrupt end. When you send an e-mail message with an attachment to the other side of the country, a very different process is used.

Page 12 of 35

Microsoft Word Lab Assignments

Command to be used: 1. Drop Cap Effect. 2. Word Art. Output:

W

hen you make a telephone call to someone on the other side of the

country, the telephone system establishes a stable circuit between your telephone and the telephone you're calling. The circuit might involve a half dozen or more steps through copper cables, switches, fiber optics, microwaves and satellites, but those steps are established and remain constant for the duration of the call. This circuit approach means that the quality of the line between you and the person you're calling is consistent throughout the call, but a problem with any portion of the circuit -- maybe a tree falls across one of the lines used, or there's a power problem with a switch -- brings your call to an early and abrupt end. When you send an e-mail message with an attachment to the other side of the country, a very different process is used.

Page 13 of 35

Microsoft Word Lab Assignments

Lecture No.4 L 4 - Assignment No.1 Objective: Open a new word files and uses different styles in the given passage.

Telecommunication When you make a telephone call to someone on the other side of the country, the telephone system establishes a stable circuit between your telephone and the telephone you're calling. The circuit might involve a half dozen or more steps through copper cables, switches, fiber optics, microwaves and satellites, but those steps are established and remain constant for the duration of the call. This circuit approach means that the quality of the line between you and the person you're calling is consistent throughout the call, but a problem with any portion of the circuit -- maybe a tree falls across one of the lines used, or there's a power problem with a switch -- brings your call to an early and abrupt end. When you send an e-mail message with an attachment to the other side of the country, a very different process is used. Command to be used: 1. Title. 2. Quote. Output:

Telecommunication When you make a telephone call to someone on the other side of the country, the telephone system establishes a stable circuit between your telephone and the telephone you're calling. The circuit might involve a half dozen or more steps through copper cables, switches, fiber optics, microwaves and satellites, but those steps are established and remain constant for the duration of the call. This circuit Page 14 of 35

Microsoft Word Lab Assignments

approach means that the quality of the line between you and the person you're calling is consistent throughout the call, but a problem with any portion of the circuit -- maybe a tree falls across one of the lines used, or there's a power problem with a switch -- brings your call to an early and abrupt end. When you send an e-mail message with an attachment to the other side of the country, a very different process is used. L 4 - Assignment No.2 Objective: Open a new word file. Create your memo using Template.

ABC Ltd. To:

[Click here and type name]

From:

[Click here and type name]

CC:

[Click here and type name]

Date:

7/6/2009

Re:

[Click here and type subject]

Welcome to program, a comprehensive career program for undergraduate & graduate (above 12th) that guarantees you not only an IT job but also a rewarding career. This program is available for students from any stream of Arts, Commerce or Science and entitles them for Dual Qualification along with their academic stream thus opening up the doors of global opportunities.

Page 15 of 35

Microsoft Word Lab Assignments

Command to be used: 1. Template. 2. Memos.

Output:

ABC Ltd. To:

[email protected]

From:

[email protected]

CC:

[email protected]

Date:

7/6/2009

Re:

Course Profile

Welcome to program, a comprehensive career program for undergraduate & graduate (above 12th) that guarantees you not only an IT job but also a rewarding career. This program is available for students from any stream of Arts, Commerce or Science and entitles them for Dual Qualification along with their academic stream thus opening up the doors of global opportunities. L 4 - Assignment No.3 Objective: Type the text given below and insert hyper link on word computer to a file with name Google.docx and on word Google to website www.google.co.in

Here is the story behind one of the most remarkable Internet successes of our time. Based on scrupulous research and extraordinary access to Google, the Page 16 of 35

Microsoft Word Lab Assignments

book takes you inside the creation and growth of a company whose name is a favorite brand and a standard verb recognized around the world. Its stock is worth more than General Motors’ and Ford’s combined, its staff eats for free in a dining room run by a former chef for the Grateful Dead, and its employees traverse the firm’s colorful Silicon Valley campus on scooters and inline skates. The Google Story is the definitive account of the populist media company powered by the world’s most advanced technology that in a few short years has revolutionized access to information about everything for everybody everywhere. In 1998, Moscow-born Sergey Brin and Midwest-born Larry Page dropped out of graduate school at Stanford University to, in their own words, “change the world” through a search engine that would organize every bit of information on the Web for free. Command to be used: 1. Hyper Link. Output:

Page 17 of 35

Microsoft Word Lab Assignments

Lecture No.5 L 5 - Assignment No.1 Objective: Open a new file and insert the charts, clip art in the file.

Telecommunication When you make a telephone call to someone on the other side of the country, the telephone system establishes a stable circuit between your telephone and the telephone you're calling. The circuit might involve a half dozen or more steps through copper cables, switches, fiber optics, microwaves and satellites, but those steps are established and remain constant for the duration of the call. This circuit approach means that the quality of the line between you and the person you're calling is consistent throughout the call, but a problem with any portion of the circuit -- maybe a tree falls across one of the lines used, or there's a power problem with a switch -- brings your call to an early and abrupt end. When you send an e-mail message with an attachment to the other side of the country, a very different process is used. Your call to an early and abrupt end. When you send an e-mail message with an attachment to the other side of the country, a very different process is used. Command to be used: 1. ClipArt, Chart. Output:

Telecommunication When you make a telephone call to someone on the other side of the country, the telephone system establishes a stable circuit between your telephone and the telephone you're calling.

Page 18 of 35

Microsoft Word Lab Assignments

Sales 1st Qtr 2nd Qtr 3rd Qtr

The circuit might involve a half dozen or more steps through copper cables, switches, fiber optics, microwaves and satellites, but those steps are established and remain constant for the duration of the call. This circuit approach means that the quality of the line between you and the person you're calling is consistent throughout the call, but a problem with any portion of the circuit -- maybe a tree falls across one of the lines used, or there's a power problem with a switch -- brings your call to an early and abrupt end. When you send an e-mail message with an attachment to the other side of the country, a very different process is used. Your call to an early and abrupt end. When you send an e-mail message with an attachment to the other side of the country, a very different process is used. L 5 - Assignment No.2 Objective: Create a document and type the text given below and save it, now turn on track changes option and make modifications as shown in output, then accept all inserted text and keep deleted text.

Page 19 of 35

Microsoft Word Lab Assignments

Here is the story behind one of the most remarkable Internet successes of our time. Based on scrupulous research and extraordinary access to Google, the book takes you inside the creation and growth of a company whose name is a favorite brand and a standard verb recognized around the world. Its stock is worth more than General Motors’ and Ford’s combined, its staff eats for free in a dining room run by a former chef for the Grateful Dead, and its employees traverse the firm’s colorful Silicon Valley campus on scooters and inline skates. The Google Story is the definitive account of the populist media company powered by the world’s most advanced technology that in a few short years has revolutionized access to information about everything for everybody everywhere. In 1998, Moscow-born Sergey Brin and Midwest-born Larry Page dropped out of graduate school at Stanford University to, in their own words, “change the world” through a search engine that would organize every bit of information on the Web for free. Command to be used: 1. Track Changes

Page 20 of 35

Microsoft Word Lab Assignments

Output:

L 5 - Assignment No.3 Objective: Open a new document and write the text given below and save. Now make document protected by adding password to open and modify.

Coming up with an idea for any of these areas requires some observation skills and creative thought. Start with the things you know about and enjoy and look for ways to make improvements, or sell them to new people. Be observant everywhere you go. Look at how existing businesses operate and make note of the problems you see. Can you come up with a way to eliminate those problems? Can you see a way to improve the service, product or marketability of it? Do you see trends in the market such as larger retired populations? Are there special products or services that that increasing market will need? Page 21 of 35

Microsoft Word Lab Assignments

Command to be used: 1.Protect document Output:

Page 22 of 35

Microsoft Word Lab Assignments

Lecture No.6 L 6 - Assignment No.1 Objective: Correct the spellings and grammer of the passage.

For some, cominng uf with the business idea is the easy part.They simply turn a hobby, or something else that they love doing,into a business. In same cases, this works great. In other cases, it doesn't wark so great. Why the difference? Because you can't just try on the pants when you want,buy the whole suit. In other words there is a lot of different things to consider when you're trying to came up with an idea for a business that will fit you. Those peeple that have made a go of it by converting ther hoby into business were lucky in that there was a market for their business in the first place. It doesn't matter how skilled you are and how moch you love bulding those miniature replias of Star Wars™ Millennim Falcons inside authentic 1940's 6ounce Coca-Cola™ bottles, if there aren't people who want to buy them (i.e. a market) then you're not going to be able to support yourself doing it. It will still be a "hobby." Command to be used: 1. Spelling & Grammar. Output:

For some, coming up with the business idea is the easy part. They simply turn a hobby or something else that they love doing, into a business. In some cases, this works great. In other cases, it doesn't work so great. Why the difference? Because you can't just try on the pants when you want, buy the whole suit. In other words there are a lot of different things to consider when you're trying to come up with an idea for a business that will fit you. Page 23 of 35

Microsoft Word Lab Assignments

Those people that have made a go of it by converting their hobby into business were lucky in that there was a market for their business in the first place. It doesn't matter how skilled you are and how much you love building those miniature replicas of Star Wars™ Millennium Falcons inside authentic 1940's 6ounce Coca-Cola™ bottles, if there aren't people who want to buy them (i.e. a market) then you're not going to be able to support yourself doing it. It will still be a "hobby." L 6 - Assignment No.2 Objective: Open a new file.Write the passage as given below and made the entry to replace the word ‘SAIG’ with ‘St. Angelo’s IT Graduate’.

Welcome to SAIG, a comprehensive career program for undergraduate & graduate (above 12th) that guarantees you not only an IT job but also a rewarding career. This program is available for students from any stream of Arts, Commerce or Science and entitles them for Dual Qualification along with their academic stream thus opening up the doors of global opportunities. Command to be used: 1. Auto Correct. Output:

Welcome to St. Angelo’s IT Graduate program, a comprehensive career program for undergraduate & graduate (above 12th) that guarantees you not only an IT job but also a rewarding career. This program is available for students from any stream of Arts, Commerce or Science and entitles them for Dual Qualification along with their academic stream thus opening up the doors of global opportunities. Page 24 of 35

Microsoft Word Lab Assignments

L 6 - Assignment No.3 Objective: Open a new file.Write the passage as given below and header display text “Word Assignment” and in the footer display page number and align it right for odd pages and right aligned for even pages

Internet has been perhaps the most outstanding innovation in the field of communication in the history of mankind. As with every single innovation, internet has its own advantages and disadvantages. But usually, greater magnitude of advantages outweighs its disadvantages. Communication: The foremost target of internet has always been the communication. And internet has excelled beyond the expectations .Still; innovations are going on to make it faster, more reliable. By the advent of computer’s Internet, our earth has reduced and has attained the form of a global village. Now we can communicate in a fraction of second with a person who is sitting in the other part of the world. Today for better communication, we can avail the facilities of e-mail; we can chat for hours with our loved ones. There are plenty messenger services in offering. With help of such services, it has become very easy to establish a kind of global friendship where you can share your thoughts, can explore other cultures of different ethnicity. Information Information is probably the biggest advantage internet is offering. The Internet is a virtual treasure trove of information. Any kind of information on any topic under the sun is available on the Internet. The search engines like Google, yahoo is at your service on the Internet. You can almost find any type of data on almost any kind of subject that you are looking for. There is a huge amount of information available on the internet for just about every subject known to man, ranging from government law and services, trade fairs and conferences, market information, new ideas and technical support, the list is end less. Page 25 of 35

Microsoft Word Lab Assignments

Students and children are among the top users who surf the Internet for research. Today, it is almost required that students should use the Internet for research for the purpose of gathering resources. Teachers have started giving assignments that require research on the Internet. Almost every coming day, researches on medical issues become much easier to locate. Numerous web sites available on the net are offering loads of information for people to research diseases and talk to doctors online at sites such as, America’s Doctor. During 1998 over 20 million people reported going online to retrieve health information. Command to be used: 1. Insert Header, 2. Footer 3. Page Number.

Page 26 of 35

Microsoft Word Lab Assignments

Output:

Page 27 of 35

Microsoft Word Lab Assignments

Lecture No.7 L 7 - Assignment No.1 Objective: Create a table as shown below. Insert a new column on right side and a new row at the end of the table and format it using auto-format option.

S.No 1. 2. 3. 4. 5. 6.

Student Ram Shyam Sita Gita Rita Mita

Sub1 30 20 40 65 45 30

Sub2 40 50 60 60 55 40

Sub3 50 45 35 75 40 50

Sub4 35 50 45 55 30 55

Command to be used: 1. Tables Output:

S.No 1. 2. 3. 4. 5. 6.

Student Ram Shyam Sita Gita Rita Mita

Sub1 30 20 40 65 45 30

Page 28 of 35

Sub2 40 50 60 60 55 40

Sub3 50 45 35 75 40 50

Sub4 35 50 45 55 30 55

Microsoft Word Lab Assignments

L 7 - Assignment No. 2 Objective: Create a table as shown below. Delete the row, column and cells in the table. 1. Delete the second row. 2. Delete the last column. 3. Delete the last cell of the third row.

S.No 1. 2. 3. 4. 5. 6.

Student Ram Shyam Sita Gita Rita Milta

Sub1 30 20 40 65 45 30

Sub2 40 50 60 60 55 40

Sub3 50 45 35 75 40 50

Sub4 35 50 45 55 30 55

Command to be used: 1. Delete row. 2. Delete column. Output:

S.No 1. 2. 3. 4. 5.

Student Ram Shyam Sita Gita Rita

Sub1 30 20 40 65 45

Page 29 of 35

Sub2 40 50 60 60 55

Sub3 50 45 75 40

Microsoft Word Lab Assignments

L 7 - Assignment No. 3 Objective: Create a table as shown below. Find out total marks of students. Also convert that table into text separated by tabs.

S.No 1. 2. 3. 4. 5. 6.

Student Ram Shyam Sita Gita Rita Milta

Sub1 30 20 40 65 45 30

Sub2 40 50 60 60 55 40

Sub3 50 45 35 75 40 50

Sub4 35 50 45 55 30 55

Total Formula Formula Formula Formula Formula Formula

Command to be used: 1. Enter the formula of sum. 2. Convert table into text. Output:

1. S.No 1. 2. 3. 4. 5. 6.

Student Ram Shyam Sita Gita Rita Milta

Sub1 30 20 40 65 45 30

Sub2 40 50 60 60 55 40

Sub3 50 45 35 75 40 50

Page 30 of 35

Sub4 35 50 45 55 30 55

Total 155 165 180 255 170 175

Microsoft Word Lab Assignments

2. S.No 1. 2. 3. 4. 5. 6.

Student Ram Shyam Sita Gita Rita Milta

Sub1 30 20 40 65 45 30

Sub2 40 50 60 60 55 40

Sub3 50 45 35 75 40 50

Page 31 of 35

Sub4 35 50 45 55 30 55

Total 155 165 180 255 170 175

Microsoft Word Lab Assignments

Lecture No. 8 L 8 - Assignment No-1 Objective: Using mail merge option in the MS word, write a cover letter and mail to multiple users.

Type a letter as follows: [Your Name] [Street Address] [City, ST ZIP Code] April 6, 2009 [Recipient Name] [Title] [Company Name] [Street Address] [City, ST ZIP Code] Dear[Recipient Name]: I am writing in response to your advertisement in [location of advertisement] for a [job title]. After reading your job description, I am confident that my skills and my passion for technology are a perfect match for this position. I would bring to your company a broad range of skills, including: • • • • •

[List skill] [List skill] [List skill] [List skill] [List skill] Page 32 of 35

Microsoft Word Lab Assignments

I would welcome the opportunity to further discuss this position with you. If you have questions or would like to schedule an interview, please contact me by phone at [phone number] or by e-mail at [e-mail address]. I have enclosed my resume for your review, and I look forward to hearing from you. Sincerely, [Your Name] L 8 - Assignment No-2 Objective: Using mail merge option in the MS word, write a letter for complain of a service.

Type a letter as follows: [Your Name] [Street Address] [City, ST ZIP Code] April 6, 2009 [Recipient Name] [Title] [Company Name] [Street Address] [City, ST ZIP Code] Dear[Recipient Name]: This letter is to complain about service I recently received from a [Company Name] customer service representative named [Representative Name]. Page 33 of 35

Microsoft Word Lab Assignments

I called [Company Name] on [date] to find out how to deal with a problem I’ve had with [product or service]. After I had been on hold for several minutes, [Representative Name] came on the line. I had to explain my problem to him several times because he did not seem to be listening and therefore asked me the same questions repeatedly. [Representative Name] put me on hold for several minutes, and then returned to say he could not help me. Needless to say, I was quite frustrated. I expected a much higher level of service from your company, and I am quite disappointed. Because I do not want to spend any more time on this problem, I am [returning or cancelling] [product or service] immediately, and I expect a full refund. I will be informing my friends and family about this experience. Sincerely,

[Your Name]

Page 34 of 35

Microsoft Word Lab Assignments

L 8 - Assignment No-3 Objective: Create a macro to find text Mumbai and make it bold and highlighted, assign a shortcut key to run it.

Welcome to SAIG (St. Angelo’s IT Graduate) program, a comprehensive career program for undergraduate & graduate (above 12th) that guarantees you not only an IT job but also a rewarding career. This program is available for students from any stream of Arts, Commerce or Science and entitles them for Dual Qualification along with their academic stream thus opening up the doors of global opportunities. Feature of SAIG Program. Curriculum and training based on Industry Requirement and leading to International Certifications from Microsoft, Cisco, Adobe, etc. Internship program for 2 months Spoken English and Personality Development course. Command to be used: 1.

Macros.

Output:

Welcome to SAIG (St. Angelo’s IT Graduate) program, a comprehensive career program for undergraduate & graduate (above 12th) that guarantees you not only an IT job but also a rewarding career. This program is available for students from any stream of Arts, Commerce or Science and entitles them for Dual Qualification along with their academic stream thus opening up the doors of global opportunities. Feature of SAIG Program. Curriculum and training based on Industry Requirement and leading to International Certifications from Microsoft, Cisco, Adobe, etc. Internship program for 2 months Spoken English and Personality Development course. Page 35 of 35

Microsoft Excel Class Assignments

Microsoft Excel Class Assignment

Lecture No.1 L 1 - Assignment No.1 Objective: Open a new excel file and enter the data of the student in the following format and save the file. Command to be used: 1. Save As Output:

L 1 - Assignment No.2 Objective: Open new file and enter the data of assignment1 .Format the cells and color the text, cell using format painter. Save the file. Command to be used: 1. Bold, Italic, Underline, Format painter.

Page 1 of 31

Microsoft Excel Class Assignment Output:

L 1 - Assignment No.3 Objective: Open a new file. Enter the data of assignment1 and align the row and column of the table as given below. Save the file. Command to be used: 1. Align first row as Top Left and use bold fonts. 2. Align all rows as Centre and use Italic fonts. Output:

Page 2 of 31

Microsoft Excel Class Assignment

Lecture No.2 L 2 - Assignment No.1 Objective: Open a new file and enter the data of assignment1. Do the following operations 1. Move the worksheet one to second worksheet. 2. Rename the worksheet. 3. Move the new worksheet at first place. 4. Copy the data in the new worksheet. 5. Save the file. Command to be used: 1. Rename 2. Copy or Move Sheet Output:

Page 3 of 31

Microsoft Excel Class Assignment

L 2 - Assignment No.2 Objective: Open a new file and enter the data of assignment1. Edit the cells of the file. Save the file. Command to be used: 1. Cut the Contact Number of the Ram and Paste it at Malti’s Contact Number. 2. Copy the Address of Shyam and Paste it at Rita’s Address. Output:

L 2 - Assignment No.3 Objective: Open a file and enter the data of assignment1. Do the following operations. Save the file. 1. Add a column ‘End Date’. 2. Delete the entry of the Malti.

Page 4 of 31

Microsoft Excel Class Assignment Command to be used: 1. Insert a column. 2. Delete cell. 3. Delete row. Output:

Page 5 of 31

Microsoft Excel Class Assignment

Lecture No.3 L 3 - Assignment No.1 Objective: Open a excel file enter the data. Find the Total, Maximum, Minimum, and Average of Production Amount. Save the file.

Command to be used: 1. Functions (Sum, Min, Max, Average)

Page 6 of 31

Microsoft Excel Class Assignment Output:

L 3 - Assignment No.2 Objective: Open a new file. Enter the data of pervious assignment and change the format of cell Target Achieved from Number to Percentage. . Command to be used: 1. Format Cells. Output:

Page 7 of 31

Microsoft Excel Class Assignment

L 3 - Assignment No.3 Objective: 1. Open a file and enter the data as given below. 2. Use different Text Alignment for first row. 3. Change the Font and Font Size of the second row. 4. Use Border for outline the text.

Command to be used: 1. Alignment, Font, Border Output:

Page 8 of 31

Microsoft Excel Class Assignment

Lecture No.4 L 4 - Assignment No.1 Objective: Open a new file and add the following columns: Book name (A1) Author name (B1 Category (C1) Book price (D1) Discount (E1) Net price (F1) • Enter data in first 4 columns where category should be Novel or Fiction (Enter N for novel, F for fiction). • Calculate discount on following conditions. If Category is N AND Bp < = 500 Bp > 500 AND Bp< =1200 Bp > 1200 AND Bp< =2500 Bp > 2500

3% disc 8% disc 12% disc 15% disc

If Category is F And Bp < = 1000 Bp > = 1000 And Bp < = 2000 Bp > = 2000 •

5% disc 10% disc 15% disc

Calculate net price.

Page 9 of 31

Microsoft Excel Class Assignment

Output:

L 4 - Assignment No.2 Objective: Open a new file and do the following operations:

CLIENT NAME Kothari General Foods Wiltech India Limited Procter & Gamble India Limited Standard Chartered Bank Page 10 of 31

ESTIMATED BILLINGS 18,00,000 /23,00,000 /1,20,00,000 /21,00,000 /-

Microsoft Excel Class Assignment

Modi Xerox Limited Titan Watches Limited Pcico Electronics Limited Kinetic Engineering Limited Britania Industries Limited Crompton Greaves Limited • •

Add five column headings as Category, Revenue, Production Revenue, Creative, Revenue, and Media Revenue. In the Category column enter the formula using ‘If ‘condition.

Category A Category B Category C • • • •

75,00,000/63,00,000 /1,50,00,000 /35,00,000 /2,00,00,000 /50,00,000 /-

Estimated billings are greater than Rs. 1Crore in the year. Estimated billings fall between Rs.50 Lakhs & Rs. 1 Crore(including Rs.1Crore) Estimated billings are less than or equal to Rs. 50 Lakhs.

Revenue is assumed to come from three sources : Production, Creative & Media. Production Revenue is 14% of billing for class ‘C’ clients, 12% of billings for class ‘B’ clients, and 9% of billings for class ‘A’ clients. Creative Revenue is 12% of billings for class ‘C’ clients, 10% of billings for class ‘B’ clients and 8% of billings for class ‘A’ clients. Media Revenue is 15% of the balance (i.e. Billings less Production and Creative Revenue) for all clients.

L 4 - Assignment No.3 Objective: Open a new file and do the following options:

Page 11 of 31

Microsoft Excel Class Assignment 1. Reduce the width of Production Amount to the extent that only Production is visible. 2. Change the alignment of cell containing title production Amount, as Wrap text. 3. Reduce column width of Batch date, Production Quantity, Production amount and change alignment as word wrap text.

Page 12 of 31

Microsoft Excel Class Assignment

Lecture No.5 L 5 - Assignment No.1 Objective: Open a new file and enter the data as given below. Correct spelling if the spelling is wrong.

Command to be used: 1. Spelling Output:

L 5 - Assignment No.2 Objective: Open a file and enter the data of previous assignment. Make the first column such it should visible during scrolling the worksheet.

Page 13 of 31

Microsoft Excel Class Assignment

Command to be used: Freeze Panes Output:

L 5 - Assignment No.3 Objective: Open a file and enter the data of assignment1. Serial number of first column comes automatically. Command to be used: 1. Auto-fill Series, add column

Page 14 of 31

Microsoft Excel Class Assignment Output:

Page 15 of 31

Microsoft Excel Class Assignment

Lecture No.6 L 6 - Assignment No.1 Objective: Create data sheet as shown below and do the following 1. Using page break option make the columns A-I to be printed on page 1 and J-Q on page 2 2. Using Page Setup make column A & B to be printable on all pages 3. Set margins of the page 0.5” left & right and 0.75 top & bottom 4. Print the grid lines 5. Display ABC Corporation Ltd in the header and page numbers in the footer 6. Preview the document in print preview

Command to be used: 1. Page Break 2. Page Setup 3. Print Preview

Page 16 of 31

Microsoft Excel Class Assignment Output:

Page 17 of 31

Microsoft Excel Class Assignment

Lecture No.7 L 7 - Assignment No.1 Objective: Open the file and enter the data as given below. Sum the products of all four quarters and prepare a chart showing details of sales of all three products for all four quarters.

Command to be used: 1. Sum Function. 2. Charts. Output:

Page 18 of 31

Microsoft Excel Class Assignment

L 7 - Assignment No. 2 Objective: Open a file and enter the data as given below .Create a chart and add labels in the chart. Also switch the Row/Column data. Save the file.

Command to be used: 1. Insert Chart. 2. Axis Title. 3. Select Data Source.

Page 19 of 31

Microsoft Excel Class Assignment Output: 7000 6000 5000 4000

Series1

3000

Series2

2000

Series3

1000 0 Region 1

Region 2

Region 3

L 7 - Assignment No. 3 Objective: Open a new file and change the type of chart and format the chart area as shown in output.

Page 20 of 31

Microsoft Excel Class Assignment Command to be used: 1. Change Chart Type. 2. Format Chart Area Output:

Page 21 of 31

Microsoft Excel Class Assignment

Lecture No.8 L 8 - Assignment No.1 Objective: Open a new file and enter the data as given below.

1. Select one column and sort by ascending order. 2. Again select other column sort by descending order. 3. Select three columns and sort the first column by ascending order, other two by descending order. Command to be used: 1. Sort and Filter. Output:

Page 22 of 31

Microsoft Excel Class Assignment

L 8 - Assignment No. 2 Objective: Open a file and do the following operations: 1. Find out the name whose salary more then 40,000. 2. Find out the name whose hire date more then 31/12/00.

Command to be used:

1. Auto Filter.

Page 23 of 31

Microsoft Excel Class Assignment Output:

L 8 - Assignment No.3 Objective: Create a data sheet as shown below and validate name field to accept minimum 4 characters, age between 21 to 40, DOB below 1-1-2007, and also create dropdown list for city field Command to be used: 1. Validation Output:

Page 24 of 31

Microsoft Excel Class Assignment

Lecture No.9 L 9 - Assignment No. 1 Objective: Open a file and enter the data given below. Find calculate the subtotal of each salesperson.

Command to be used: 1. Subtotal,Sort Output:

Page 25 of 31

Microsoft Excel Class Assignment

L 9 - Assignment No. 2 Objective: Open a new file and enter the data as given below. Rearrange the data using Pivot table.

Command to be used: 1. Pivot Table

Page 26 of 31

Microsoft Excel Class Assignment Output:

L 9 - Assignment No. 3 Objective: Create three data sheets containing figures Sales in month Jan, Feb, Mar and consolidate the sales of three months as shown in output

SALES REP Bob Frank Paul Randy Mary Jill

JAN 283,800 507,200 107,600 391,600 226,700 154,200

SALES REP Bob Frank Paul

FEB 558,400 350,400 411,800 Page 27 of 31

Microsoft Excel Class Assignment

Randy Mary Jill

154,200 258,000 233,800

SALES REP Bob Frank Paul Randy Mary Jill

MAR 353,100 532,100 258,400 286,000 162,200 134,300

Command to be used: 1. Consolidate Output:

SALES REP Bob Frank Paul Randy Mary Jill

Qrt 1,195,300 1,389,700 777,800 831,800 646,900 522,300

Page 28 of 31

Microsoft Excel Class Assignment

Lecture No.10 L 10 - Assignment No. 1 Objective: Open a file and enter the data given below. Find out the price of future sales using Goal Seek command.

Command to be used: 1. Goal Seek Output:

L 10 - Assignment No. 2 Objective: Open a file and do the following operations.

Page 29 of 31

Microsoft Excel Class Assignment

1. Find out the best condition when maximum number of products sells (max =200). 2. Find out the worst condition in which minimum number of products sells. (Min =50). Command to be used: 1. Scenario Manager Output:

Page 30 of 31

Microsoft Excel Class Assignment

L 10 - Assignment No. 3 Objective: Create a macro to transpose the copied content as shown in output, assign a shortcut to run it Commands to be used:

1. Macros Output:

Page 31 of 31

Microsoft Excel Lab Assignments

Microsoft Excel Lab Assignment

Lecture No.1 L 1 - Assignment No.1 Objective: Open a new excel file and enter the data of the student in the following format and save the file. Command to be used: 1. Save As Output:

L 1 - Assignment No.2 Objective: Open new file and enter the data of assignment1 .Format the cells and color the text, cell using format painter. Save the file.

Page 1 of 37

Microsoft Excel Lab Assignment Command to be used: 1. Bold 2. Italic 3. Underline 4. Format painter Output:

L 1 - Assignment No.3 Objective: Open a new file. Enter the data of assignment1 and align the row and column of the table as given below. Save the file. Command to be used:

1. Align first row as Top Left. 2. Align all rows as Centre.

Page 2 of 37

Microsoft Excel Lab Assignment Output:

Page 3 of 37

Microsoft Excel Lab Assignment

Lecture No.2 L 2 - Assignment No.1 Objective: Open a new file and enter the data of assignment1. Do the following operations 1. Move the worksheet one to second worksheet. 2. Rename the worksheet.

3. Move the new worksheet at first place. 4. Copy the data in the new worksheet. 5. Save the file. Output:

Page 4 of 37

Microsoft Excel Lab Assignment

L 2 - Assignment No.2 Objective: Open a new file and enter the data of assignment1. Edit the cells of the file. Save the file. Command to be used: 1. Cut the Amount of the Shalini Dave and Paste it at Sunil Shah Amount. 2. Copy the Due Date of Mayur More and Paste it at Jayant Dalmia Due Date. Output:

L 2 - Assignment No.3 Objective: Open a file and enter the data of assignment1. Do the following operations. Save the file. 1. Add a column ‘Start Date’. 2. Delete the due data of Mayur More. 3. Delete the entry of the Sunil Shah.

Page 5 of 37

Microsoft Excel Lab Assignment Command to be used: 1. Insert a column. 2. Delete cell. 3. Delete row. Output:

Page 6 of 37

Microsoft Excel Lab Assignment

Lecture No.3 L 3 - Assignment No.1 Objective: Open a excel file enter the data. Find the Total, Maximum, Minimum, and Average of all car products and years. Save the file.

Command to be used: 1. Functions (Sum, Min, Max, Average)

Page 7 of 37

Microsoft Excel Lab Assignment Output:

L 3 - Assignment No.2 objective: Open a new file. Enter the data of pervious assignment and change the format of the column Due Date and Start Date to dd-MM-yyyy.

Page 8 of 37

Microsoft Excel Lab Assignment Command to be used: 1. Format Cells Output:

L 3 - Assignment No.3 Objective: Open a file and enter the data as given below. Use different formatting and styles.

Page 9 of 37

Microsoft Excel Lab Assignment Command to be used: 1. Alignment, 2. Font 3. Border Output:

Page 10 of 37

Microsoft Excel Lab Assignment

Lecture No.4 L 4 - Assignment No.1 Objective: Open a file and enter the data in the following format

•

Calculate Net Price on following conditions. If Income >=15,000 and Income <=25,000 If Income <15,000 If Income >25,000

Command to be used: 1. If, AND, OR.

Page 11 of 37

Tax= 15. Tax =10. Tax = 20.

Microsoft Excel Lab Assignment Output:

L 4 - Assignment No.2 Objective: Open a file and enter the data in the following format.

•

Calculate the Total Amount. If Quantity > 56,000 Selling Price = 200. If Quantity <=56,000 and Production >30,000 Selling Price = 250. Page 12 of 37

Microsoft Excel Lab Assignment

If Quantity <= 30,000 Selling Price = 300. Command to be used: 1. If, AND, OR. Output:

L 4 - Assignment No.3 Objective: Open a new file and do the following options:

1. Reduce the width of Book Price to the extent that only Book is visible.

Page 13 of 37

Microsoft Excel Lab Assignment 2. Change the alignment of cell containing title production Amount, as Wrap text. 3. Increase column width Book Name column. Output:

Page 14 of 37

Microsoft Excel Lab Assignment

Lecture No.5 L 5 - Assignment No.1 Objective: Open a file and enter the data as given below. Serial number of first column comes automatically.

Command to be used: 1. AutoFill.

Page 15 of 37

Microsoft Excel Lab Assignment Output:

L 5 - Assignment No.2 Objective: Open a file and enter the data of previous assignment. Make the first column such it should visible during scrolling the worksheet.

Page 16 of 37

Microsoft Excel Lab Assignment Command to be used: 1. Freeze Panes Output:

L 5 - Assignment No.3 Objective: Open a new file and enter the data as given below. Correct spelling if the spelling is wrong.

Page 17 of 37

Microsoft Excel Lab Assignment Output:

Page 18 of 37

Microsoft Excel Lab Assignment

Lecture No.6 L 6 - Assignment No.1 Objective: Create data sheet as shown below and do the following 1. Using Page Setup make first two rows to be printable on all pages 2. Set margins of the page 0.25” left & right and 0.75 top & bottom 3. Print the grid lines 4. Display XYZ Systems in the header and page numbers in the footer 5. Preview the document in print preview SALES REP REGION

Bob

Frank

Paul

Randy

Mary

Jill

Jan-06

North

North

South

South

South

North

283,800

507,200

107,600

391,600

226,700

154,200

Feb-06 Mar-06

558,400

350,400

411,800

154,200

258,000

233,800

353,100

532,100

258,400

286,000

162,200

134,300

Apr-06

406,065

611,915

297,160

328,900

186,530

154,445

May-06

466,975

703,702

341,734

378,235

214,510

177,612

Jun-06

537,021

809,258

392,994

434,970

246,686

204,254

Jul-06

617,574

930,646

451,943

500,216

283,689

234,892

Aug-06

710,210

1,070,243

519,735

575,248

326,242

270,125

Sep-06

816,742

1,230,780

597,695

661,535

375,178

310,644

Oct-06

939,253

1,415,397

687,349

760,766

431,455

357,241

Nov-06

1,080,141

1,627,706

790,452

874,881

496,174

410,827

Dec-06

1,242,162

1,871,862

909,019

1,006,113

570,600

472,451

Jan-07

1,428,486.44

2,152,641.27

1,045,372.12

1,157,029.51

656,189.46

543,318.40

Feb-07

1,642,759.40

2,475,537.46

1,202,177.94

1,330,583.94

754,617.88

624,816.16

Mar-07

1,889,173.31

2,846,868.08

1,382,504.63

1,530,171.53

867,810.57

718,538.59

Apr-07

2,172,549.31

3,273,898.29

1,589,880.32

1,759,697.26

997,982.15

826,319.38

May-07

2,498,431.71

3,764,983.04

1,828,362.37

2,023,651.85

1,147,679.48

950,267.28

Jun-07

2,873,196.46

4,329,730.49

2,102,616.72

2,327,199.63

1,319,831.40

1,092,807.38

Jul-07

3,304,175.93

4,979,190.07

2,418,009.23

2,676,279.57

1,517,806.11

1,256,728.48

Aug-07

3,799,802.32

5,726,068.58

2,780,710.62

3,077,721.51

1,745,477.02

1,445,237.76

Sep-07

4,369,772.67

6,584,978.86

3,197,817.21

3,539,379.73

2,007,298.57

1,662,023.42

Page 19 of 37

Microsoft Excel Lab Assignment Oct-07

5,025,238.57

7,572,725.69

3,677,489.79

4,070,286.69

2,308,393.36

1,911,326.93

Nov-07

5,779,024.35

8,708,634.55

4,229,113.26

4,680,829.69

2,654,652.37

2,198,025.97

Dec-07

6,645,878.01

10,014,929.73

4,863,480.25

5,382,954.15

3,052,850.22

2,527,729.87

Jan-08

7,642,759.71

11,517,169.19

5,593,002.29

6,190,397.27

3,510,777.75

2,906,889.35

Feb-08

8,789,173.66

13,244,744.57

6,431,952.63

7,118,956.86

4,037,394.42

3,342,922.75

Mar-08

10,107,549.71

15,231,456.25

7,396,745.53

8,186,800.39

4,643,003.58

3,844,361.16

Apr-08

11,623,682.17

17,516,174.69

8,506,257.36

9,414,820.45

5,339,454.11

4,421,015.34

May-08

13,367,234.50

20,143,600.89

9,782,195.96

10,827,043.52

6,140,372.23

5,084,167.64

Jun-08

15,372,319.67

23,165,141.03

11,249,525.35

12,451,100.04

7,061,428.07

5,846,792.78

Jul-08

17,678,167.62

26,639,912.18

12,936,954.16

14,318,765.05

8,120,642.28

6,723,811.70

Aug-08

20,329,892.76

30,635,899.01

14,877,497.28

16,466,579.81

9,338,738.62

7,732,383.46

Sep-08

23,379,376.68

35,231,283.86

17,109,121.87

18,936,566.78

10,739,549.41

8,892,240.97

Oct-08

26,886,283.18

40,515,976.44

19,675,490.15

21,777,051.80

12,350,481.82

10,226,077.12

Nov-08

30,919,225.66

46,593,372.90

22,626,813.68

25,043,609.57

14,203,054.10

11,759,988.69

Dec-08

35,557,109.51

53,582,378.84

26,020,835.73

28,800,151.00

16,333,512.21

13,523,986.99

Jan-09

40,890,675.93

61,619,735.66

29,923,961.09

33,120,173.65

18,783,539.04

15,552,585.04

Command to be used: 1. Page Break 2. Page Setup 3. Print Preview

Page 20 of 37

Microsoft Excel Lab Assignment Output:

Page 21 of 37

Microsoft Excel Lab Assignment

Lecture No.7 L 7 - Assignment No.1 Objective: Open a file and enter the data as follows. Do the following operations 1. Total of all products given. 2. Prepare a bar graph showing details of sales of all three products.

Command to be used: 1. Sum Function. 2. Insert a chart.

Page 22 of 37

Microsoft Excel Lab Assignment Output:

L 7 - Assignment No.2 Objective: Open a new file and use the data of previous assignment. Do the following operation. 1. Add a heading above the Chart. 2. Add labels on that chart.

Page 23 of 37

Microsoft Excel Lab Assignment

Output:

Page 24 of 37

Microsoft Excel Lab Assignment

L 7 - Assignment No.3 Objective: Open a file and change the format of the chart given below.

Command to be used: 1. Change Chart Type.

Page 25 of 37

Microsoft Excel Lab Assignment Output:

Page 26 of 37

Microsoft Excel Lab Assignment

Lecture No.8 L 8 - Assignment No.1 Objective: Open a new file and enter the data as given below. 1. Select one column and sort by descending order. 2. Select one column and sort by ascending order. 3. Select two columns and sort the two columns by ascending order.

Command to be used: 1. Sort and Filter.

Page 27 of 37

Microsoft Excel Lab Assignment Output:

L 8 - Assignment No. 2 Objective: Open a file and enter the data in the following format. 1. Find the total amount. 2. Find the names of student whose amount is greater than 15,000 and less than 50,000.

Page 28 of 37

Microsoft Excel Lab Assignment Command to be used: 1. Filter 2. Conditional Formatting 3. Formula. Output:

Page 29 of 37

Microsoft Excel Lab Assignment

Lecture No.9 L 9 - Assignment No. 1 Objective: Open a file and enter the data given below. Find out the total of sales monthly.

Command to be used: 1. Subtotal.

Page 30 of 37

Microsoft Excel Lab Assignment Output:

L 9 - Assignment No. 2 Objective: Open a new file and enter the data as given below. Rearrange the data using Pivot table.

Page 31 of 37

Microsoft Excel Lab Assignment

Page 32 of 37

Microsoft Excel Lab Assignment

Command to be used: 1. Pivot table

Page 33 of 37

Microsoft Excel Lab Assignment Output:

Page 34 of 37

Microsoft Excel Lab Assignment

Lecture No.10 L 10 - Assignment No. 1 Objective: Open a file and enter the data in the file. Find out the profit if units are changed using Goal Seek.

Command to be used:

1. Goal Seek. Output:

Page 35 of 37

Microsoft Excel Lab Assignment

L 10 - Assignment No. 2 Objective: Open a file and do the following operations:

1. Find out the best condition when interest is minimum (3%). 2. Find out the worst condition when interest is maximum (9%).

Command to be used:

1. Scenario Manager Output:

Page 36 of 37

Microsoft Excel Lab Assignment

L 10 - Assignment No. 3 Objective: Create a macro to copy paste the values from cells containing formula, use shortcut key Ctrl + Shift + V Commands to be used:

1. Macros Output:

Page 37 of 37

Microsoft Powerpoint Class Assignments

Microsoft PowerPoint Class Assignment

Lecture No.1 L 1 - Assignment No.1 Objective: Open a file and do the following operations. 1. Add Title slide in the file. 2. Write “Internet” in title block and the definition in subtitle block as given below. 3. Save the file. Command to be used: 1. Insert Slide. Output:

Page 1 of 13

Microsoft PowerPoint Class Assignment

L 1 - Assignment No.2 Objective: Open the previous file and add Title slide. Write the text in the slide as given below. 1. Make the heading Bold and colored. 2. Make the sub title Italic and Underline. 3. Use Numbering in sub italic block. Command to be used: 1. Insert Slide. 2. Bold, Font Color. 3. Italic, Underline. Output:

Page 2 of 13

Microsoft PowerPoint Class Assignment

L 1 - Assignment No.3 Objective: Open the previous file and add Title Slide. 1. Write the text “Use of Internet” in the slide as given below. 2. Use WordArt for subtitle. Command to be used:

1. Word Art. Output:

Page 3 of 13

Microsoft PowerPoint Class Assignment

Lecture No.2 L 2 - Assignment No.1 Objective: Use the pervious slide and replace “Internet” with “INTERNET”. Command to be used: 1. Find and Replace. Output:

Page 4 of 13

Microsoft PowerPoint Class Assignment

L 2 - Assignment No.2

Objective: Use the same file and Insert the slide. Write in the slide as given below and apply the animation in the slide. Command to be used: 1. Animation. Output:

Page 5 of 13

Microsoft PowerPoint Class Assignment

L 2 - Assignment No.3 Objective: Use the same file and insert a new slide. Insert the text box and images. Command to be used: 1. Insert a Text Box. 2. Insert picture. 3. Insert Animation on images. Output:

Page 6 of 13

Microsoft PowerPoint Class Assignment

L 2 - Assignment No.4 Objective: Insert another slide and change the theme of the slide. Command to be used: 1. Themes. Output:

Page 7 of 13

Microsoft PowerPoint Class Assignment

Lecture No.3 L 3 - Assignment No.1 Objective: Insert a slide and add a table as given below in the slide. Command to be used: 1. Insert table. Output:

Page 8 of 13

Microsoft PowerPoint Class Assignment

L 3 - Assignment No.2 Objective: 1. Insert a slide and add a chart as given below in the slide. Use the data of pervious slide. 2. Add an action button below the slide. Command to be used: 1. Insert chart. Output:

Page 9 of 13

Microsoft PowerPoint Class Assignment

L 3 - Assignment No.3 Objective: Add a slide and insert a video file in the slide. Command to be used: 1. Insert movie file. Output:

Page 10 of 13

Microsoft PowerPoint Class Assignment

Lecture No.4 L 4 - Assignment No.1 Objective: Type the following text in notes as shown in output to make handouts Search Engines: There many sites for search engine like google.com, yahoo.com, live.com, which helps to search almost anything on web. You can also search particular site for particular content., also image search

Command to be used: 1. Insert chart.

Page 11 of 13

Microsoft PowerPoint Class Assignment

Output:

Page 12 of 13

Microsoft PowerPoint Class Assignment

L 4 - Assignment No.2 Objective: Create publish your presentation using Package CD option for your PowerPoint presentation Command to be used: 1. Package CD Output:

Page 13 of 13

Microsoft Powerpoint Lab Assignments

Microsoft PowerPoint Lab Assignment

Lecture No.1 L 1 - Assignment No.1 Objective: Open a file and do the following operations. 1. Add Title slide in the file. 2. Write heading in title block and the definition in subtitle block as given below. 3. Save the file. Command to be used: Insert Slide. Output:

Page 1 of 12

Microsoft PowerPoint Lab Assignment

L 1 - Assignment No.2 Objective: Open the previous file and add Title slide. Write the text in the slide as given below. 1. Make the heading Bold and colored. 2. Make the sub title Italic and Underline. 3. Use Bullets in sub italic block. Command to be used: 1. Insert Slide. 2. Bold, Font Color. 3. Italic, Underline. Output:

Page 2 of 12

Microsoft PowerPoint Lab Assignment

L 1 - Assignment No.3 Objective: Open the previous file and add Title Slide. 1. Write the text “Use of Internet” in the slide as given below. 2. Use WordArt for subtitle. Command to be used:

Word Art. Output:

Page 3 of 12

Microsoft PowerPoint Lab Assignment

Lecture No.2 L 2 - Assignment No.1 Objective: Use the pervious slide and replace “Terrorism Insurance” with “TERRORISM INSURANCE”. Command to be used: 1. Find and Replace. Output:

Page 4 of 12

Microsoft PowerPoint Lab Assignment

L 2 - Assignment No.2 Objective: In Previous assignment insert a new slide. Write in the slide as given below and apply the animation in the slide. Command to be used: 1. Animation Output:

Page 5 of 12

Microsoft PowerPoint Lab Assignment

L 2 - Assignment No.3 Objective: Use the same file and insert a new slide. Insert the text box and images. Command to be used: 1. Insert a Text Box. 2. Insert picture. 3. Insert Animation on images. Output:

Page 6 of 12

Microsoft PowerPoint Lab Assignment

Lecture No.3 L 3 - Assignment No.1 Objective: Insert another slide and change the theme of the slide. Command to be used: 1. Themes. Output:

Page 7 of 12

Microsoft PowerPoint Lab Assignment

L 3 - Assignment No.2 Objective: Insert a slide and add a table as given below in the slide. Command to be used: 1. Insert table. Output:

Page 8 of 12

Microsoft PowerPoint Lab Assignment

L 3 - Assignment No.3 Objective: 1. Insert a slide and add a chart as given below in the slide. Use the data of pervious slide. 2. Add an action button below the slide. Command to be used: 1. Insert chart. Output:

Page 9 of 12

Microsoft PowerPoint Lab Assignment

Lecture No.4 L 4 - Assignment No.1 Objective: Type the following text in notes as shown in output to make handouts Late Wednesday night, Mumbai, India found itself the target of a ferocious terrorist attack, and the situation remains unresolved even now, three days later. According to reports, upwards of 60 young men entered Mumbai in small inflatable boats on Wednesday night, carrying bags filled with weapons and ammunition, and spread out to nine locations to begin their attacks. Lobbing grenades and firing their weapons, they entered hotels, a railway station and several other buildings, killing scores and wounding even more. As of this moment, the identity of the attackers has yet to be definitively determined, though there are reports indicating some of the gunmen were Pakistani - at least nine of them have been killed, nine more arrested. As of this writing, there were a reported 151 people killed from 11 different countries - though nearly 100 were Indian. More than 300 injuries have also been reported - those numbers may yet rise as several hostage situations still exist in the city

Command to be used: 1. Insert chart.

Page 10 of 12

Microsoft PowerPoint Lab Assignment

Output:

Page 11 of 12

Microsoft PowerPoint Lab Assignment

L 4 - Assignment No.2 Objective: Create publish your presentation using Package CD option for your PowerPoint presentation Command to be used: 1. Package CD Output:

Page 12 of 12