MSDOS
1. Write command to display all files having extension
‘jpg’.
2. Write command to display all files of all types starting
with letter ‘m’.
3. Write command to display all files having names up to ten
characters with second last letter as ‘n’, e.g. intelligent.
4. Write a command to copy the file mars of type exe from
the directory ‘space’ of drive U to another directory “universe” in drive S.
5. Write a command to delete the directory as well as the
files of the directory ‘world’ on drive E.
6. Write command to display all file names on the disk in
drive A and having an extension of no more than two characters.
7. Write command to
copy all the files beginning with ‘m’ and whose file names has a ‘txt’
extension from drive A to the ‘\document’ directory on drive C.
8. Write set of commands to create a subdirectory of the
root directory called ‘exercise’, and then move into it
9.
Perform the following tasks using DOS commands in the DOS
shell:
1.) Create the following
directory tree:
5.) From the directory C:\WINDOWS copy all .log files to the directory log. Create the file all.log containing the content of all log files. Then move the original .log files into the folder trash.
MSWORD
1.
A) Create a document in word format the document
with various font minimum 15 and margin minimum maximum 4 the document should include.
B) 3. A bulleted
of number list
C) A table containing
name address basic pay department as column heading
D) A picture of an animal using the
clip art gallery.
E) A header with your name and the
date
F) A photo with pagination.
2. Create a mailing document for sending the invitation to
your 10 friends for wedding anniversary. The data source must contains name,
address, PinCode, Phone Number
3.
(a) create a 2 pages document in 3 column format. In the
first page you insert an image. Tight wrap the text around the image in the
first page, add table in the second page and change the background colour.
(b) Create a table of content and footnote for the above
document.
4.
Create a newsletter in 3-column layout. Each page should
have an outside border. The page should be landscape oriented.
5.
Create a new document. Add confidential as the water mark.
Add a table and an image from the sample picture. Resize both table and image
to look it a bit bigger. Tight wrap 5 lines of text around the table and image.
Add header and footer. The footer should have a page number.
6.
(a) Use a mail merge to send a letter to all your friends
for inviting them to attend the inauguration of a seminar.
(b) Create a two-page
document in 2-column format. Build a table of contents for 8 this document.
Give your document a title which should be displayed in the header.
7.
(a) Create a 2 page
document in 2-column format. In the first page you insert an image and in the
second page add tables.
(b) Create a table of contents and foot for the above
document.
8.
Create a new document. Add a table and an image from the
sample picture. Resize both table and image to look it a bit bigger. Add 5
lines of text to the document for the picture as well as table. Tight wrap the
text around the image and the table. Now position the image as well as text at
the centre of the page using position option save the document.
9.
Create a new document. Add a picture from the sample picture.
Resize it to make it a bit bigger. Add 5 lines text to the document for the
picture. Tight wrap the text around the image. Now set the image at the centre
of the page using position option. Change the shape of the picture to oval.
Save the document.
10.
(i) You have been asked by a management of a company to
organize a tour for newly recruited staff in the company. Create a standard
cover letter to inform all new members and use mail merge to generate the
customized letters. You need to create a database of all the members whom you
wish to inform.
(ii) Build a table of contents for a document. You may copy
the text from anywhere else to create the document. You may use any heading
from your course material.
MSEXCEL
1(A) Create a spread sheet of
following data.
Roll name m1
m2 m3 total percentage
101 RAM 51 72 88
102 MOHAN 83 56 76
103 SUNIL 75 67 87
104 RAKESH 77 99 80
105 RAMESH 78 45 94
(B) Calculate Total Marks of each
student using formula.
(C) Calculate percentage of each
student using formula.
(D) Find the student having minimum
percentage using function.
(E) Create a bar chart using the
worksheet.
2.
Create a workbook containing monthly expenditure on purchase
of different items by an organization make assumption for items and
expenditure. There is a discount of 20% if the total purchase has exceeded rs
3000. Apply formula for calculating total expenditure and discount.
3.
Create a table of records with column name and monthly
salary. Salary amount should be formatted with two decimal places. There should
be at least 10 records with table. Create a conditional format to highlight top
2 salary amounts with blue colour and the lowest salary amount with red colour.
The table should have a proper heading.
4.
Create a table of expenses for daily needs. The workbook
will have two columns; name of items and
expenditure in percentage. Create a pie chart for the same data. The chart
should have a proper title, legends and labels.
5.
Create a workbook with column name, enrolement number,
subject. The following formula should be
used for grading.
• 80 - A grade
• 60 < 80 - B grade
• 50 < 60 - C grade
< 50 - D grade
All the names are in column A, stored in the format last
name, first name use convert to text feature to separate first name and the
last name. Marks column should be formatted with two decimal places. There
should be at least 10 records.
6.
Create a workbook containing monthly expenditure on purchase
of different items by an organization. Make assumption for items and
expenditure. Apply formula for total expenditure for every item. Also apply
formulae for total amount spent on all items.
7.
Create a new workbook containing students marks in software
engineering course. Add column heading
as Name, Assignment marks, Project marks, Practical marks, total marks,
percentage marks. Add records to the table. Add title to the table as software
engineering. Format the table properly. Use function to calculate total marks
and percentage. Add headers and footers to the worksheet.
8.
(a) Create a workbook containing sale of computers (in
thousands) in a particular 10 city for 6 months in the form of a bar chart.
(b) Use Autofill
feature to fill column C with even numbers and column D with odd numbers in
your workbook. There should be at least 5 records.
9.
Create a table of expenses for purchasing of Newspapers and
magazine. The workbook should show the list of items purchased every month from
suppliers, cost of each item , discount given to the institution which is given
as below :
More than Rs. 50000 - 10% discount
Rs. 50001 - Rs. 1,00000 - 20% discount
> 1,00000 - 30% discount
Appropriate formulae should be used for totaling monthly expenditure, yearly expenditure after discount.
Appropriate formulae should be used for totaling monthly expenditure, yearly expenditure after discount.
10.
Create the workbook containing 10 students records of award
list.
Name Assign Project
Marks TEE Total Percentage Grade Status
N1 10 15 50
N2 8 20 40
N3 - -
-
N10 - - -
Weightage for
assignment - 15%
Weightage for Project
- 25 %
Weightage for TEE - 60 %
Apply formula for total percentage, grading, and status
(Pass/Fail). To score 40% is required in each component to pass.
Comments
Post a Comment