NTS Past Paper Mcqs with answers

Questions from NTS Paper for the post of Computer Operator
7-Aug-2016

1) Atmospheric pressure is measured by
a.  Mercury manometer
b.  Mercury barometer
c.  Mercury galvanometer
d.  Mercury Thermometer

2) Solar Year is the time
ans : time taken by the earth to make one revolution around the sun

3) The intersection of a row and column is called :
a.   data
b.   a field.
c.   a cell
d.   an equation.

4) On an excel sheet the active cell in indicated by …
a.   A dark wide boarder
b.   A dotted border
c.   A blinking border
d.   None of above

5) Two common wildcard characters that Excel recognizes are
a.   * and ?
b.   < and >
c.   ^ and /
d.   + and -

6) There are three types of data found in a spreadsheet.
a.   data, words, numbers
b.   equations, data, numbers
c.   words, numbers, labels
d.   numbers formulas, labels

7) which of the following special function keys allow the content in cell
a.   esc
b.   shift
c.   return
d.   Tab

8) Desktop Publishing is a type of 
ans : Graphics softwares

9) VIRUS stands for
a.  Very Important Resource Under Search
b.  Virtual Information Resource Under Siege
c.  Verify Interchange Result Until Source
d.  Very Important Record User Searched

10) What symbol is used before a number to make it a label?
a. “ (quote)
b. = (equal)
c. _ (underscore)
d. ‘ (apostrophe)

11) In Excel getting data from a cell located in a different sheet is called
a.  Accessing
b.  Functioning
c.  Updating
d.  Referenceing

12) In Excel Tab scrolling button
a.  Allow to view additional worksheet columns to the right
b.  Allow you to view additional worksheet rows down
c.  Allow you to view additional sheets tabs
d.  Allow you to view a different worksheet

13) How many characters can be typed in a single cell in Excel?
a. 256
b. 1024
c. 32,000
d. 65,535

14) A typical worksheet has …. Number of columns
a. 128
b. 256
c. 512
d. 1024

15) The brain of any computer system is
A) ALU
B) Memory
C) CPU
D) Control unit

16) The arranging of data in a logical sequence is called
A) Sorting
B) Classifying
C) Reproducing
D) Summarizing

17) 1 KB is equal to
ans 1024 bytes

18) Which one is not a hardware component
a. USB
b. Compiler
c. Track ball
d. Plotter

19) What hardware device is essential for connecting a computer with internet using telephone line?
a.  Modem
b.  Ethernet card
c.  VGA Card
d.  Internet connection

20) Which one can store more data than any other device in the list?
a.  CD
b.  DVD
c.  Zip Disc
d.  Floppy Disk

21) IQ test: complete the series