Q.No.l What is the fuJi form ofHTML HTTP? Write the name of any two commonly used E·Mail servers.
Write full form of DRAM and EEPROM.
What is Recycle Bin? Write steps to retrieve file from Recycle Bin?
Write steps to change desktop wallpaper in Windows.

Q. No.2 Create the following table in MS-Word:
Name Age Gender
Row1 X 19 Male
Row2 Y 18 Female
Row3 Z 20 Female

Copy the above table and paste it in next page.
Insert a new row in copied table between Row I and Row 2 with contents

Name Xa Age=2l Gender= Female
Sort the table of part in ascending order with respect to the field' Age'.
Insert the header 'Exam 20 and footer in above MS-Word file.

Q. No.3 Create MS-Power Point presentation as per following:
Add first slide and write title in the slide as "Uttarakhand Public Service Commission" and subtitle as
"Haridwar".
Add second slide and insert a table of3 rows and 3 columns.
Add third slide and insert a 3-D Clustered Column Chart based on following table:

Add fourth slide and insert Smart Art GraphIC as following:

<img src='./qimages/3399-3d.jpg'>
Type like India" in the above Smart Art graphic in following manner:

<img src='./qimages/3399-3e.jpg'>
Q. No.4
Create a worksheet in MS-Excel with fields MALE, FEMALE, LITERACY and enter the following data of four Districts.

<img src='./qimages/3399-4.jpg'>

Add a new column named as POPULATION in the above sheet and calculate the POPULATION of each
district by adding their respective MALE and FEMALE population.

Calculate the total POPULATION of all districts and display it in the last cell of the same column.

Calculate the average of LITERACY of all the District and display it in the last cell of the same column.

Insert a 2-D Clustered Column chart of table given in part of Ihis question and display it in the same
sheet without overlapping.

Q. No.5 Create a database 'EMPLOYEE' in MS·Access with fields
Name(Text), Designation(Text), Basic(Number), G.P.(Number), D.A.(Number), Total_pay(Number).

Insert the following records in database 'EMPLOYEE'

<img src='./qimages/3399-5b.jpg'>

CalculalC D.A. of each employee where D.A 125 of(Basic G.P.) using M$-Access Query.

Calculate TotalJ'ay of each employee where TotalJ'ay= Basic G.P. D.A. using MS·Access Query.

Sort the records in ascending order with respect to the field TotalJ'ay.

Uttarakhand Judicial Service Civil Judge Examination -2015


Q. No.6 What is hyper link? Why is it used?
Write full form of IMAP and POP3?
What is full form ofCD-R and CD-RW?
Write names of any two GU) based operating systems.
One Tera byte data is equal to Giga bytes?
Q.No.7
Create the following table in MS-Word.

<img src='./qimages/3399-29.jpg'>
Set the font size 22 and font style italic of Row 1.
Insert the square shape in the next page and write down within it.
Insert the footer 'Uttarakhand' in above MS-Word File.
Insert the page number at the top of the above M$-word file.

Q. No.8 Create MS-Power Point presentation as per following:
Add first slide and write title as "Department of Computer Science" in Bold, Italic, Underline
Add following subtitle with Bullets in the same slide:

• Operating System
• Computer Fundamental
• Windows
• Programming Language
<img src='./qimages/3399-8c.jpg'>


Add third slide and insert Smart Art Graphic as following:

<img src='./qimages/3399-8d.jpg'>

Insert date and slide number in the fOOler of each slides.

Q. No. 9
Create a worksheet in MS-Excel wim fields ROLL_NO, STUDENT_NAME. TEST!, TEST2, TESTJ, TOTAL_MARKS, PERCENTAGE and enter the following data of four students:

<img src='./qimages/3399-9a.jpg'>

Calculate TOTAL_MARKS and PERCENTAGE of each student(where maximum marks of each test is
100).
Arrange the above table in descending order on the basis of PERCENTAGE.
Convert the Text Alignment of whole table in Right (indent).
Insert a Stacked Column chart of the above table and display it in the same sheet without overlapping.

Q. No.10
Create a database in MS·Access with fields: item(Text), Price{Number), DiscounU"_Percentage(Number), Net_Price(Number).

Insert the following records in data base' SALES'

<img src='./qimages/3399-10b.jpg'>

Calculate the Net_Price of each item after deducting respective discouol given in field
Discount_in_Percentage.

Insert a new field Quantity (number) with values 3 and 4 for Item Y and Z respectively.
Calculate the total price oral! ilems as per quantity given in part using MS·Access query.