MPPEB Patwari Paper 2017 Dec 13th Second Shift – Computer Knowledge

MPPEB Patwari Paper 2017 Dec 13th Second Shift – Computer Knowledge

Which of the following option can remove the borders in MS Excel ?
(a) Press enter
(b) Choose no border
(c) Use formula
(d) Not possible in Excel

Ans – (b)

_________is the brain of computer
(a) CPU
(b) MPU
(c) GPU
(d) RAM

Ans – (a)

How does a computer get infected by virus ?
(a) When a firewall is preent
(b) When antivirus software is active
(c) When downloading unknown software from the internet
(d) When working on MS Office software in the local computer

Ans – (c)

________________is the analog standard for connecting monitors to computers
(a) Video Graphics Array (VGA) port
(b) Universal Serial Bus (USB) port
(c) Ethernet port
(d) FireWire port

Ans – (a)

In MS Excel, ______are numbered from 1 to onwards and ______are numbered from A to onwards.
(a) Columns, rows
(b) Rows, Slides
(c) Slides, rows
(d) Rows, Columns

Ans – (d)

In MS Excel, to add numeric values in Column D, from rows D10 to D15, the formula that should be used is
(a) SUM (D10,D15)
(b) COUNT (D10,D11,D12,D13,D14, D15)
(c) SUM (D10:D15)
(d) COUNT (D10, D15)

Ans – (c)

Is it possible to print an e-mail ?
(a) Yes, it is possible
(b) No, it is not possible
(c) Print option not available
(d) None of the above

Ans – (a)

What is the full form of ISP in computing terminology ?
(a) Internet System Programming
(b) Internet Service Provider
(c) Internet Sesion Plan
(d) Internet Session Programming

Ans – (b)

Where are programs and data to be used by the computer available ?
(a) Output
(b) Input
(c) Storage
(d) Processing Unit

Ans – (c)

Which of the following function key activates the spelling in MS Excel 2007?
(a) F5
(b) F7
(c) F9
(d) Shift + F7

Ans – (b)