MAHARISHI VIDYA MANDIR

INFORMATION TECHNOLOGY (402) - MCQ’S

1. Which of the following features in LibreOffice Writer is/are used to create the
given document?
(a) Page borders (b) Envelope
(c) Picture from File (d) Indexes and Tables
2. Styles menu (from sidebar) in Writer provide options to work on
(a) Paragraph Styles (b) Frame Styles
(c) Page Styles (d) All of the above
3. What is style template in LibreOffice Writer?
(a) Pre-determined form and mode of document file
(b) One kind of model style
(c) One type of document
(d) Cluster of documents in Writer
4. Which of the following gives the status of your document like page numbers,
number of pages?
(a) Status bar (b) Standard toolbar
(c) Formatting (d) Title bar
5. Which of the following can be used to access a style menu?
(a) F11 function key (b) Sidebar Menu
(c) Formatting toolbar (d) All of these
6. The text or image which appears faintly in the background of a page is called
_________________.
(a) Water mark (b) Trade mark
(c) Copyright (d) Embossing
7. JPG or JPEG in image format stands for _________________.
(a) Joint Photographic Experts Group
(b) Joint Picture Experts Group
(c) Joint Photographic Experts Graph
(d) Joint Photographic Experts General
8. In Drawing Object Properties toolbar, grouping options provided are
_________________.
(a) Exit Group (b) Ungroup
(c) Enter Group (d) All of these
9. Which of the following is not the correct file extension for an image file?
(a) GIF (b) JPEG
(c) Odt (d) PNG
10. Image toolbar does not provide a tool for _________________.
(a) filtering (b) cropping
(c) copying (d) flipping
11. Which of the following is NOT true about Table of Contents, Index or
Bibliography dialog box?
(a) It has four tabs
(b) On the Type tab, by default, the checkbox for Protected against Manual Changes
option will be selected.
(c) The Styles tab contains options to change the background colour.
(d) None of the above
12. Which of the following tabs is by default active when the Table of Contents,
Entries or Bibliography dialog box is opened?
(a) Entries (b) Background
(c) Styles (d) Type
13. Which of the following tabs contains options to set styles for various entries in
the to C?
(a) Entries (b) Background
(c) Styles (d) Type
14. Which of the following can be added in the background of Table of Contents in
LibreOffice Writer?
a) Color b) Graphic
(c) Both a and b (d) Neither a nor b
15. Which of the following is NOT true about templates?
(a) The styles and formatting features can be reused.
(b) LibreOffice provides online templates
(c) We cannot create our own templates.
(d) None of the above.
16. Which of the following is the shortcut key to open the Templates dialog box?
(a) Ctrl+Alt+N (b) Shift+Ctrl+N
(c) Ctrl+Alt+T (d) Shift+Alt+T
17. Which of the following buttons, in the Templates dialog box, will be clicked to
save a template displayed in the list of templates?
(a) Export (b) Import
(c) Move (d) None of the above
18. Which of the following is the shortcut key to select he entire document?
(a) Ctrl+S (b) Ctrl+A
(c) Ctrl+D (d) Ctrl+B
19. Which of the following is the correct sequence of options to open the Templates
dialog box?
(a) File > Manage Templates > Templates
(b) File > Templates > Manage Templates
(c) Insert > Templates >Manage Templates
(d) Insert > Manage Templates > Templates
20. Which of the following is true about Track Changes feature of Writer?
(a) You cannot record a change made in the document.
(b) A comment of a particular author only can be deleted
(c) Any change made to the document is permanent.
(d) None of the above
21. Which of the following menus contains the Track Changes option?
(a) File (b) Edit
(c) View (d) Insert
22. Which of the following is the shortcut key to start recording the changes being
made in the document?
(a) Ctrl+Shift+C. (b) Alt+Shift+C
(c) Ctrl+Alt+C (d) Shift+C+F2
23. Which of the following feature is not used for data analysis in spreadsheet?
(a) Page layout (b) Consolidating data
(c) Goal Seek (d) Subtotal
24. Which of the following office tool is known for data analysis?
(a) Writer (b) Calc
(c) Impress (d) Draw
25. Which of the following operations cannot be performed using LibreOffice Calc?
(a) Store and manipulate data
(b) Create graphical representation of data
(c) Analysis of data
(d) Mail merge
26. What is the extension of spreadsheet file in Calc?
(a) .odb (b) .odt
(c) .odg (d) .ods
27. The default function while using Consolidate is ____________.
(a) Average (b) Sum
(c) Max (d) Count
28. Group by is used in _____________ tool to apply summary functions on columns.
(a) Consolidate function (b) Group and Outline
(c) What-if scenario (d) Subtotal tool
29. Which tool is used to predict the output while changing the input?
(a) Consolidate function (b) What-if scenario
(c) Goal seek (d) Fine and Replace
30. Which of the following is an example for absolute cell referencing?
(a) C5 (b) $C$5
(c) $C (d) #C
31. _____________ analysis tool works in reverse order, finding input based on the
output.
(a) Consolidate function (b) Goal seek
(c) What-if analysis (d) Scenario
32. Macro Recordings can be enabled from the ________ option in the menu bar.
(a) Sheet (b) Data
(c) Tools (d) Window.
33. Which of the following is an invalid Macro Name?
(a) 1formatword
(b) format word
(c) format*word
(d) Format_word.
34. Which of the following Libraries contains modules with prerecorded macros
and should not be changed?
(a) My Macros (b) LibreOffice Macros
(c) Untitled1 (d) Test.
35.Identify which of the following is a programming Language?
(a) Calc (b) BASIC
(c) Writer (d) Macro.
36.The Module can be executed from the IDE by pressing _________________.
(a) F3 (b) F4
(c) F5 (d) F6
37.Which of the following is the default name of the Macro _______________.
(a) Default (b) Main
(c) Macro1 (d) Main_Macro
38.Insert Sheet dialog can be invoked from _______________.
(a) sheet (b) insert
(c) tools (d) Windows
39. ______________ refers to cell G5 of sheet named My Sheet.
(a) $My Sheet.’G5’ (b) $My Sheet_’G5’
(c) $ ‘MySheet’.G5 (d) $ ‘MySheet’_G5
40.The path of a file has ____________ forward slashes.
(a) four (b) three
(c) two (d) one
41.Which of the following feature is used to jump to a different spreadsheet from
the current spreadsheet in LibreOffice Calc?
(a) Macro (b) Hyperlink
(c) connect (d) Copy
42.Sharing allows to edit the spread sheet by
(a) single user
(b) different users simultaneously
(c) one by one users
(d) one after other users
43.Sharing spreadsheet feature allows to save the changes in
(a) multiple sheets (b) user’s sheet
(c) in a same sheet (d) in different sheet
44.The Recording Changes feature of LibreOffice Calc provides different ways to
record the changes made by ____________ in the spreadsheet.
(a) one user (b) other user
(c) the user (d) one or other users
45.In Calc, the comments are added
(a) automatically (b) by author
(c) by reviewer (d) all of above
46.The changes by team members in the spreadsheet can be accepted or rejected
by
(a) the team members (b) any of the user
(c) owner (d) other users
47. Which of the following can be considered as an example of a database?
(a) Dictionary (b) Telephone directory
(c) Marks Register (d) Newspaper
48. Which of the following is NOT a DBMS?
(a) MS Access (b) Open Office Base
(c) MS Excel (d) MySQL
49. DBMS stands for ______________________.
(a) Data and Books Management System
(b) Database Management System
(c) Duplicate Books Management System
(d) Data Management Multi System
50. Which of the following data models sets a relation between the two or more
tables?
(a) Relational Data Model
(b) Network Data Model
(c) Hierarchical Data Model
(d) Connection Data Model
51. The details associated with an entity are called ____________.
(a) Table (b) Attributes
(c) Records (d) Primary key
52. A __________ is represented as rows in a table.
(a) field (b) attribute
(c) record (d) candidate key
53. In which of the following forms can a data value be represented?
(a) Numeric (b) Character
(c) Alphanumeric (d) All of the above
54. Which of the following uniquely identifies a row in a table?
(a) Primary key (b) Alternate key
(c) Foreign key (d) Candidate key
55. A ___________is a feature of a database using which we can enter data in a table
in an easy and user friendly manner.
(a) query (b) report
(c) form (d) field
56. A _____________ is a question asked from a database.
(a) query (b) report
(c) form (d) field
57. Which of the following is NOT a type of text data type?
(a) Memo (b) Varchar
(c) Float (d) Char
58. A currency data type can only store monetary data that is in dollars.
(a) True (b) False
(c) Neither a nor b (d) Both a and b
59. Which of the following data can a date data type store?
(a) Date
(b) Time
(c) Both date and time
(d) Neither date nor time
60. Which of the following is true about LibreOffice Base?
(a) It is a spreadsheet software
(b) It is free and open source software
(c) It can store only character data
(d) It is a licensed software.
61. Which of the following methods can be used to create a table in Base?
(a) Using a table wizard (b) Design View
(c) Both a and b (d) Neither a nor b
62. The related objects of a database can be seen in ____________ pane of the Base
Database window.
(a) Database (b) Task
(c) Title Bar (d) Menu Bar
63. Which is the shortcut key to open an existing database?
(a) Ctrl+ D (b) Ctrl+O
(c) Ctrl+E (d) Ctrl+F
64. The Design view of Table Creation window in LibreOffice Base is divided into
______ sections or panes.
(a) 2 (b) 3
(c) 4 (d) 5
65. While entering records in a table, we can move to the next field by pressing the
_________ key.
(a) Tab (b) Ctrl
(c) Enter (d) Shift
66. Which of the following is true about primary key of a table?
(a) Every table must have a primary key
(b) The data values in primary key field cannot be duplicated.
(c) A primary key field cannot be left blank
(d) All of the above
67. Which of the following actions can be performed once the tables are created in
a database?
(a) Add a field in a table (b) Rename a table
(c) Delete a table (d) All of the above
68. Which of the following is checked by a DBMS?
(a) Redundancy
(b) Inconsistency
(c) Both (a) and (b)
(d) Neither (a) nor (b)
68. Which of the following is required to set a relationship between the two tables?
(a) Both the tables must be in different databases
(b) Both the tables must have a common field
(c) Both the tables must have the same name
(d) Both tables must be stored in documents folder only.
69. If a record is added in a master table, which of the following is NOT true for
transaction table
(a) The record in the master table is called the master record
(b) The corresponding record in transaction table can only be entered once.
(c) The record in the transaction table is called the transaction record.
(d) It is possible to add a record in the master table
70. Which type of relationship exists between a student and the subjects studied
by him/her?
(a) One-to-one (b) One-to-many
(c) Many-to-many (d) All of the above
71. Consider the following tables. Which type of relationship can be established
between the two tables?
(a) One-to-one
(b) One-to-many
(c) Many-to-many
(d) None of the above
72. Which of the following menus contains the Relationship option?
(a) Edit (b) File
(c) Tools (d) View
73. The list of tables to be added is displayed in the __________ dialog box in the
Relationship Screen.
(a) Add Tables (b) Add Databases
(c) Both (a) and (b) (d) Neither (a) nor (b)
74. In the relationship design screen, the relationship between the two tables is
done using __________ operation.
(a) Click
(b) Double Click
(c) Drag and Drop
(d) Right click
75. Which of the following is NOT an option that can be used to maintain referential
integrity in a database?
(a) No Action (b) Set NULL
(c) Set Default (d) Set Value
76. Which of the following is refer to asking questions from the database?
(a) Report (b) Table
(c) Query (d) Database
77. Which of the following are the ways to design a query?
(a) Wizard (b) Design View
(c) SQL (d) All of the above
78. Which is a flexible way to create a query?
(a) Wizard (b) Design View
(c) Both (a) and (b) (d) Neither (a) nor (b)
80. Into how many parts is the query design window divided?
(a) One (b) Two
(c) Three (d) Four
81. Which of the following is NOT true about queries?
(a) It can be created using multiple tables
(b) Multiple queries can be created in a database
(c) A query can run multiple times
(d) A query once created cannot be edited
82. Which of the following is the shortcut key to run the query?
(a) F3 (b) F4
(c) F5 (d) F6
83. Which of the following functions can be performed on numerical data while
designing a query?
(a) Sum (b) Minimum
(c) Maximum (d) All of the above
84. In a Query Design wizard, which of the following buttons is clicked to move a
field from ‘Available fields’ list box to ‘Fields in the query’ list box?
(a) > (b) < 9
(c) ∨ (d) ∧
85. Which of the following relational operators can be applied to set the criterion
while designing a query in LibreOffice Base?
(a) > (b) =
(c) != (d) Add Form
86. Which of the following dialog box is present when the Query Design window is
opened for the first time to design a query?
(a) Add Table (b) Add Query
(c) Add Table or Query (d) None of the above
87. Which of the following step is not performed if there is no numerical data to be
worked upon in a query?
(a) Selection of fields (b) Giving Aliases
(c) Summarizing (d) Selection of tables
88. Which of the following toolbars contains the Label tool?
(a) Standard Toolbar (b) Forms Controls Toolbar
(c) Records toolbar (d) Formatting toolbar
86. The Record toolbar has the buttons to move to the
(a) first record (b) second record
(c) last record (d) all records
87. Which of the following is NOT true about forms?
(a) It is the front end for data entry
(b) It can contain only text fields
(c) Graphics can be inserted on the form
(d) It can contain only fixed number of records
88. Which of the following keys is pressed to select only textbox on the form?
(a) Alt (b) Shift
(c) Ctrl (d) Tab
89. Which of the following properties in the Properties: Label Field text box is used
to insert a tool-tip on the form?
(a) Tool Text (b) Help Text
(c) Tool Tip (d) Help Tip
90. Which of the following objects of LibreOffice Base is used to display data
retrieved from one or more tables in a presentable manner?
(a) Query (b) Form
(c) Report (d) Panel
91. Which of the following values of Date Format property is selected to view a
calendar on the form?
(a) Standard (short) (b) Standard (long)
(c) Default (d) Standard (Medium)
92. Which of the following commands on the Forms Control toolbar is used to
toggle between Design View and Form view?
(a) Design Mode (b) Toggle Mode
(c) View Mode (d) Print mode
93. Using which of the following objects in a database, can a report be generated?
(a) Tables (b) Queries
(c) Both a and b (d) Neither a nor b
94. Which of the following components open along with the Report Wizard?
(a) Report Builder (b) Add Fields dialog box
(c) Both (a) and (b) (d) Neither (a) nor (b)
95. Workplace safety is essential in organisation ____________.
(a) to avoid the accident and injury
(b) to increase the productivity
(c) to improve the work environment
(d) All of the above
96. Which of the following is not mandatory to keep the good health of an
employee?
(a) Cleanliness
(b) Food court
(c) Clean and fresh air
(d) Clean washroom
97. The security department is not responsible for __________.
(a) personal safety (b) computer system and equipment safety
(c) electrical safety (d) personal belongings
98. The proper security procedures will increase ____________.
(a) liabilities (b) insurance
(c) business revenue (d) operational charges of the company
99. Which kind of hazards can occur in IT industry?
(a) Biological (b) Chemical
(c) Physical (d) Ergonomic
100. Which of the following can cause hazards while using computers?
(a) Poor sitting postures or excessive duration of sitting in one position
(b) Lifting heavy object
(c) Mishandling of tools and equipment
(d) Improper handling of office equipment
101. Which of the following statements is likely to result in an injury to the
operator?
(a) Selecting the right tool for the job (b) Wearing safety goggles or glasses
(c) Using a tool with loose handles (d) Keeping cutting tools sharp
102. What are the potential cause of hazards at workplace?
(a) Poor ventilation (b) Poor lighting
(c) Poor housekeeping (d) All of the above
103. To provide healthy and safety working environment, every organisation must
have ___________________.
(a) Cleanliness (b) Filtered water
(c) Clean wash-room (d) All of the above
104. Air pollution is mostly caused by production of the _____ in the surrounding air.
(a) dust (b) mixture of solid particles
(c) gases (d) All of above
105. Repetitive use of muscle may feel pain in your ___________.
(a) neck (b) shoulder
(c) wrist or fingers (d) All of the above
106. The security department organisation is not responsible for _________________.
(a) other safety (b) computer system safety
(c) electrical safety (d) transport safety
107. For an organisation, the proper security procedures will reduce ______________.
(a) liabilities (b) insurance
(c) business revenue (d) operational charges of the company
108. Do not wear ________ when working with machines.
(a) jewellery (b) safety glasses
(c) masks (d) gloves
109. Sore lower back is caused due to _________________.
(a) reaching forward frequently (b) no lumbar support
(c) no upper back support from chair (d) reaching forward for long periods
110. What should you do with the problem of dry eyes?
(a) Forget to blink (b) Rest eyes periodically and do simple eye exercises
(c) Do exercise (d) Blink the eyes
111. If light is coming directly behind or in front of you then you may suffer from
_________________.
(a) eye strain (b) sore eyes
(c) dry eyes (d) eye strain and sore eyes
112. What are the steps necessary for operating a fire extinguisher?
(a) Identify the safety pin of the fire extinguisher which is generally present in its handle
(b) Break the seal and pull the safety pin from the handle
(c) Use the fire extinguisher by squeezing the lever
(d) All of the above
113. Which of the following is an examples of ignition sources of open flames?
(a) Gas ovens (b) Lighters in smoking areas
(c) Welding torches (d) All of the above
114. In fire classification, all liquid, grease, and gas material comes under
__________________.
(a) Class A material (b) Class B material
(c) Class C material (d) Class A material
115. In fire classification, material magnesium, potassium, and sodium comes
under _______________.
(a) Class A material (b) Class B material
(c) Class C material (d) Class D material
116. In fire classification, material wood, cloth, and paper comes under
________________.
(a) Class A material (b) Class B material
(c) Class C material (d) Class D material
117. In fire classification, electrical material and equipment comes under
____________________.
(a) Class A material (b) Class B material
(c) Class C material (d) Class D material
118. When do we use a fire extinguisher?
(a) In case of flood (b) In case of electric shock
(c) In case of fire (d) In case of burn injury
119. What is the primary fire emergency telephone number is?
(a) 011 (b) 101
(c) 108 (d) 111
120. Which of the following contains everything you need to know about evacuating
your facility safely?
(a) Evacuation Diagram (b) Emergency Action Plan
(c) Employee Directory (d) Both (a) and (b)
121. The best course of action to take during a medical emergency is to
________________.
(a) Begin first aid immediately
(b) Activate the emergency plan for reporting injuries
(c) Notify the person's family about the situation
(d) Both (a) and (b)