1. In MS-Excel, ‘#Name?’ error occurs when –

Function name is wrong

Argument is wrong

Cell reference is invalid

All of the above

2. What will be the result of the formula =Min (Average (B1, B2), Product (B3:B4)) where value of B1=20, B2=24, B3=15, B4=20?

20

22

300

None of the above

3. In MS-Word, which of the following shortcut keys are used for aligning text to center?

Ctrl+M

Ctrl+C

Ctrl+E

None of the above

4. What is the meaning of ‘BCC’ in an email?

Blind Carbon Copy

Blind Close Copy

Bearer Carbon Copy

Blind Close Contact

5. What is the name given to the sequence of steps which a computer follows?

Instructions

Algorithm

Flowcharts

Software

6. Which of the following tools is used in business intelligence?

OLAP

Data Mining

Web Mining

All of these

7. Webcam is a type of _ device in a computer system.

System

Analogue

Input

Output

8. Which of the following commands is given to invoke ‘Task Manager’?

Ctrl+Alt+Del

Ctrl+Alt+F4

Ctrl+Del+F12

Alt+Del+F4

9. Which of the following section does not exist in a slide layout?|Janata Bank|Rupali Bank|Officer (General)-2019

Titles

Lists

Charts

Animations

10. Which of the following is not a valid data type is excel?|Janata Bank|Rupali Bank|Officer (General)-2019

Number

Label

Character

Data/time

11. Which of the following is not available the rules of ms word screen?|Janata Bank|Rupali Bank|Officer (General)-2019

Center indent

Tap stop box

Left indent

Right indent

12. Which file starts ms word?|Janata Bank|Rupali Bank|Officer (General)-2019

Word.exe

Msword.exe

Word2003.exe

Windword.exe

13. Which of the following is not essential component to perform is mail merge operation?|Janata Bank|Rupali Bank|Officer (General)-2019

Main document

Data source

Word fields

Merge fields

14. The bankers algorithm is used__|Janata Bank|Rupali Bank|Officer (General)-2019

To rectify deadlock

To prevent deadlock

To detect deadlock

To solve deadlock

15. Microsoft windows is a(n)__|Janata Bank|Rupali Bank|Officer (General)-2019

Operating system

Graphics program

Word processing

Database program

16. Which of the following are loaded in safe mode?|Janata Bank|Rupali Bank|Officer (General)-2019

Keyboard driver

Mouse driver

VGA driver

All of these

17. In the CPU, the .............unit control resources in the computer. (City Bank Ltd. Probationary Officer:11)

Commad

Arithmetic Logic

Memory

Control

18. Which one is not a part of CPU? ( Agrani Bank ltd. Offier:10)

Artithemetic Unit

Logic Unit

Resister

Memory

19. কম্পিউটার কেন্দ্রীয় প্রত্রিুয়াকরণ অংশ গঠিত --

গ্রহন মুখ ও নিয়ন্ত্রয়ণ অংশের সমন্বয়ে

স্মৃতি ও যুক্তি বর্তনী অংশের সমন্বয়ে

অ্ভ্যন্তরীণ স্মৃতি নিয়ন্ত্রয়ণ অংশের সমন্বয়ে

অ্ভ্যন্তরীণ স্মৃতি , গানিতকি যুক্তি অংশ ও নিয়ন্ত্রণ অংশের সমন্বয়ে

20. All the logical and mathematical calculations done by the computer happen in/on the--

Motherboard

memory

Hard Disk

CPU