www.apme.in Andhra Pradesh Model Exams
ANDHRA PRADESH
COMPUTER PROFICIENCY TEST (CPT)
Proficiency in office automation with usage of Computers & Associated Software
Max. Marks: 100 Duration: 60 Minutes

Instructions to the Candidate:

  • Create a Folder with your Hall Ticket Number.
  • Save the file for every Question with your Hall Ticket Name in the above created folder.
PART-A
Multiple Choice Questions (20 × 1 = 20M)
1. Booting refers to?
A) The processing of starting the computer from the power-off position
B) Connecting computer to the electric switch
C) The process of shut down the computer
D) The Process of restart the computer
2. Light Pen is?
A) Input Device
B) Output Device
C) Pointing device
D) None of the Above
3. Printer is?
A) Input Device
B) Output Device
C) Pointing device
D) None of the Above
4. Which of the following is correct sequence of largest to smallest unit of storage?
A) 1.TB 2.GB 3.MB 4.KB
B) 1.KB 2.MB 3.GB 4.TB
C) 1.MB 2.TB 3.KB 4.GB
D) 1.GB 2.KB 3.TB 4.MB
5. The purpose of CPU is?
A) To Process data and information
B) To Carryout program instructions
C) To Store data for future use
D) Both A & B
6. Which is not an internal part of computer?
A) Keyboard
B) Mouse
C) UPS
D) CPU
7. Which of the following is not an example of Open Source Software?
A) Unix
B) Linux
C) Adobe Reader
D) MySQL
8. What is the meaning of Bcc in Email?
A) Blind Carbon Copy
B) Blue Carbon Copy
C) Bar Code Copy
D) None of the above
9. The vast network of computers that connects millions of people all over the world is called?
A) Web
B) Internet
C) WAN
D) LAN
10. IP Address Means?
A) Internet Protocol
B) International Pin
C) Insert Pin
D) None of the above
11. FDD Stands for?
A) Floppy Drive Detector
B) Floppy Disk Drive
C) Film Disk Drive
D) Floppy Digital Drive
12. RTOS Stands for?
A) Real Time Operating System
B) Regular Time Operating System
C) Reliable Time Operating System
D) Run Time Operating System
13. The process of restarting computer when it's already ON?
A) Booting
B) Warm Booting
C) Logging off
D) Cold Booting
14. LINUX is ________ Type of software?
A) Open Source
B) Proprietary
C) Commercial
D) System Software
15. The main purpose of encrypting a file is to?
A) Backup the data
B) Reduce the size
C) Secure it for transmission
D) None of the above
16. An Anti virus is?
A) Program
B) An application software
C) Operating System
D) Malware
17. The basic computer processing cycle consists of?
A) Hardware, Software and Storage
B) Data, Information and Application
C) Input, Processing and Output
D) System and Applications
18. Cache is?
A) Temporary Memory
B) Permanent Memory
C) Storage Device
D) None of the above
19. Which of the following is useful to transfer files and exchange messages?
A) Web browsers
B) Hypertext
C) Search engines
D) E-mail
20. A DVD is an Example of?
A) Output device
B) Hard disk
C) Optical disc
D) File
MODEL PAPER – 2
PART-B
80 Marks
Q.No. 1 (25M)
Create a MS Word Document as shows

ATMOSPHERE

TROPOSPHERE: The layer of air immediately adjacent to the earth's surface is called the troposphere. Ranging in depth from about 16 km (10 mile) over the equator to about 8 km over the poles, this zone is where most weather events occur. Due to the force of gravity and the compressibility of gases, the troposphere contains about 80% of the total mass of the atmosphere. Air temperature drops rapidly with increasing altitude in this layer, reaching about -60°C at the top of the troposphere. A sudden reversal of this temperature gradient creates a sharp boundary, the tropopause, that limits mixing between the troposphere and the upper zones.

STRATOSPHERE: The stratosphere extends from the tropopause up to about 50 km. Air temperature in this zone is stable or even increases with higher altitude. Although more dilute than the troposphere, the stratosphere has a very similar composition except two important components: water and ozone.

MESOSPHERE: Above the stratosphere, the temperature diminishes again creating the mesosphere, or the middle layer. The minimum temperature in this region is about -80°C.

a) Created Document should look like the given one.

b) Font Size for the Main Heading should be 18, Sub Heading 16 and for the remaining 14.

c) Font style will be Arial style, font bold and italic should be used appropriately.

d) Find the Word "Temperature" whenever appears in the document and Replace it with "Heat".

Q.No. 2 (15M)
Design in MS Word.
  1. Create Page no.1 in Portrait.
  2. Provide Heading "ATMOSPHERE" in page no 1 With Centre Format at Header, Font size 16 and Apply colour Dark Blue Colour for the title.
  3. Apply Banded Cover Page and Title Name should be "ATMOSPHERE" with font size 48.
  4. Insert below Table as shown below in page no 2 in Landscape.
    S.no Name of the Employee Salary Details Remarks
    1
    2
  5. Create Page 3 to 6 in Portrait.
  6. Apply Diagonal confidential water mark.
  7. Apply Page Borders and page numbers for all pages.
Q.No. 3 (20M)
Type in the following spreadsheet, and format it to look like the sample below.
Instructions:
  1. Type all the text and numbers as shown in the spreadsheet below.
  2. Centre the spreadsheet heading "Mark Sheet" Across the spreadsheet.
  3. Calculate the totals for each column using the built in function.
  4. Calculate the Difference Marks by Subtracting Total Marks Secured from the Total Marks.
  5. Calculate the Percentage for the Total Marks Secured.
  6. Apply font Colours Blue/Green, Wrap Text Wherever Applicable.
MARKS SHEET
S.no Name Of the Subject Total Marks Total Marks Secured Difference Marks Percentage
1 Telugu 150 108 42 72%
2 Hindi 125 112 13 89.6%
3 English 175 122 53 69.7%
4 Social 150 110 40 73.3%
5 Science 100 78 22 78%
6 Mathematics 120 99 21 82.5%
Total 820 629 191 76.7%
Q.No. 4 (20M)
Create Presentation PPT

Slide 1. Create a Presentation with main Heading "MARK SHEET" in first slide.

Slide 2. Prepare Bar Chart for all Subjects for all marks by using data in above question.

Slide 3. Prepare Pie Chart for all subjects and Total Marks Secured by using data in above question.

Slide 4. Thank You.

Keep Slide Number at the bottom right and provide date.