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…………………………...

ü  Keyboard,ü  Image scanner,ü  Microphone,ü  Pointing device,ü  Graphics tablet,ü  Joystick,ü  Light pen ü  Mouse,ü  Pointing stick,ü  Touchpad,ü  Touchscreen,,ü  Trackball,ü  Webcam,ü  Softcam,¤  Monitor,

¤  Printer,¤  Speakers,¤  Plotter,

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 2^nd

Change the word H2O so that it looks like H₂O.

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