UTKARSH BANGLA BHIMPUR CENTRE

Free Cost Training Center

BHIMPUR, NADIA , Ph - 7407272725, 9735157325

1. How to remove borders applied in Cells?

(A) Select None on Border tab of Format cells
(B) Open the list on Border tool in Format Cell toolbar then choose first tool (none)
(C) Both of above
(D) None of above
Answer: Option D
2. ___ is not a valid data type in MS-Excel.
(A) Number
(B) Character
(C) Label
(D) Date/ Time
Answer: Option B
3. What is MS Excel?
(A) Spreadsheet
(B) Database Management
(C) Presentation
(D) Workbook
Answer: Option A
4. What is the row limit of MS Excel 2019?
(A) 4,81,0576
(B) 1,048,576
(C) 1,57,648
(D) 1,63, 84
Answer: Option B
5. In Microsoft Excel spreadsheets, rows are designated as ___.
(A) 1, 2, 3, ....
(B) A, B, C, ....
(C) A1, B1, C1, ....
(D) I, II, III, ....
Answer: Option A
6.___ logical function indicates TRUE only if all arguments are assessed as TRUE, and FALSE otherwise.
(A) OR (B) AND (C) IF (D) ANDIF Answer: Option B
7. The intersection of a column and a row in a worksheet is called__
(A) Column
(B) Address
(C) Value
(D) Cell
Answer: Option D
8. The Greater Than sign (>) exemplifies a/an ___ operator.
(A) Arithmetic
(B) Conditional
(C) Logical
(D) Greater
Answer: Option C
9. __ is the correct syntax of IF() Function.
(A) =IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))
(B) =IF (logical_test, [value_if_true], [value_if_false])
(C) =IF (logical_test, {[value_if_true]}, {[value_if_false]})
(D) =IF (logical_test: [value_if_true], [value_if_false])
Answer: Option B
10. ___is the function used to match multiple values and returns the first match in Windows/Mac
(Applies only if you have a valid Microsoft 365 Subscription).
(A) IF()
(B) IFS()
(C) IIF()
(D) SWITCH()
Answer: Option D
11. __ type of chart is good for a single series of data.
(A) Column chart
(B) Cone chart
(C) Line chart
(D) Pie chart
Answer: Option D
12. What do Excel formulas start with?
(A) / (B) f (C) = (D) .– Answer: Option C
13. Name the keyboard shortcut to use to switch between open Excel windows.
(A) CTRL + TAB
(B) ALT + TAB
(C) CTRL + ALT + TAB
(D) None of the above
Answer: Option A
14. Name the keyboard shortcut used to copy the value from the cell above the active cell into the cell or
the Formula Bar in MS Excel__.
(A) CTRL + SHIFT + C
(B) CTRL + SHIFT + "
(C) ALT + SHIFT + "
(D) CTRL + ALT + "
Answer: Option B
1. What is an Excel feature that displays only the data in column (s) according to specified criteria?
(A) Filtering
(B) Sorting
(C) Formula
(D) Pivot
Answer: Option A
16. __ is not a function in Excel.
(A) SUM
(B) MIN
(C) SUBTRACT
(D) MAX
Answer: Option C
17. ___ Excel function returns TRUE or FALSE based on two or more conditions
(A) =AVERAGEIFS
(B) =CONCAT
(C) =COUNTA
(D) =AND
Answer: Option D
18. Why is the =COUNTIF function in Excel used?
(A) Counts cells as specified
(B) Counts blank cells in a range
(C) Counts cells with numbers in a range
(D) Returns values based on a TRUE or FALSE condition
Answer: Option A
19. What is the =NPV in Excel used for?
Ans, The NPV function is used to calculate the Net Present Value (NPV).
20. Which Excel function removes irregular spacing, leaving one space between each value?
Ans, The =TRIM function in Excel is used to remove irregular spacing, leaving one space between each
value.
21. Which are the two ways to access the styling commands in Excel?
Ans, First Way - The Ribbon
Second Way - Formatting menu, by right clicking cells
22. What is the COUNT() function in Excel normally used for?
Ans, The COUNT() is generally used to count a range of cells containing numbers or dates excluding blank
cells and text.
23. For what is the $ symbol used along with the cell address in Excel?
Ans, The $ symbol is used to specify the fixed columns or rows in the formula.
24. What happens when you click on CTRL + X after selecting some cells in Excel?
(A) The cell content of selected cells disappear from cell and stored in clipboard
(B) Value in the cells selected are marked for cutting
(C) The selected cells are deleted and the cells are shifted left
(D) The selected cells are deleted and cells are shifted up
Answer: Option B
25. _ is the programming language used to write a Macro in MS Excel.
(A) Visual basic
(B) C+
(C) Java
(D C++
Answer: Option A
26. Why is the “wrap text” feature used in MS Excel?
The 'Wrap Text' function in MS Excel is used to break down lengthy text into multiple lines by increasing
the row height, ensuring complete visibility of the content.
27. In MS Excel, the keyboard shortcut “Ctrl+S” can be used to___
(A) Save As
(B) Save
(C) Start new workbook
(D) Switch between opened tabs
Answer: Option B
28. Which keyboard shortcut is used to easily switch open workbooks?
(A) Alt+S
(B) CTRL+S
(C) CTRL+Alt
(D) CTRL+Tab
Answer: Option D
29. __ happens when you select a cell in MS Excel and type “=B25”
(A) Selected cell will show an error message
(B) Selected cell will show “=B24”
(C) Selected cell will show the same value as in B25
(D) Selected cell will be blank
Answer: Option C
30. Microsoft word is __ software.
(A) Application
(B) Compiler
(C) System
(D) Programming
Answer: A
31. Which is not in MS Word?
(A) Italic
(B) Magic tool
(C) Font
(D) Bold
Answer (B)
32.__ cannot be used to work in MS Office.
(A) Joystick
(B) Scanner
(C) Light Pen
(D) Mouse
Answer (A)
33. Which is not an edition of MS Word?
(A) MS Word 2003 (B) MS Word 2007
(C ) MS Word 2010 (D) MS Word 1020 Answer (D)
34. The _ works with the standard Copy and Paste commands.
(A) View tab
(B) Paragraph dialog box
(C) Office Clipboard
(D) All of these
Answer (C)
35. What is the blank space outside the printing area on a page?
(A) Clipart
(B) Margins
(C) Header
(D) Footer
Answer (B)
36. Which of the following is an example of page orientation?
(A) Landscape
(B) Subscript
(C) Superscript
(D) A4
Answer (A)
37. Formatting is performed on
(A) Text
(B) Table
(C) Menu
(D) Both (a) and (b)
Answer (D)
38. Which of the following software is used for making a resume?
(A) MS Excel
(B) MS Word
(C) Dev C
(D) Java
Answer (B)
39. Press __ to open the help window in the MS Word document.
(A) F1 (B) F2
(C) F9 (D) F11 Answer (A)
40. The ability to combine name and addresses with a standard document is called ____
(A) Document formatting
(B) Database management
(C) Mail merge
(D) Form letters
Answer (C)
41. Which enables us to send the same letter to different people?
(A) Macros
(B) Template
(C) Mail merge
(D) None of above
Answer (C)
42. A word processor would most likely be used to
(A) Keep an account of money spent
(B) Do a computer search in media Center
(C) Maintain an inventory
(D) Type a biography
Answer (D)
43. What is gutter margin?
(A) Margin that is added to the left margin when printing
(B) Margin that is added to the right margin when printing
(C) Margin that is added to the binding side of the page when printing
(D) Margin that is added to the outside of the page when printing
Answer (C)
44. Which can be used for quick access to commonly used commands and tools?
(A) Status bar
(B) Toolbar
(C) Menu bar
(D) Title bar
Answer (B)
45.Which bar shows the current position as far as the text goes?
(A) Title bar
(B) Menu bar
(C) Scroll bar
(D) Status bar
Answer (D)
46. Select all the text in MS Word document by
(A) Ctrl +S
(B) Ctrl + 1
(C) Ctrl + A
(D) Ctrl + V
Answer (B)
47. __ is not a part of a MS Word document.
(A) Quick access toolbar
(B) Start Menu button
(C) Home panel
(D) View option
Answer (D)
48. The name of a word document displays in __.
(A) Ribbon
(B) Title bar
(C) Status bar
(D) Home tab
Answer (D)
49. Each line represents how many letters in WordStar?
(A) 20 (B) 35 (C) 65 (D) 75
Answer (C)
50. Which of the following are word processing software?
(A) WordPerfect
(B) Word Pad
(C) MS Word
(D) All of above
Answer (D)
51. Which file starts with MS Word?
(A) Winword.exe
(B) Word.exe
(C) Msword.exe
(D) Word356.exe
Answer (A)
52. Ctrl + N is used to
(A) Save the Document
(B) Open the Document
(C) Create a New Document
(D) Close the Document
Answer (C)
53. To exit from the Resume Wizard and return to the document window without creating a resume, click
the ____ button in any panel in the Resume Wizard dialog box.
(A) Cancel
(B) Back
(C) Next
(D) Finish Answer (D)
54. What are inserted as cross-reference in Word?
(A) Placeholders
(B) Bookmarks
(C) Objects
(D) Word fields
Answer (D)
55. Which of the following is a spreadsheet software?
A. MS Word
B. MS PowerPoint
C. MS Excel
D. MS Access

56. Which of the following is an example of database designing software?

A. Libra office base
B. MS PowerPoint
C. MS Excel
D. MS Word

57. Libra Office writer is a

A. Spreadsheet
B. Presentation
C. Digital Documentation
D. None of these

58. Full form of DBMS is …………………..

A. Database Management System
B. Database Minor System
C. Digits base Management system
D. None of these
59. Short cut key of replace is …………………….?
A. Ctrl+h
B. Ctrl+c
C. Ctrl+k
D. Ctrl+r

60.Full form of E-mail is …………

A. Electrical mail
B. Electronic mail
C. Electric mail
B. Both a & b

61. Libra Office Clac is a ……….. software?

A. Spreadsheet
B. Presentation
C. Digital Documentation
D. None of these

62“ Query” this word related with ........... Software?

A. DBMS
B. Presenation
C. Spreadsheet
D. None of these

63.The shortcut key of center alignment is ……………….?

A. Ctrl+h
B. Ctrl+E
C. Ctrl+k
D. Ctrl+r
64. Mouse is a ……………………………………..
A. Storage device
B. Output device
C. Input Device
D. Part of CU
65.My computer can bring up the "Icon" on the desktop
A. From Display Properties
B. From Explorer
C. From Wallpaper
D. From Settings
66. We get table option from …………………… menu?
A. File
B. Insert
C.Tools
D. Edit
67. The term Google Chrome is used for………..
A. Drawing
B. Web page viewing
C. Watching a movie
D. Listening to music

68. We get macro option from …………… menu?

A. File
B. View
C. Tools
D. Edit

70. Which position the install of CPU in computer system

A. Cabinet
B. Monitor
C. Motherboard
D. RAM
71. Libra Office base a software?
A. Spreadsheet
B. Presentation
C. Digital Documentation
D. DBMS
72. Which of the following software can be used for presentation?
A. MS Access
B. MS PowerPoint
C. MS Excel
D. MS Word

73. Which is example of Database Designing software?

A. Libra office base
B. MS PowerPoint
C. MS Excel
D. MS Word

74. 1 MB equal to ……………….

A. 1000 KB
B. 1024 KB
C. 100 KB
D. 1024 GB

75. Scanner is a ……………………………………..

A. Storage device
B. Output device
C. Input Device
D. Part of CU
76. 75. Microphone is a ……………………………………..
A. Storage device
B. Output device
C. Input Device
D. Part of CU
77. Printer is a ……………………………………..
A. Storage device
B. Output device
C. Input Device
D. Part of CU

78. Full form of CPU is ………… Central Processing Unit

79. Full form of CU is …………Control Unit

80. Full form of WWW is ………… World Wide Web

81. . Full form of HTML is …………Hyper Text Markup Language

82. . Full form of RAM is ………… Random Access Memory

83. . Full form of ROM is ………… Read-Only Memory

84. . Full form of UPS is ………… Uninterruptible Power Supply

85. Full form of HDD is ………… Hard Disk Drive

86 . Full form of PC is ………… Personal computer.

87. We get Hyperlink option from …………………… menu?
A. File
B. Insert
C.Tools
D. Edit
88. We get Symbol option from …………………… menu?
A. File
B. Insert
C.Tools
D. Edit
89. We get Watermark option from …………………… menu?
A. File
B. Insert
C.Tools
D. Design
90. We get Orientation option from …………………… menu?
A. Page layout
B. Insert
C.Tools
D. Desgn
91. The shortcut key of Bold is ……………….?
A. Ctrl+h
B. Ctrl+b
C. Ctrl+t
D. Ctrl+r
92. The shortcut key of New Slide is ……………….?
A. Ctrl+n
B. Ctrl+m
C. Ctrl+k
D. Ctrl+r
93. The shortcut key of Paste is ……………….?
A. Ctrl+h
B. Ctrl+v
C. Ctrl+k
D. Ctrl+p
94. CRM software example is …………………………….?
A. HubSpot
B. Scoro CRM
C. Tesco CRM
D. All of these
95. Mail Merge can be done with the following ……………………… software?
A. Database
B. Spreadsheet
C.Word processor
D. Presentation
96. The full form of BCC is ……………………………………………….?
A. Bounded calla customer
B. Board of customer calls
C. Blind Carbon Copy
D. None of these
97.The full form of CC is ……………………………………………….?
A. Calla customer
B. Customer calls
C. Carton Copy
D. Carbon Copy\

98. What is 1110101 Binary in Decimal ?

A. 111
B. 120
C.117
D.121

99.Decimal Base is
A. 02
B. 09
C. 10
D. 11

100, In binary Addition, 1+1= ……………?

A. 0
B. 2
C. 10
D. 11
Q1. Managing Health and safety means
A. Protect Health
B. Control Hazard
C. Prevent accident
D. All the options are correct

Q2. Basic safety rules to follow at workplace include

A. Electrical Safety
B. Fire Safety
C. Use of First Aid
D. All the options are correct

Q3. Damaged and dangerous electrical equipment should be removed

A. One time in a month
 B. One time in a year
C. Immediately
D. No need to replaced

Q4. In an organization Health & Safety policy must be maintained by

A. Only head of the Organization
B. Only managerial staff of the organization
C. Only worker of the organization
D. All members of the organization

Q5. A Data Entry Operator should have

A. Technical skill..
B. Management skill
C. Both A and B.
D. None of these
Q6. Some performance parameters are
A. Technical knowledge
B. Self-management.
C. People development.
D. All of these
Q7. Planning objectives are linked with--
A. Service objectives
B. Marketing objectives
C. Test
D. Meriteais objects
Q8. Technical knowledge helps----
A. To keep the work area clean and tidy
B. To identify and refer anomalies in data
C. To know organization’s policies
D. All of these

Q9. On a Monday morning, you enter the office and see that there is a lot of litter on the
office floor. What will be the most appropriate response?

A. Ignore the litter and do your job

B. Scold the cleaner for not doing his job
C. Call the cleaner and ask him to clean the office immediately and warn him not to repeat
such Mistakes
D. Clean the office by yourself

Q10. Technical Knowledge helps

A. To keep the work area clean and tidy
B. To identify and refer anomalies in data
C. To know organization’s policies
D. All of these
Q11. Which of the following is a self-management skill
A. Rational abilit..
B. Personal quality
C. Both A & B / A
 D. None of these
Q12. A data entry operator should be able to--
A. The use of resources correctly and efficiently
B. Work within the limits of the job role
C. Utilize the time effectively
D. All of these
Q13. Customer Centricity means—
A. Seek clarification on problems from others
B. Deliver consistent and reliable service to customers
C. Provide relevant information to others
D. None of these
Q14. The responsibility of a data entry operator--
A. Entering account or customer data from documents
B. Complying with data entry deadlines
C. Sorting data information to prepare for computer entry
D. All of These
Q15. At the time of fire
A. Always use elevators to escape
B. Always use stairs in emergencies to escape
C. Jump from the top floor
D. Wait for other’s help

Q16. Planning objectives are linked with

A. Service objectives
B. Marketing objectives
C. Testing
D. Materials objectives
Q17. Every problem has a ________
A. Root
B. Lifespan
C. Opportunity
D. All of these
Q18. "Of all the following jobs what would be the correct order of priority for an office
employee? I.Work on a new assignment that your boss has given you to complete in 3 days.
II. Complete a report which is due in 4 hours. III. Work on a monthly report that is to be
discussed in a week.--- "
A. I - II – III
B. III - II – I
C. I - III – II
D. II - I – III
Q19. "Among the following points what should an office employee follow to ensure tidiness
around his/her work area? I. Establish daily, weekly and monthly cleaning procedures. II.
Implement a paperrecycling program. III. Have snacks and refreshments at the workspace.--
-- "
A. Only (I)
B. Only (I) and (II)
 C. Only (II) and (III)
D. All (I), (II) and (III)

Q20. On a Monday morning, you enter the office and see that there is a lot of litter on the
office floor.What will be the most appropriate response?---
Ignore the litter and do your job
A. Scold the cleaner for not doing his job
B. Scold the cleaner for not doing his job
C. Call the cleaner and ask him to clean the office immediately and warn him not to repeat
such mistakes
D. Clean the office by yourself

Q21. The resources of manage a work to meet requirements---

A. equipment
B. materials and information
C. All of these
B. None of these

Q22. Customer Centricity means--

A. Seek clarification on problems from others
B. Deliver consistent and reliable service to customers
C. Provide Relevant information to others
D. All of These

Q23. The data entry operator should have the knowledge of ---
A. The organization’ s policies, procedures and priorities for the area of work
B. How to entertain other staffs
C. All of these
D. None of these
Q24. Team working refers to --
A. work effective.ly in a team environment
B. Disrupting the work of colleagues
C. Not helping other colleagues
D. All of these

Q25. Which of the following shows your ability to participate as a member of a team---
A. Interpersonal Skill
B. Communication Skill
C. None of these
D. All of these

Q26. Data entry is important for business

A. Information can be stored properly
B. It can help increase productivity
C. This can help reduce infrastructure costs
D. All of the above
Q27. CRM full name is ………………………?
A. Customer Relationship Manager
B. Customer Relationship Management
C. Custom Relationship Manager
 D. Custom Relationship Manager

Q28. Outbounded calls are:

A. When call are made and received from outside the country
B. When calls are received from customers
C. When call are made and received from within the country
D. When call are made to customers

Q29. How can we deal effectively with customers?

A. After purchase, convince the customer to buy more
B. Pursue customer to buy a product
C. Take your time to approach the customer
D. Develop the knowledge of merchandise being sold

Q30. Self management is

A. Manage yourself
B. Manageing others
C. First manage the self and then manage others
D. None of these

Q31. Planning objectives are linked with

A. Service objectives
B. Marketing objectives
C. Testing
D. Materials objectives

Q32. A competent data entry operator should have

A. Core Skills
B. Professional
C. Technical Skills
D. All of These

Q33. Professional design is

A. Standardization of work
B. Standardization of Skills
C. Standardization of Performance goals
D. Quick design with time-based urgency

Q34. Among the following points what should an office employee follow to ensure tidiness
around his/her work area? I. Establish daily, weekly and monthly cleaning procedures. II.
Implement a paper recycling program. III. Have snacks and refreshments at the workspace.
A. Only (I)
B. Only (I) and (II)
C. Only (II) and (III)
D. All (I), (II) and (III)

Q34. Which is wrong option- the individual working on the job must be able to
A. Establish and agree the work requirements with appropriate people
B. Not necessary to immediate work area clean and tidy
C. Utilize the time effectively
D. none of the option is wrong

Q35. For healthy environment, workplace should

 A. Provide insufficient space for the employee to alter position comfortably
B. Provide inadequate lighting
C. Provide sufficient space and adequate light
D. A & B both

Q36. Bullying at work and dealing with aggressive behavior is comes under
A. Chemical hazards
B. Biological hazards
C. Psychological hazards
D. Physical

Q37. There are nine different hazardous materials warning labels. What does a class 8 label
represent?
A. Corrosive
B. Flammable and combustible liquid
C. Poison and poison inhalation hazard
D. Explosive

Q38. An incident can be called hazardous only when

A. Stressor has the potential to cause harm to humans and ecological systems
B. Poses threat to surrounding
C. Monitoring is failed
D. Outburst of chemicals

Q39. Safety rules should be clearly displayed

A. At all important places
B. Out of office only
C. Only in front of manager room
D. No need to show up at work

Q40. How can we deal effectively with customers?

A. After purchase, convince the customer to buy more
B. Pursue customer to buy a product
C. Take your time to approach the customer
D. Develop the knowledge of merchandise being sold

Q41. Technical Knowledge helps

A. To keep the work area clean and tidy
B. To identify and refer anomalies in data
C. To know organization’s policies
D. All of these

Q42. Customer Centricity means

A. Seek clarification on problems from others
B. Deliver consistent and reliable service to customers
C. Provide relevant information to others
D. None of these

Q43. The data entry operator should have the knowledge of

A. The organization’s policies, procedures and priorities for the area of work
B. How to entertain other staffs
C. All of these
D. None of these
Q44. Team working refers to
A. work effectively in a team environment
B. Disrupting the work of colleagues
C. Not helping other colleagues
D. All of these

Q45. For healthy environment, workplace should

A. Provide insufficient space for the employee to alter position comfortably
B. Provide inadequate lighting
C. Provide sufficient space and adequate light
D. A & B both

Q46. The colour coding of water type fire extinguisher is

A. Blue
B. Green
C. Red
D. Yellow

Q47. The colour of CO2 fire extinguisher is

A. Blue
B. Black
C. Red
D. Green

Q48. Plastic bags should be avoided at work place, because

A. These cause hazards
B. These are harmful for healthier environment
C. These are good for healthier environment
D. Option A & B

Q49. What is RACE Method

A. RESCUE AIM CONFINE EXTINGUISH
B. RESCUE ALARM CONFINE EXTINGUISH
C. RESCUE AIM COMBINED EXTINGUISH
D. RESCUE ALARM COMBINED EXTINGUISH

50. An incident can be called hazardous only when

A. Stressor has the potential to cause harm to humans and ecological systems
B. Poses threat to surrounding
C. Monitoring is failed
D. Outburst of chemicals