COMPUTER SCIENCE (PRACTICAL) TEST PK STUDY IQ

Q. Using MS Access, create the following document with all formatting exactly as given below
 COMPUTER SCIENCE (PRACTICAL) TEST PK STUDY IQ

Total Mar: 15 X2= 30, Time: 40 minutes

Create a folder in desktop and name the name folder with your Roll number and first name.
Save Word and Excel file under Question Nos. 1 and 2 respective with your full name and
keep
Q.1 Using MS Word, create the following document with all formatting exactly as given
below

M
ahatma Gandhi, byname of Mohandas Karamchand Gandhi, (born
Oct. 2, 1869, Porbandar, India—died Jan. 30, 1948, Delhi), Preeminent
leader of Indian nationalism and prophet of nonviolence in the 20th
century.

Gandhi grew up in a home steeped in religion, and he took for granted religious
tolerance and the doctrine of ahimsa (noninjury to all living beings). He studied law in
England from 1888 to 1891, and in 1893 he took a job with an Indian firm in South
Africa. There he became an effective advocate for Indian rights.

In 1906 he first put into action satyagraha, his technique of nonviolent resistance. His
success in South Africa gave him an international reputation, and in 1915 he returned
to India and within a few years became the leader of a nationwide struggle for Indian
home rule. By 1920 Gandhi commanded influence hitherto unattained by any political
leader in India.

He refashioned the Indian National Congress into an effective political instrument

of Indian nationalism and undertook major campaigns of nonviolent resistance in
1920–22, 1930–34 (including his momentous march to the sea to collect salt to protest
a government monopoly), and 1940–42. In the 1930s he also campaigned to end
discrimination against India’s lower-caste “untouchables” (Dalits; officially
designated as Scheduled Castes) and concentrated on educating rural India and
promoting cottage industry.

India achieved dominion status in 1947, but the partition of the subcontinent into
India and Pakistan was a great disappointment to Gandhi, who had long worked for
Hindu-Muslim unity. In September1947 he ended rioting in Calcutta (Kolkata) by
fasting. Known as the Mahatma (“Great-Souled”), Gandhi had won the affection and
loyalty of millions. In January 1948 he was shot and killed by a young Hindu fanatic.

1. Type the Question as is well and

2. Change the font design Georgia and Change the Size 13.5.
3. Change the Last Paragraph into two columns.
4. Make the Margin left, Right, Up & down 1.5”.
5. Make the line space 1.5 and justify all paragrah
 COMPUTER SCIENCE (PRACTICAL) TEST PK STUDY IQ

Q.1 Using MS Excel, create the following Table with applying with formula for the calculation the
Exact Value.

Sl. Employee Sell in Sell in Sell in Sell in Sell in Sell in Total Average
No. Name January February March April May June Sell Sell
1 K Ragbhan 2500 1200 4500 3600 3460 4560
2 Amitab 3200 1450 3500 1400 2580 1520
Thakur
3 Sunil 3800 1580 3600 3600 2360 4870
Kumar
4 Nitish 2610 1360 5822 2800 1450 6528
Herani
5 Pritam Das 4500 1450 4511 1400 1235 2563
Grand
Total

1. Make a Stacked Column Chat the above following table data from employee name to sell in
June.
 COMPUTER SCIENCE (PRACTICAL) TEST PK STUDY IQ

COMPUTER SKILL TEST MOCK EXAM-2

PK STUDY IQ
Total Mar: 15 X2= 30, Time: 35 minutes
Create a folder in desktop and name the name folder with your Roll number and first name.
Save Word & Excel file under Question Nos. 1 & 2respective with your full name and keep.

Q.1 Using MS Word, create the following document with all formatting exactly as given
below

Aditya-L1 Mission
 COMPUTER SCIENCE (PRACTICAL) TEST PK STUDY IQ

Instructions:
1. Type the Question as is well and
2. Change the font design Georgia and Change the Size 13.5.
3. Make the line space 1.5 and justify all paragraph
4. Make the Margin left, Right, Up & down 2 c.m.
5. Change the font colour, bold etc. accordingly.

Q.2 Using MS Excel, create the following Table with applying with formula for the
calculation the Exact Value.
COMPUTER SCIENCE (PRACTICAL) TEST PK STUDY IQ
CamScanner
CamScanner
 HyperText Transfer Protocol.

pk1234@[Link]

copy to another person

Google chrome, Mozila Firefox, Microsoft edge,

internet explorer
Gmail & Yahoo

Uniform Resource Locator

FTP
FTP, the File Transfer Protocol,
Simple Mail Transfer Protocol (STMP)
 HyperText Transfer Protocol.

pk1234@[Link]

copy to another person

Google chrome, Mozila Firefox, Microsoft edge,

internet explorer
Gmail & Yahoo

Uniform Resource Locator

FTP
FTP, the File Transfer Protocol,
Simple Mail Transfer Protocol (STMP)
 HyperText Transfer Protocol.

pk1234@[Link]

copy to another person

Google chrome, Mozila Firefox, Microsoft edge,

internet explorer
Gmail & Yahoo

Uniform Resource Locator

FTP
FTP, the File Transfer Protocol,
Simple Mail Transfer Protocol (STMP)
 COMPUTER SCIENCE (PRACTICAL) TEST

Create a folder in desktop and name the name folder with your Roll number and first name.

Save Word and Access file under Question Nos. 1 and 2 respective with your full name and keep

Q.1 Using MS Word, create the following document with all formatting exactly as given below

M
ahatma Gandhi, byname of Mohandas Karamchand Gandhi, (born
Oct. 2, 1869, Porbandar, India—died Jan. 30, 1948, Delhi), Preeminent
leader of Indian nationalism and prophet of nonviolence in the 20th
century.

Gandhi grew up in a home steeped in religion, and he took for granted religious
tolerance and the doctrine of ahimsa (noninjury to all living beings). He studied law in
England from 1888 to 1891, and in 1893 he took a job with an Indian firm in South
Africa. There he became an effective advocate for Indian rights.

In 1906 he first put into action satyagraha, his technique of nonviolent resistance. His
success in South Africa gave him an international reputation, and in 1915 he returned
to India and within a few years became the leader of a nationwide struggle for Indian
home rule. By 1920 Gandhi commanded influence hitherto unattained by any political
leader in India.

He refashioned the Indian National Congress into an effective political instrument of

Indian nationalism and undertook major campaigns of nonviolent resistance in 1920–
22, 1930–34 (including his momentous march to the sea to collect salt to protest a
government monopoly), and 1940–42. In the 1930s he also campaigned to end
discrimination against India’s lower-caste “untouchables” (Dalits; officially
designated as Scheduled Castes) and concentrated on educating rural India and
promoting cottage industry.

India achieved dominion status in 1947, but the partition of the subcontinent into
India and Pakistan was a great disappointment to Gandhi, who had long worked for
Hindu-Muslim unity. In September1947 he ended rioting in Calcutta (Kolkata) by
fasting. Known as the Mahatma (“Great-Souled”), Gandhi had won the affection and
loyalty of millions. In January 1948 he was shot and killed by a young Hindu fanatic.
 COMPUTER SCIENCE (PRACTICAL) TEST

Q.2 Using MS Access, create the following document with all formatting exactly as given below
COMPUTER SCIENCE (PRACTICAL) TEST
New Section 3 Page 1
New Section 3 Page 2
New Section 3 Page 3
 SKILL TEST MOCK 1 PK STUDY IQ

Total Mark- 30

Time: 35 Minutes
 SKILL TEST MOCK 1 PK STUDY IQ

SALARY CALCULATION

NAME BASIC DA HRA GROSS NPS P. TAX TOTAL NET

DEDUCTIONS SALARY

PRAKASH 90000 200

AMARESH 88000 200

PRASANT 75000 200

ARCHIT 80000 200

AKHAYA 72000 200

SKILL TEST PRACTICE MOCK SET PK STUDY IQ
 What is Chandrayaan-3?
Chandrayaan-3 is the third Moon mission by India’s space agency ISRO. The goal is to place a lander
and rover on the lunar surface and operate them for roughly one lunar day, or 14 Earth days. The small
rover, which weighs just 26 kilograms (57 pounds), flew to the Moon inside the lander. Both vehicles
are equipped with science instruments to study the surface.
Chandrayaan-3 completed a soft landing in the Moon's south polar region on August 23, 2023.

Chandrayaan-3 launch vehicle integration

CHANDRAYAAN-3 LAUNCH VEHICLE INTEGRATION The Chandrayaan-3 lander, with its rover inside, sits
atop the propulsion module that will carry it to lunar orbit. The rocket’s protective aeroshell fairings,
which protect the spacecraft during launch and ascent, can be seen in the background. Image: ISRO
The Chandrayaan-3 lander and rover are similar in design to those from the Chandrayaan-2 mission.
In September 2019, the Chandrayaan-2 Vikram lander successfully lowered itself to within 5 kilometres
(3 miles) of the Moon, entering a “fine braking” mode that would have placed it gently on the lunar
surface. Like its successor, Chandrayaan-2 was targeting the Moon’s south polar region, where ice has
been found inside permanently shadowed craters.

Unfortunately, a software glitch caused Vikram to veer off course, and ISRO officials lost contact with
the spacecraft. NASA’s Lunar Reconnaissance Orbiter later found debris from the vehicle scattered
about 750 meters (a half mile) from the intended landing area.

The mission was not a total loss: Chandrayaan-2 also included an orbiter that continues to study the
Moon from above. Among other scientific functions, the orbiter is equipped to scan for water ice.

Having figured out what doomed the Vikram lander, ISRO says they have upgraded the lander’s
software and performed numerous tests to ensure that Chandrayaan-3 goes according to plan.
Chandrayaan-3 does not include an orbiter, although the propulsion module that will carry the lander
to lunar orbit is equipped with a science instrument that will observe Earth as if it were an exoplanet,
providing data for future exoplanet studies.

Chandrayaan-3 lander and rover

CHANDRAYAAN-3 LANDER AND ROVER ISRO’s Chandrayaan-3 lander is seen here with its ramp
unfolded, revealing a small rover that will drive on the lunar surface.
From liftoff to touchdown, it took about 40 days to place Chandrayaan-3 on the lunar surface.

Special Instruction:
• Make the 3rd Paragrph Bold
• Change all paragraph letters font to Bell MT and Change Size to 14.5
• All the Best.
 What is Chandrayaan-3?
Chandrayaan-3 is the third Moon mission by India’s space agency ISRO. The goal is to place a lander
and rover on the lunar surface and operate them for roughly one lunar day, or 14 Earth days. The small
rover, which weighs just 26 kilograms (57 pounds), flew to the Moon inside the lander. Both vehicles
are equipped with science instruments to study the surface.
Chandrayaan-3 completed a soft landing in the Moon's south polar region on August 23, 2023.

Chandrayaan-3 launch vehicle integration

CHANDRAYAAN-3 LAUNCH VEHICLE INTEGRATION The Chandrayaan-3 lander, with its rover inside, sits
atop the propulsion module that will carry it to lunar orbit. The rocket’s protective aeroshell fairings,
which protect the spacecraft during launch and ascent, can be seen in the background. Image: ISRO
The Chandrayaan-3 lander and rover are similar in design to those from the Chandrayaan-2 mission.
In September 2019, the Chandrayaan-2 Vikram lander successfully lowered itself to within 5 kilometres
(3 miles) of the Moon, entering a “fine braking” mode that would have placed it gently on the lunar
surface. Like its successor, Chandrayaan-2 was targeting the Moon’s south polar region, where ice has
been found inside permanently shadowed craters.

Unfortunately, a software glitch caused Vikram to veer off course, and ISRO officials lost contact with
the spacecraft. NASA’s Lunar Reconnaissance Orbiter later found debris from the vehicle scattered
about 750 meters (a half mile) from the intended landing area.

The mission was not a total loss: Chandrayaan-2 also included an orbiter that continues to study the
Moon from above. Among other scientific functions, the orbiter is equipped to scan for water ice.

Having figured out what doomed the Vikram lander, ISRO says they have upgraded the lander’s
software and performed numerous tests to ensure that Chandrayaan-3 goes according to plan.
Chandrayaan-3 does not include an orbiter, although the propulsion module that will carry the lander
to lunar orbit is equipped with a science instrument that will observe Earth as if it were an exoplanet,
providing data for future exoplanet studies.

Chandrayaan-3 lander and rover

CHANDRAYAAN-3 LANDER AND ROVER ISRO’s Chandrayaan-3 lander is seen here with its ramp
unfolded, revealing a small rover that will drive on the lunar surface.
From liftoff to touchdown, it took about 40 days to place Chandrayaan-3 on the lunar surface.

Special Instruction:
• Make the 3rd Paragrph Bold
• Change all paragraph letters font to Bell MT and Change Size to 14.5
• All the Best.
All District Court Computer Questoins

IQ
u dy
St
PK

Scanned by CamScanner
 IQ
y
ud
St
PK

Scanned by CamScanner
 IQ
y
ud
St
PK

Scanned by CamScanner
 IQ
y
ud
St
PK

Scanned by CamScanner
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
 IQ
udy
St
PK

Scanned By Scanner Go
PK
St
u dy
IQ
PK
St
ud
y
IQ
 RECRUITMENT FOR THE POST OF STENOGRAPHER 2013-14

COMPUTER TEST
TIME: ONE HOUR FULL MARKs-100

INSTRUCTION
IN YOUR
CREATE AFOLDERONE NAME. CREATEONEMICROsOFT
MICROsOFT WORD SHEET INSIDE THE
ELEEAND
FOLDER AND SAVE.

MARZINE 3 C.M. ON TOP, 3 C.M. ON

PROVIDE LEFT, 2 C.M. ON
GHAND AND
2 C.M. ON BOTTOM OF THE PAGE. THE FONT NAME
FONT SIZE SHALL BE 13. LINE SPACING SHALL
SARIAL
a. 1. Type the following passage

IQ
as shown below. 25 MARKSs
The name Odisha is
derived from Oretes is probably the Sanskrit
Ora (Ura) or
Pali or
Sanskrit words
Odra Desa or Sumera Odra, and the Mount Maleus has
been identified with Malayagiri near
dy
or Odra Visaya. The earliest Pala Lahara. Pliny assoclatees
to Odrasis
the
epigraphic
found
reference
the Soro copper plate grant
mount Maleus with the people called
in Monedes and snaris, wno
were
u
ofSomadatta, from which tt s cled [Link] same aa tiie iunGes
nat uara 08 ISaya andtheSavaras respectively,
St

of the upland regions of

Sarepahara identified with Soro inhabiting
Balasore (8aleswar_distric, was Odisha.
of Odra
part Visaya.
Both Pall and
Sanskrititeratures mention the Visitors also called the
PK

Odra Odisha with

people asAncient
Oddaka and odrah, ditterent names. ne
respectively. writers like Chinese pilgrim Hiuen-Tsang who
visited Odisha in about 636 CE
Piny the Elder and Ptolemy
described the Odra people as gives an account of the territory
Oretes In the Mahabharata the named Wu-Che, which is very likely
Odras are mentioned along with the tne same as Odra. he pilgrim
Paundras, that (Wu-tu)
Otxals Mekalas,
while
states the Wu-Cha
Kalingas and Andhras,
according to Manu the_ Odras are
country was above 7.000 li in circuit
was 20 h in
and s Capital above
associated with the Paundrakas, Circuit. he area of the tertory,
Dravidas, Kambojas, YavanasS which was 7.000 li or (2,253
kilometres (1,400
Sakas, Paradas, Palavas. Chiias
Kiratas and Khasas. The location of was verY
miles))
extensive.
in

The
Circuit,
Muslim
the Odra territory has been given in bn Khurdadhbin, who
the Natural History of Pliny, in which
geograpner
t that the
wrote his gengraphy in 846 CE,
is mentioned Oretes
were relers istoa territory called Ursfin,
inhabiting the country where the which identified by the RuSsian
mount Maleus sto0d The Greek Scholar V. Minorsky with Odra Desa
 Faper-Skill Test in Computer Application (Lab) Time: 1 Hr. Full Marks: 5
******** *************

Q1. Create a document with the text given below [10)

ne parts of the computer as Invention of Compute

we now know it did not appear all at once n one

to
machine created by one person in the
Starting many people began
17 century,
work on machines that would automate tasks, with results that we still use

the and failures in the development towards the compuer

ne or
was n e
great suCcesses
eariy 1 9 Ccentury "Babbage's Folly", a machine that was supposed to De

an automatic mechanical calculator but that never

not
worked. Charles Babbage could
overcome mechanicalproblems in trying to build his machine. wnat was
about the machine what we still use now is the idea Babbage had tore
Successtul
how his machine would process intormation

shown
Babbage s design would have used punched cards similar to the one

IQ
above, with different formats for the Data cards and the Control cards

Follow as per below

nstructions
d y p e t n eabove three paragraph with ont type: Arial and Font size: 12
Bold the Heading and underline.
dy
the first sentence and make the size 14
C
d.
Underline
Bold the text "Babbage s Folly
and make the fext color blue.
e Top Margin 1
Bottom margin
u
9 Left margin 1.5"
h
Right margin 1.
St

Line spacing is 1.5

Paragraph spacing (before & after) 10 points

table in MS-Excel as
22. Creale a per below
PK

10)
MARKS IN MARKS IN MARKS
PERCENTAGE
[Link] NAME PHYSICS CHEMISTRY IN MATH TOTAL (%)
S001 MADHUBALA 55 42
39
SO02 SIMANCHALA 65 53
SO03 HARIHAR 76 64 53
s004 SUDHABALA 54 43
S005 SANATANA 45 86 45
S006 NEELAM 5 8
2

Instructigons Follow as per below

a. (NAME) Left Alignment.
b.(Rest columns) Center Alignment.
.2. Prepare the tollowing table in Microsoft Excel sheet. Calculate and thl the
desired columns. 25 MARKS.

OF
ROLL NO. POL. SC HISTORY LOGIC COMPUTERTOA MARKS
611959 60.27 8276 65.39 51.85 7.43
(se
611960 65.73 T8.18 64.98 6486 85.86

811961 59.37 62.19 74.68 59.87 80.94

IQ
611962 71.69 82.59 N.8 57.28 79.82

611963 71.73 75.89 52.58 62.47 66.89

ULL
MARKS T00
u dy
Q. 3. Prepare the above sheet once again and arrange the Roll Numbers in
order of tneir merit. 25 MARKS.
St
PK

Q.4. There are 2357 candidates qualified to attend the Written Examination.
Tou are required to issue Intimalion Letters separately to each candidate. You
have the list of candidates. You are required to apply Mail Merge programme to
complete the task. Describe procedure step by step to be followed by you while
adopting Mail Merge. 25 MARKS.

*********************************t
 c Find TOTAL of PHYSICS CHEMISTRY and MATH of each students
Using appropriate formula
a tind PERCENTAGE using TOTAL column out of totai marks of 3
maxitum mark of each paper is 100) The cell shouid show Ys Sign

Q3 a Reter MS E xcel sheet of Q2 Create a colurnn chart below the tabie using
held name (PHYSICS CHEMIsTRY and MATH)

Copy the total table to another location of Excel sheet Sort the narries ara
maiks n b
descending order of percentage
Q4 Enter the data and format (MS-Excel) as given in the tollowing taDie

ENO NAME AGF DEPI BASICDA

1 Subrat 25 Accts B000 F23
HRA GROSS

IQ
Mohan 36 Adms 12000

Ramlal 31 HRD B000

dy
Kiran 29 ACcts G0O0

5 Priyanka 34 Adms 7000

u
6 Manas 56 HRD 11000
St

Follow
nstructions
à
as
per beiaow
Make colurnn header Font Courier, Format Bold and Font
ype size 14

b. Rest of the text and numbers Font type Arial and Font size. 12
PK

c
ENO. AGE. DA, HRA and GROSS value center aligned The NAME and
DEPT COlumn value left aligned
d Find the following
a DA=30% of BASIC
b HRA 40% of BASIC
e F i n d out the Gross = BASIC D A HRA

0Type the following text using subscpt dna

supeiscpt as
Uispiayed
MSS-Word) below
àfa * D)a*2ab b (10
b. (a b)=a-2ab * b
c
b' (a+bj(a b})
d 2H, O, 21,0
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
u dy
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
udy
IQ
PK
St
udy
IQ
PK
St
udy
IQ
PK
St
udy
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
udy
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ
PK
St
ud
y
IQ