Job Solution - তথ্য প্রযুক্তি - Page 26 - Prothom Sir

1.

In Bangladesh , BTRC provides bandwidth of internet services through submarine cable network . Which of the following submarine cable networks is connected with Bangladesh ?

Southern Cross Cable

SEA-ME-WE

C2C North Ring

FLAG

Southern Cross Cable

SEA-ME-WE

C2C North Ring

FLAG

2.

Suppose the value of cell E5 in MS-Excel sheetis 3500. If we apply the formula = IF ( E5 < 20000,E5 * 10%, E5 * 20%) , what will be the result ?

700

350

৩৫০০

500

700

350

৩৫০০

500

3.

To display one line in multiple cell you will have to select

Merge cells check box

Wrap text check box

Shrink to fit check box

None of these

Merge cells check box

Wrap text check box

Shrink to fit check box

None of these

4.

To find the average value of A1, A2, A3, which of the following is not a correct formula ?

= Sum (A1 : A3)/3

= (A1 : A3)/3

= (A1-A2+A3)/3

= Average (A1:A3)

= Sum (A1 : A3)/3

= (A1 : A3)/3

= (A1-A2+A3)/3

= Average (A1:A3)

5.

Suppose cells A5 and B5 contain the values 35,000 and 100 respectively . In cell C5, if you apply the formula = IF (A5 <> 20000, B5 * 10%,B5 * 20%), what will be the result in C5 ?

20

7,000

৩,৫০০

১০

20

7,000

৩,৫০০

১০

6.

What will be the result of the formula = Max (Average (B1, B2), Product (B3 : B4)) where the value of B1 = 26, B2 =30, B3 =12 and B4 2

২৮

24

26

672

২৮

24

26

672

7.

To find a document file that starts with "N" ,which one of the following is the correct search option ?

*.*

*.doc

N.doc

N*.doc

*.*

*.doc

N.doc

N*.doc

8.

Which of the following symptom does not indicate that your computer system is affected by Virus ?

Takes much time to load a program

Disk access time is faster

Gives abnormal error message

Inadequacy in system memory

Takes much time to load a program

Disk access time is faster

Gives abnormal error message

Inadequacy in system memory

9.

Which of the following technology is used by Bluetooth operations ?

magnetic

Optical

Radio Frequency

LASER

magnetic

Optical

Radio Frequency

LASER

10.

Which of the items below are considered removable storage media ?

Removable hard disk cartridges

(Magneto-optical) disk

Flexible disks cartridges

All of them

Removable hard disk cartridges

(Magneto-optical) disk

Flexible disks cartridges

All of them

11.

Which of the following is not a form of data ?

numbers and characters

images

Sound

none of them

numbers and characters

images

Sound

none of them

12.

The control unit of a microprocessor

stores data in the memory

accepts input data from keyboard

performs arithmetic/logic function

none of them

stores data in the memory

accepts input data from keyboard

performs arithmetic/logic function

none of them

13.

Which of the following is internal memory ?

Disks

Pen Drives

RAM

CDs

Disks

Pen Drives

RAM

CDs

14.

On which aspect the analog computers are better than digital ?

Speed

Accuracy

Reliability

automatic

Speed

Accuracy

Reliability

automatic

15.

How many numbers could ENIAC store in its internal memory ?

100

20

80

40

100

20

80

40

16.

Binary circuit elements have

One stable state

Two stable state

Three stable state

none of them

One stable state

Two stable state

Three stable state

none of them

17.

Which of the following is used for manufacturing chips ?

Control bus

Control Unit

Parity unit

Semiconductor

Control bus

Control Unit

Parity unit

Semiconductor

18.

Which of the following terms is the most closely related to main memory ?

Non volatile

Permanent

Control Unit

Temporary

Non volatile

Permanent

Control Unit

Temporary

19.

The word length of a computer is measured in

Bytes

Millimeters

meters

Bits

Bytes

Millimeters

meters

Bits

20.

Which unit holds data permanently ?

Input unit

Secondary unit

Output unit

Primary Memory unit

Input unit

Secondary unit

Output unit

Primary Memory unit