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 is considered to measure the printing quality?

ppm

dpi

cpi

cps

10. What kind of storage device can be affected by fragmentation?

Optical

Laser

Solid-state

Magnetic

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

Titles

Lists

Charts

Animations

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

Number

Label

Character

Data/time

13. 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

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

Word.exe

Msword.exe

Word2003.exe

Windword.exe

15. 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

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

To rectify deadlock

To prevent deadlock

To detect deadlock

To solve deadlock

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

Operating system

Graphics program

Word processing

Database program

18. 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

19. Choose the correct answer

Enum variables can not be assigned new values

Enum variables can be compared

Enumeration feature increase the power of C

All of above

20. The value of an automatic variable that is declared but not initialized will be

0

Null

Garbage

None of these