advanced level - gitapepanthiya.com/resources/git/papers/2014 git seminar tutorial... · by flow...
TRANSCRIPT
-
Copyright PRABUDDHA SRIMAL - www.apepanthiya.lk
Advanced Level - GIT
General
Information Technology
&
B.Sc.(IT), RHCSA, CCNA
Special Seminar for GIT Examination 2014
-
Copyright PRABUDDHA SRIMAL - www.apepanthiya.lk
Microsoft Excel
A - ______________________________________________________________________________
B - ______________________________________________________________________________
C - ______________________________________________________________________________
D - ______________________________________________________________________________
E - ______________________________________________________________________________
F - ______________________________________________________________________________
G - ______________________________________________________________________________
A
B
C
D
E
F
G
-
Copyright PRABUDDHA SRIMAL - www.apepanthiya.lk
1. Following is an electronic spreadsheet to analyse employee salary and deductions of an
international company and it shows a part of Mr.Susitha Kariyawasams salary scale. The
company paid to Mr.Susitha by US$ of currency and he is given his salary from SL Rupees.
i. Write the formula to calculate Total Earning on cell B11.
ii. Write the formula to calculate Gross salary on cell B19.
iii. Write the formula to calculate E.P.F on cell B20. (E.P.F is calculated using the basic
salary)
iv. Find the formula for cell B23 to calculate Mr.Susithas Net Salary for 2 decimal places by
using functions.
v. Column C indicates all the amounts represented in SL rupees and F3 contains the
currency rate. Find the formula for C7 in order to absolute cell reference.
-
Copyright PRABUDDHA SRIMAL - www.apepanthiya.lk
Microsoft Word
A - ___________________________________________________________
B - ___________________________________________________________
C - ___________________________________________________________
D - ___________________________________________________________
E - ___________________________________________________________
F - ___________________________________________________________
G - ___________________________________________________________
H - ___________________________________________________________
I - ___________________________________________________________
J - ___________________________________________________________
A
B
C
D E G
I
F
H
J
-
Copyright PRABUDDHA SRIMAL - www.apepanthiya.lk
2. Following questions based on the Logic circuit given below.
i. Write the Boolean equation. ^by; mm:h ioyd nQ,Sh ilrKh ,shkak'&
ii. Construct the truth table. ^by; mm:hg wod, my; oelafjk i;H;d j.=j imQK lrkak'&
A B C
3.
i. Briefly explain the Operating System.
fufyhq moaO;shla hkq l=ulaoe hs flfhka ia;r lrkak'
ii. Give 5 examples of modern operating systems.
kQ;k fufyhq moaO;s 5 la i`oyd WodyrK olajkak'
iii.
Identify A and B of above the above figure.
by; rEmfha A iy B k lrkak'
A
B
-
Copyright
iv. What do you understand by Utility software?
Wmfhda.S uDldx. ^Utility software
v. What are the main functions of an O/S?
fufyhq moaO;shl uQ,sl ldh fudkjdoehs k lrkak'
vi. Give 5 examples for utility software.
Wmfhda.S uDldx. i`oyd WodyrK 5 la olajkak'
4. Car racers who are going to participate to a car
race competition. Racers always need to keep
their speed greater than 100 km/h, and also
have to complete 50 laps in
Participants who complete the 50 laps
won the race. Others who couldnt complete the
laps will be eliminated from the Race
i. Fill the following flow chart ac
above scenario.
ii. Write a pseudo code for the logic indicated
by flow chart.
iii. What are the control structures can
identified in the flow chart?
Copyright PRABUDDHA SRIMAL - www.apepanthiya.lk
What do you understand by Utility software?
Utility software& hkq fudkjdo@
What are the main functions of an O/S?
fufyhq moaO;shl uQ,sl ldh fudkjdoehs k lrkak'
Give 5 examples for utility software.
Wmfhda.S uDldx. i`oyd WodyrK 5 la olajkak'
Car racers who are going to participate to a car
race competition. Racers always need to keep
their speed greater than 100 km/h, and also
50 laps in to win the race.
Participants who complete the 50 laps will be
. Others who couldnt complete the
from the Race.
Fill the following flow chart according to the
Write a pseudo code for the logic indicated
What are the control structures can be
ed in the flow chart?