Wednesday, October 9, 2013

INFOPARK ZONE TEST PAPER




INFOPARK ZONE
Name:-……………………………
Time Slot :………to……….....

Microsoft Office Unit Test-7
Note : - Solve the only 5 Questions as under Question No.1 Compulsory . Every Question are 2 Marks                                                                                                                       

1. Create a Power Point Presentation in Four Slides  and use animation effect using sound effect , timing 4 Sec .First Slide Matter are given below : -   
Or Microsoft Office word File
         (i).Keyboard Step for (a) Shut Down in Win-7……………………. Shut Down in Win-xp………………………..(b) Starting of Microsoft Office Word ……………………………………………………………Excel………………………………………………………………..Powerpoint……………………………………………………………………
       (C) Starting  Wordpad……………………………………………………………….Notepad…………………………………..……………………………..Refresh key for Computer………....
(ii). Write the Short Key (a) Change the Font Size……………………………….(b)Change the Font…………………………….(c) Move the cursor end of the document……………………………….(d) Change case of Selected Text……………………………………..(e)Save as…………………(f) Insert Current date…………………………… (g) Move the cursor Start of the document………………………(h) Double Line Spacing………………………………(i) Paragraph Justify………………………………………..
(j) Word Replace Key is………………………………….. (k) Spelling Check Key………………………… ( L) Go to the last row……………………….(M) Go to the last column……………………….(n) Go to the cell AA 550……………………………….(o) Back the first cell of the worksheet…………………………...
Save this ppt on desktop with your name with password protect and Open your gmail Id and send this presentation to daman1975@gmail.com.

2.      Create three new folders on desktop  under your folder name 1. Notepad 2. Paint.  3. Office
¤  Create a text file in notepad kundli font size 18  and keep your name, address, Phone N0. And all the details about yourself and save this file into the notepad folder.
¤  Open paint and draw the following figures using proper tools and fill with proper colour.
save it in the paint folder.Rename the paint file with your name.bmp
3. Do the following :-
Change the functions of left and right mouse buttons., Create a New User With Password Protect
Set your screen saver to star filed simulation, with a waiting time of 1 minute., Create a new Folder & Lock With Password
4. Read the instructions below create a any word file and make formatting changes within the text as instructed.
Type Infopark~Zone using Format this line as bold, italic, Arial font face, dark blue colour, and 15 pt font size.
Change the word 2nd so that it looks like 2nd
Change the word H2O so that it looks like H2O.
Use (=rand(1,4) and Format this sentence so that the words, and not he spaces between the words, are underlined.
5. Format the following into superscript;
25m2                      4m3                        30m2                      60m3
4m2                        x2                            a2                            1000C
 6. Write  a paragraph using rand Comm. i.e,=rand(10,10) and create a Drop Cap for three lines using rand command.
Create a header as “STATE BANK OF INDIA” and footer Page number for all pages and apply center alignment to them.
Keep page number at the bottom of every page with Left Alignment.
Write a letter to 5 person with using mail merge options.
7. Write the step for password Change of Yahoo mail Id.
8. Create a Pivot Table
9. Write the Example of Lookup,Vlookup,Hlookup.
PATIENT
WARD
DEPT.
ADDMISSION DATE
DISCHARGED DATE
NO. OF DAYS
ROOM RENT
FEES
TOTAL AMOUNT
KAJOL
SKIN
SPECIAL
1-Jan-99
10-Jan-99


1200

AJAY
EYES
GENERAL
1-Jan-99
5-Jan-99


2100

MADHU
NOSE
SPECIAL
2-Jan-99
2-Mar-99


800

RANI
EAR
SPECIAL
2-Feb-99
2-Feb-99


900

PRITI
EAR
SPECIAL
10-Mar-99
5-May-99


4100

Condition for Room Rent


WARD
ROOM RENT







SPECIAL
150







GENERAL
100