cpct previous paper 22nd_April_2018_Shift 2

1)  Which  of the following is not a part of slide design?
A)    Design Template
B)    Colour Scheme
C)    Animation Scheme
D)    Slide Show
Ans:- D) Slide Show

2) Which of the following is used to represent data in grid of rows and columns?
A)    Header
B)    Footer
C)    Paragraph
D)    Tables
Ans:- D) Tables

3) ISP Stands for ……………
Ans:- Internet Service Provider

4) Which of the following follows last in first out (LIFO) storage policy?
A)    Queue
B)    RAM
C)    Stack
D)    Both stack and queue
Ans:- C) Stack

5) A  user can get files from another computer on the internet by using which protocol?
A)    FTP
B)    HTTP
C)    UTP
D)    TCP
Ans:- A) FTP

6) Which of the following devices is required for an internet connection?
A)    BIOS
B)    NIC Card
C)    CD Drive
D)    Joystick
Ans:- B) NIC Card
7) …………. The computer opens your user account and makes the computer available for use.
A)    Logging on to
B)    Registering on
C)    Signing up on
D)    Enrolling on
Ans:- A) Logging on to

8) Portrait and Landscape are ……………………. Options in MS Word.
A)    Page Orientation
B)    Paper Size
C)    Page Margins
D)    Page Border
Ans:- A) Page Orientation

9) Which of th following operators has relatively the highest precedence?
A)    Subtraction(-)
B)    Addition(+)
C)    Division(/)
D)    Both addition and subtraction
Ans:- C) Division(/)

10) To create an interactive pivot table for the web , a microsoft office web component called _________ is used.
1.    Html
2.    Chart
3.    Sort
4.    Pivot table report
Ans. Pivot table report

11) In MS PowerPoint, the ………… option controls the speed of a transition effect.
A)    Duration
B)    Sound
C)    Time
D)    Speed
Ans:- A) Duration

12) …………….. translate(s) the processed information from the computer into a form that humans can understand.
A)    Input devices
B)    Output devices
C)    Utilities
D)    Software
Ans:- B) Output devices

13) On a hard disk, a …………… runs through each track of a stack of platters
A)    Magnetic charge
B)    Cylinder
C)    Head
D)    Sector
Ans:B) Cylinder

14) 1 kilobyte = ……………………… bytes
A)    100 bytes
B)    1024 bytes
C)    1024 bits
D)    1024 nibbles
Ans:- B) 1024 bytes

15) Which of the following are output devices?
A)    Monitor and printer
B)    Floppy disk and CD
C)    Keyword and mouse
D)    Windows 2000 and Windows Nt
Ans:- A) Monitor and printer

16) Which of the following is the built in memory of a computer, also known as the primary memory?
A)    DVD
B)    CD
C)    RAM
D)    Hard Disk
Ans:- C) RAM

17) The first high-level computer language developed for programming was ………………
A)    COBOL
B)    FORTRAN
C)    C
D)    C++
Ans:- B) FORTRAN

18) Two or  more computers connected to each other for sharing information is called ……………
A)    A network
B)    A route
C)    A server
D)    A tunnel
Ans:- A)  A Network

19) Coded entries used to gain access to a computer system are called ……………
A)    Entry codes
B)    Passwords
C)    Security commands
D)    Code words
Ans:- B) Passwords

20) To save an existing file with a new name at a new location, the ………….. command is used.
A)    Save
B)    Close
C)    Save As
D)    Open
Ans: C) Save As

21) In a database, ……………… fields store numbers used to perform calculations.
A)    Next
B)    Key
C)    Alphanumeric
D)    Numeric
Ans:- D) Numeric

22) What is the function of a control unit in a CPU?
A)    To transfer data to primary storage
B)    To store program instructions
C)    To perform logic functions
D)    To decode program instructions
Ans:- D) To decode program instructions

23) ………………… is an application program that helps the user to change any number and immediately see the result of that change.
A)    Desktop publishing program
B)    Database
C)    Spreadsheet
D)    PowerPoint
Ans:- C) Spreadsheet

24) How do you select an entire column is MS Excel?
A)    Select Home Tab of Font group
B)    Click the column heading letter
C)    Hold down the shift key as you click anywhere in the column
D)    Hold down the Ctrl key as you click anywhere in the column
Ans:- B) Click the column heading letter

25) Which of the following is a telecommunications hardware that allows you to access the web?
A)    Browser
B)    Modem
C)    FTP Protocol
D)    IRD
Ans:- B) Modem

26) What is the term used when you press and hold the left mouse key and move the mouse around a slide?
A)    Highlighting
B)    Dragging
C)    Selecting
D)    Pointing
Ans:- B) Dragging

27) Numbers entered into an excel cell are automatically…………………..
A)    Left aligned
B)    Right aligned
C)    Centre aligned
D)    Justified
Ans:- B) Right Aligned

28) An e-mail message can be protected by:
A)    Mirroring
B)    Caching
C)    Encryption
D)    Resending
Ans:- C) Encryption

29) Which of the following is a boot firmware program on a PC?
A)    NIC Card
B)    Hard Disk
C)    Cache
D)    BIOS
Ans: D) BIOS

30) Which of the following is not an output device?
A)    Plotter
B)    Printer
C)    MICR
D)    CRT Monitor
Ans:- C) MICR

31) To Protect a computer from viruses, ………… software can be installed on the computer.
A)    Backup
B)    LinkedIn
C)    Skype
D)    Antivirus
Ans:- D) Antivirus

32) Which of the following key combinations can be used to select an entire document?
A)    Ctrl+A
B)    Alt+F5
C)    Shift+A
D)    Ctrl+K
Ans:- A) Ctrl+A

33) A …… contains buttons and menu that provide quick access to commonly used commands.
A)    Task bar
B)    Menu bar
C)    Navigation bar
D)    Status bar
Ans:- B) Menu bar
TFT LCD Stand For:
Ans:- Thin-Film Transistor  Liquid- Crystal Display

34) Overheating of CPUs many result in:
A)    Virus infection
B)    Stack Overflow
C)    PC lockup after sometime
D)    PC Shutdown
Ans:- D) PC Shutdown

35) Computer files are infected due to the presence of:
A)    Icons of desktop
B)    Fragmented files
C)    Viruses
D)    Multiple operating systems
Ans:- C) Viruses

36) …………… is used for voice communication over IP networks
A)    VoIP
B)    SMTP
C)    TCP/IP
D)    POP
Ans:- A) VoIP

37) Which of the following files formats is used to save DVD Video Object files?
A)    Dvoj
B)    Vob
C)    Vobj
D)    Dvij
Ans:- B) vob

38) What is the shortcut key combination to add a previous sheet to a current selection of sheets in an OpenOffice Calc?
A)    Page Up
B)    Ctrl+ Page Up
C)    Shift + Ctrl+ Page Up
D)    Shift + Page Up
Ans:= C) Shift+ Ctrl+ Page Up

39) Which of the following devices has a small hard rubber ball underneath it that moves against two rollers as it passes across a flat surface?
A)    Mechanical mouse
B)    Scanner
C)    Optical mouse
D)    Plotter
Ans:- A) Mechanical Mouse

40) Which of the following is NOT a Financial funcation in MS Excel?
A)    FV()
B)    NPV()
C)    SUM()
D)    PMT()
Ans:- C) SUM()

41) Which of the following is not a text function in MS Excel?
A)    CHAR()
B)    LEN()
C)    VAR()
D)    ABS()
Ans: D) ABS()

42) The Decimal equivalent of the binary number(1001.0010)2 is ……………..
A)    19.125
B)    9.5
C)    9.25
D)    9.125
Ans:- D) 9.125

43) Power Point shortcut key to initiate slide show is :
A)    Ctrl+V
B)    Ctrl+S
C)    F2
D)    F5
Ans:- D) F5