SUBJECT – IT (402)

Unit 1 : Digital Documentation (Advanced)

1.​ Which feature in Writer allows you to apply the same style to multiple words scattered
throughout the document?
(a) Format Painter​ (b) Fill Format option
(c)​Style Inspector​ (d) Font Adjustment Tool
Answer :- (b) Fill Format option

2.​ Which feature allows you to jump to a different document, spreadsheet, or website from

ar
within a document?
(a) Bookmark​ (b) Page Break​ (c) Hyperlink​ (d) Format Painter

m
Answer :- (c) Hyperlink

Ku
3.​Prisha is a book editor. She wants to change the indentation of all paragraphs, and change
the font of all titles in the book. Which feature she should use to make the task easy?
(a) Styles​ (b) Templates

h
(c)​ Table of content​ (d)

es
Consolidating Answer :- (a) Styles av
4.​Which of the following is the shortcut key to open the Templates dialog box?
(a) Ctrl+Alt+N​ (b) Ctrl+Shift+N
Pr
(c)​ Ctrl+Alt+T​ (d) Shift+Alt+T
Answer :- (b) Ctrl+Shift+N
r.

5.​How many levels of headings does LibreOffice Writer support?

:M

(a) 5​ (b) 8​ (c) 10​ (d) 12

Answer :- (c) 10
by

6.​Which of the following is NOT true about templates?

(a)​The styles and formatting features can be reused.
(b)​Libre Office provides online templates
ed

(c)​Templates can have headings, text formats, styles, page numbers, headers and footers
(d)​We cannot create our own templates
at

Answer :- (d) We cannot create our own templates

re

7.​ Radha is planning a school event and wants to decide how much money to allocate for different
activities, like games, food, and decorations. She creates several different budget plans to see how
C

changing the amount for each category affects the total expenses. How can Radha efficiently compare the
different budget plans for her school event in the same spreadsheet?
(a)​By writing down each budget on paper
(b)​ By using the What-if scenario feature in the spreadsheet to create and analyze
different budget options
(c)​By asking her friends to guess the costs
(d)​By using the Filter function to look at one category at a time
Answer :- (b) By using the What-if scenario feature in the spreadsheet to create and analyse
different budget options
8.​What is the benefit of inserting an image as a link in a document?
(a)​It reduces the document size by storing only the reference to the image.
(b)​It enhances the image quality.
(c)​It allows for automatic image editing within the document.
(d)​It removes the need for image captions.
Answer :- (a) It reduces the document size by storing only the reference to the image.

9.​ After incorporating the reviews, Krishna mailed the document to his editor with the Track
Changes ON. He made certain changes in the document. Pradeep wants to compare his original

ar
document with the reviewed document. What is the first step Krishna should take to compare his edited
document with the original document?

m
(a)​Open the Manage Changes dialog box.

Ku
(b)​Select Edit > Track Changes > Compare Documents option.
(c)​Save the edited file.
(d)​Accept or reject the desired changes.
Answer :- (b) Select Edit > Track Changes > Compare Documents option

h
es
10.​It allows the placement of image in relation to text
(a) Water mark​ (b) Trade mark​ (c) Copyright​ (d) Text Wrapping
av
Answer :- (d) Text Wrapping
Pr
11.​ In the custom styles, each​ field on the Structure line represents a blank space in
a document.
a. Black b. White c. Blue d. Yellow
r.

Answer :- a. Black
:M

12.​To increases the contrast of an image,​ option is used in a document.

a. Smooth​ b. Sharpen​ c. Aging​ d. mosaic
by

Answer :- b. Sharpen

13.​In a word processor, ​ option is selected for a scaled resizing of an image.

ed

a. Original Size​ b. Image Size​ c. Keep ratio​ d. Relative

Answer :- b. Keep ratio
at

14.​ It is a reference point for the graphics which is created while positioning any image. This point
re

could be the page, or frame where the object is either a paragraph, or even a character in a word
processor.
C

a. Wrap Text​ b. Anchoring​ c. Alignment​ d. BookMark

Answer :- c. Anchoring

15.​ John has written a book consisting of fifteen chapters. He wanted to make the index of the
book. Suggest him the option used to create the index automatically in a word processor.
a. Tables​ b. Columns​ c. Mail Merge​ d. Table of Content
Answer :- d. Table of Content
16.​When you apply a ​ , you apply a group of formatting effects together in one single step.
a. Effect​ b. Style​ c. Template​ d. Format
Answer :- b. Style

17.​ In a document, ​ refers to the vertical or horizontal placement of a graphic in relation to

the chosen anchor point.
a. Arrangement​ b. Anchoring​ c. Alignment​ d. Text Wrapping
Answer :- c. Alignment

ar
18.​A​ is a model that you use to create other documents.
a. Template​ b. Document​ c. Design​ d. Copy Paste

m
Answer :- a. Template

Ku
19.​ ​ styles in a text document affect selected text within a paragraph, such as the font
and size of text, or bold and italic formats.
a. Cell​ b. Paragraph​ c. Formatting​ d. Character

h
Answer :- d. Character

es
20.​To repeat the graphic across the entire background area, we need to select option in word processor.
av
a. Tile​ b. Position​ c. Stretch​ d. Area
Answer :- a. Tile
Pr

21.​ ​ is particularly useful when creating a watermark or when wrapping the image in the
background in a document.
r.

a. Transparency​ b. Fill​ c. Filters​ d. Crop

:M

Answer :- a. Transparency

22.​The grey colour in the TOC reminds us that the text has been generated ​ .
by

(a) manually​ (b) automatically

(c) Both (a) and (b)​ (d) None of these
Answer :- (b) automatically
ed

23.​ ​ include fonts, alignment, borders, background, number formats (for

at

example, currency, date, number), and cell protection in document.

a. Cell Style​ b. Numbering Style​ c. Paragraph Style​ d. Character Style
re

Answer :- a. Cell Style

C

24.​​ controls how graphics are stacked upon each other or relative to the text.
a. Arrangement​ b. Alignment​ c. Anchoring​ d. Wrapping
Answer :- a. Arrangement

25.​Which style category would you use to format a section containing text, graphics, and lists?
(a) Page Style​ (b) Paragraph Style
(c) Character Style​ (d) Frame
Style Answer :- (d) Frame Style
26.​ Prisha is a book editor. She wants to change the indentation of all paragraphs, and change the
font of all titles in the book. Which feature she should use to make the task easy?
a. Styles​ b. Templates​ c. Table of content​ d. Consolidating
Answer :- a. Styles

27.​ Gaurav has inserted an image in a document. He wants to remove the unwanted area of the
image. Which option of the word processor he will use to complete the task?
a. Clip art​ b. Cut​ c. Crop​ d. Contrast
Answer :- c. Crop

ar
28.​ Prerna is a student of class X. Her teacher has asked her to create a document on ‘Women
Empowerment’. She has written the text and also added relevant images in her document using Writer.

m
But she has realized that the paragraph will look better if the images are placed around the text. Name the

Ku
feature of Writer she can use to get the desired result.
(a) Placing image​ (b) Wrap text
(c)​ Positioning image​ (d) Closing

h
text Answer :- (b) Wrap text

es
29.​Styles menu (from sidebar) in Writer provide options to work on
(a) Paragraph Styles​ (b) Frame Styles​
av (c) Page Styles​ (d) All of the above
Answer :- (d) All of the above

30.​What is style template in LibreOffice Writer?

Pr

(a)​Pre-determined form and mode of document file

(b)​One kind of model style
r.

(c)​One type of document

:M

(d)​Cluster of documents in Writer

Answer :- (b) One kind of model style

31.​Which of the following gives the status of your document like page numbers, number of pages?
by

(a) Status bar​ (b) Standard toolbar​ (c) Formatting​ (d) Title bar
Answer :- (a) Status bar
ed

32.​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
at

Answer :- (d) All of these

re

33.​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
C

Answer :- (a) Water mark

34.​ 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
Answer :- (a) Joint Photographic Experts Group

35.​In Drawing Object Properties toolbar, Grouping options provided are ​ .

(a) Exit Group​ (b) Ungroup​ (c) Enter Group​ (d) All of these
Answer :- (d) All of these

36.​Which of the following is not the correct file extension for an image file?
(a) GIF​ (b) JPEG​ (c) Odt​ (d) PNG
Answer :- (c) Odt

ar
37.​Image toolbar does not provide a tool for ​ .

m
(a) filtering​ (b) cropping​ (c) copying​ (d) flipping

Ku
Answer :- (c) copying

38.​ Which of the following is NOT true about Table of Contents, Index or Bibliography dialog box?
(a)​It has four tabs

h
(b)​On the Type tab, by default, the checkbox for Protected against Manual Changes option

es
will be selected.
(c)​The Styles tab contains options to change the background colour.
av
(d)​None of the above
Answer :- (a) It has four tabs
Pr

39.​ Which of the following tabs is by default active when the Table of Contents, Entries or
Bibliography dialog box is opened?
r.

(a) Entries​ (b) Background​ (c) Styles​ (d) Type

:M

Answer :- (d) Type

40.​Which of the following tabs contains options to set styles for various entries in the ToC?
by

(a) Entries​ (b) Background​ (c) Styles​ (d) Type

Answer :- (c) Styles
ed

41.​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
at

Answer :- (c) Both a and b

re

42.​Which of the following is NOT true about templates?

(a)​The styles and formatting features can be reused.
C

(b)​LibreOffice provides online templates

(c)​We cannot create our own templates.
(d)​None of the above.
Answer :- (c) We cannot create our own templates.

43.​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
Answer : (b) Shift+Ctrl+N
44.​ 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
Answer :- (b) Import

45.​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
Answer :- (b) Ctrl+A

ar
46.​Which of the following is the correct sequence of options to open the Templates dialog box?

m
(a)​File > Manage Templates > Templates
(b)​File > Templates > Manage Templates

Ku
(c)​Insert > Templates >Manage Templates
(d)​Insert > Manage Templates > Templates
Answer :- (b) File > Templates > Manage Templates

h
es
47.​Which of the following is true about Track Changes feature of Writer?
(a)​You cannot record a change made in the document.
av
(b)​A comment of a particular author only can be deleted
(c)​Any change made to the document is permanent.
Pr
(d)​None of the above
Answer :- (d) None of the above
r.

48.​Which of the following menus contains the Track Changes option?

:M

(a) File​ (b) Edit​ (c) View​ (d) Insert

Answer :- (b) Edit
by

49.​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
Answer :- (a) Ctrl+Shift+C.
ed

Unit 2 : Electronic Spreadsheets (Advanced)

at
re

1.​ Radha is planning a school event and wants to decide how much money to allocate for different
activities, like games, food, and decorations. She creates several different budget plans to see how
C

changing the amount for each category affects the total expenses. How can Radha efficiently compare the
different budget plans for her school event in the same spreadsheet?
(a)​By writing down each budget on paper
(b)​By using the What-if scenario feature in the spreadsheet to create and analyze different budget
options
(c)​By asking her friends to guess the costs
(d)​By using the Filter function to look at one category at a time
Answer :- (b) By using the What-if scenario feature in the spreadsheet to create and analyse
different budget options
2.​The code of macro begins with ​ followed by the name of the macro and ends with ​ .
(a) Function, End​ (b) Sub, End Sub​ (c) Sub, End Function (d) Sup, End Sup
Answer :- (b) Sub, End Sub

3.​Amita as head of the family wants to make the list of her expenditure and income for monthly
budgeting so cost cutting can be done, help her to choose suitable tool.
(a) Macro​ (b) Solver
(c) what if scenarios​ (d) Sub total
Answer :- (b) Solver

ar
4.​What is the primary function of the Subtotal tool in Calc?

m
(a)​It creates a chart for the data.
(b)​It automatically groups data and applies common functions like sum and average.

Ku
(c)​It highlights cells with conditional formatting.
(d)​It removes duplicate data from the spreadsheet.
Answer - (b) It automatically groups data and applies common functions like sum and average.

h
es
5.​ A​ hyperlink stores the location with respect to the current location in LibreOffice
Calc. av
(a) Absolute​ (b) Relative​ (c) Mixed​ (d) Reference
Answer :- (b) Relative
Pr

6.​​ is a text editor that allows you to create and edit macros.
(a) IDE​ (b) Notepad​ (c) Open Office Writer​ (d) MS Word
r.

Answer :- (a) IDE

:M

7.​ An ​ link will stop working only if the target is moved while a​ link will stop
working only if the start and target locations change relative to each other.
(a) absolute, fixed​ (b) Relative, Absolute
by

(c) absolute, relative​ (d) permanent, absolute

Answer :- (c) absolute, relative
ed

8.​ ​ is specifically designed to minimize the results according to a set rules that we define in
a spreadsheet.
at

a. Goal Seek​ b. Scenario​ c. solver​ d. Subtotal

Answer :- b. Scenario
re
C

9.​ Sahil and his partners have created a list of their company employees in one of the spreadsheets in
the office. Now the rest of the task they want to complete from home. Which option they should use to
access the same Spreadsheet from home?
a. Consolidate Worksheet​ b. Link Worksheet
c. Merge Worksheet​ d. Lock Worksheet
Answer :- b. Link Worksheet

10.​​ can help to clarify the relation between cells while using “Multiple Operations”.
a. Detective​ b. Solver​ c. Navigation​ d. Hyperlink
Answer :- b. Solver

11.​The cell reference in a spreadsheet for cell range B2 to F15 is ​ .

(a) B2.F15​ (b) B2;F15
(c) B2:F15​ (d) B2-F15
Answer :- (c) B2:F15

12.​Spreadsheet software can find the changes by ​ sheets.

a. Changing​ b. Comparing​ c. Renaming​ d. Editing
Answer :- b. Comparing

ar
13.​Identify the part of a Spreadsheet using which a user can manage multiple sheets.

m
a. Status Bar​ b. Sheet Tab​ c. Formula Bar​ d. Worksheet Area
Answer :- b. Sheet Tab

Ku
14.​ When you open a new spreadsheet, by default, it has a sheet named ​ which is managed
using tabs at the bottom of the spreadsheet.

h
a. Sheet1​ b. Worksheet1​ c. Untitled1​ d. New Sheet

es
Answer :- a. Sheet1 av
15.​Which of the following is true about Track Changes feature of Writer?
(a)​You cannot record a change made in the document.
Pr
(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
r.

Answer :- (d) None of the above

:M

16.​Reviewers and authors can add their ​ to explain their changes in the cell of Spreadsheet.
a. Comments​ b. Worksheet​ c. Hyperlink​ d. Macros
by

Answer :- a. Comments

17.​In Calc, Arguments passed to a macro from Calc are always ​ .

ed

a. Cell Reference​ b. Both a and b​ c. Value​ d. Sheet Reference

Answer :- b. Value
at

18.​​ is a saved sequence of commands for or keystrokes that are stored for later use.
re

(a) solver​ (b) auto sum

(c) consolidate​ (d) macro
C

Answer :- (d) macro

19.​ A ​ refers to a cell or a range of cells on a worksheet and can be used to find the values or
data that you want formula to calculate.
a. Cell reference​ b. Sheet Reference​ c. Block​ d. Autofill
Answer :- a. Cell reference

20.​Identify the mode, where we can modify in the structure of table?

a. Datasheet view​ b. Design view​ c. Structure view​ d. All of the above
Answer :- . Design view

21.​ ​ function takes data from a series of worksheets or workbooks and summaries it into
a single worksheet that you can update easily.
a .Data Combination b. Data Consolidation​ c. Data Merging​ d. Data Concatenation
Answer :- c. Data Consolidation

22.​ Manjinder has his small pizza shop where on daily basis he used to sold 20 packets of pizza and
got monthly profit of 20,000/-. As the raw material rates are increasing and different varieties he has to
add, he wants to make estimated profit of rs.25000/- Which method he has to adopt to calculate this?

ar
(a)​Consolidating data​ (b) Goal Seek
(c) subtotals​ (d) cell reference

m
Answer :- (b) Goal Seek

Ku
23.​​ store data in a single table which is suitable to store less amount of Data.
a. Flat File​ b. Relational​ c. Mini File​ d. Single File

h
Answer :- a. Flat File

es
24.​Which function cannot be performed through Subtotal in a Spreadsheet?
a. Sum​ b. Product​ c. Average​ d. Percentage
av
Answer :- d. Percentage
Pr

25.​Scenarios are a tool to test ​ questions.

a. Auto​ b. Goal Seek​ c. What-if​ d. Drop Down
Answer :- c. What-if
r.
:M

26.​ It refers to a cell or a range of cells on a worksheet and can be used to find the values or data that
you want formula to calculate.
a. Row​ b. Column​ c. Autosum​ d. Cell Reference
by

Answer :- d. Cell Reference

27.​ ​ , totals/adds data arranged in an array—that is, a group of cells with labels for columns
and/or rows Which step one must should follow before using the Subtotal option?
ed

a. Consolidate​ b. Rename Data​ c. Filter Data​ d. Subtotal

Answer :- d. Subtotal
at

28.​A ​ hyperlink contains the full address of the destination file or web page.
re

a. Relative​ b. Absolute​ c. Mixed​ d. Address

Answer :- b. Absolute
C

29.​Which of the following is more elaborate form of Goal Seek?

a. Subtotal​ b. Scenario​ c. Solver​ d. Consolidate
Answer :- c. Solver

30.​​ means combining data in a spreadsheet from different worksheets into master worksheet
a. Hyperlinks​ b. Consolidating​ c. Linking​ d. Filter
Answer :- b. Consolidating
31.​ An ​ link will stop working only if the target is moved while a​ link will stop
working only if the start and target locations change relative to each other.
a. absolute, fixed​ b. Relative, Absolute
c. absolute, relative​ d. permanent, absolute
Answer :- Ans. c. absolute, relative

32.​By default, sheets tab are present at the ​ of the spreadsheet.

a. Top​ b. Bottom​ c. Center​ d. Right
Answer :- b. Bottom

ar
33.​The cell reference in a spreadsheet for cell range B2 to F15 is ​ .
a. B2.F15​ b. B2;F15​ c. B2:F15​ d. B2-F15

m
Answer :- c. B2:F15

Ku
34.​ Millennium University is organizing a reunion meet for their alumnae students. For this purpose,
university wants to send the invite to all these students with their different addresses. Which feature of the

h
Word Processor University should use to accomplish the task?
a. Mail Merge​ b. E-Mail​ c. Templates​ d. Data Source

es
Answer :- a. Mail Merge av
35.​ Hema is a chartered accountant. She used to maintain the accounts in a spreadsheet on everyday
basis. There are number of steps which she needs to follow every time. Can you suggest her a feature of
Pr
spreadsheet through which she can perform these tasks quickly without repeating the steps every time?
a. Record Changes​ b. Track Changes​ c. Goal Seek​ d. Using Macros
Answer :- d. Using Macros
r.
:M

36.​ Raj has created a worksheet where he has added all the information of his employees. He wants
every employee to go through the worksheet and update their address and phone number, if required. He
also would like to know the changes done by his employees. Which feature of spreadsheet he should
by

enable to see the changes made by his employees?

a. Macro​ b. Link Workbook​ c. Change Worksheet​ d. Track Changes
Answer :- d. Track Changes
ed

37.​ Akshat wants to store a huge amount information about his firm in a database. Which type of
at

table organization would be most suitable for this purpose?

a. Relational​ b. Flat File​ c. Either Relational or Flat file​ d. Hierarchical
re

Answer :- c. Either Relational or Flat file

C

38.​Which of the following feature is not used for data analysis in spreadsheet?
(a) Consolidating data​ (b) Goal Seek​ (c) Subtotal​ (d) Page layout
Answer :- (d) Page layout

39.​Which of the following office tool is known for data analysis?

(a) Writer​ (b) Calc​ (c) Impress​ (d) Draw
Answer :- (b) Calc
40.​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
Answer :- (d) Mail merge

41.​What is the extension of spreadsheet file in Calc?

(a) .odb​ (b) .odt​ (c) .odg​ (d) .ods
Answer :- (d) .ods

ar
42.​The default function while using Consolidate is ​ .
(a) Average​ (b) Sum​ (c) Max​ (d) Count

m
Answer :- (b) Sum

Ku
43.​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

h
Answer :- (d) Subtotal tool

es
44.​Which tool is used to predict the output while changing the input?
av
(a)​Consolidate function​ (b) What-if scenario
(c) Goal seek​ (d) Fine and Replace
Pr
Answer :- (b) What-if scenario

45.​Which of the following is an example for absolute cell referencing?

r.

(a) C5​ (b) $C$5​ (c) $C​ (d) #C

:M

Answer :- (b) $C$5

46.​​ analysis tool works in reverse order, finding input based on the output.
by

(a) Consolidate function​ (b) Goal seek​ (c) What-if analysis​ (d) Scenario
Answer :- (b) Goal seek
ed

47.​Macro Recordings can be enabled from the ​ option in the menu bar.
(a) Sheet​ (b) Data​ (c) Tools​ (d) Window
at

Answer :- (c) Tools

re

48.​Which of the following is an invalid Macro Name?

(a) 1formatword​ (b) format word​ (c) format*word​ (d) Format_word
C

Answer :- d) Format_word

49.​ Which of the following Libraries contains modules with prerecorded macros and should
not be changed?
(a) My Macros​ (b) LibreOfficeMacros​ (c) Untitled1​ (d) Test.
Answer :- (b) LibreOfficeMacros
50.​Identify which of the following is a programming Language?
(a) Calc​ (b) BASIC​ (c) Writer​ (d) Macro.
Answer :- (b) BASIC

51.​The Module can be executed from the IDE by pressing ​ .

(a) F3​ (b) F4​ (c) F5​ (d) F6
Answer :- (c) F5

52.​Which of the following is the default name of the Macro ​ .

ar
(a) Default​ (b) Main​ (c) Macro1​ (d) Main_Macro
Answer :- (b) Main

m
Ku
53.​Insert Sheet dialog can be invoked from ​ .
(a) sheet​ (b) insert​ (c) tools​ (d) Windows
Answer :- (a) sheet

h
54.​​ refers to cell G5 of sheet named My Sheet.

es
(a) $My Sheet.’G5’​ (b) $My Sheet_’G5’​ (c) $ ‘MySheet’.G5​ (d) $ ‘MySheet’_G5
Answer :- (c) $ ‘MySheet’.G5
av
55.​The path of a file has ​ forward slashes.
Pr
(a) four​ (b) three​ (c) two​ (d) one
Answer :- (b) three
r.

56.​ Which of the following feature is used to jump to a different spreadsheet from the current
:M

spreadsheet in LibreOffice Calc?

(a) Macro​ (b) Hyperlink​ (c) connect​ (d) Copy
Answer :- (b) Hyperlink
by

57.​Sharing allows to edit the spredshheet by

(a)​single user​ (b) different users simultaneously
ed

(c) one by one users​ (d) one after other users

Answer :- (b) different users simultaneously
at

58.​Sharing spredsheet feature allows to save the changes in

re

(a) multiple sheets​ (b) user’s sheet​ (c) in a same sheet​ (d) in different sheet
Answer :- (a) multiple sheets
C

59.​ 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
Answer :- (d) one or other users
60.​In Calc, the comments are added
(a) automatically​ (b) by author​ (c) by reviewer​ (d) all of above
Answer :- (d) all of above

61.​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
Answer :- (c) owner

ar
Unit 3 : Database Management System using LibreOffice Base

m
1.​Which of the following can be considered as an example of a database?

Ku
(a) Dictionary​ (b) Telephone directory​ (c) Marks Register​ (d) Newspaper
Answer :- (d) Newspaper

h
2.​Which of the following is NOT a DBMS?
(a) MS Access​ (b) Open Office Base​ (c) MS Excel​ (d) MySQL

es
Answer :- (c) MS Excel av
3.​DBMS stands for ​ .
(a)​Data and Books Management System​ (b) Database Management System
Pr
(c) Duplicate Books Management System​ (d) Data Management Multi System
Answer :- (b) Database Management System
r.

4.​Which of the following data models sets a relation between the two or more tables?
:M

(a)​Relational Data Model​ (b) Network Data Model

(c) Hierarchical Data Model​ (d) Connection Data Model
Answer :- (a) Relational Data Model
by

5.​The details associated with an entity are called ​ .

(a) Table​ (b) Attributes​ (c) Records​ (d) Primary key
ed

Answer :- (b) Attributes

at

6.​A ​ is represented as rows in a table.

(a) field​ (b) attribute​ (c) record​ (d) candidate key
re

Answer :- (c) record

C

7.​In which of the following forms can a data value be represented?

(a) Numeric​ (b) Character​ (c) Alphanumeric​ (d) All of the above
Answer :- (d) All of the above

8.​Which of the following uniquely identifies a row in a table?

(a) Primary key​ (b) Alternate key​ (c) Foreign key​ (d) Candidate key
Answer :- (a) Primary key
9.​ 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
Answer :- (c) form

10.​A ​ is a question asked from a database.

(a) query​ (b) report​ (c) form​ (d) field
Answer :- (a) query

11.​Which of the following is NOT a type of text data type?

ar
(a) Memo​ (b) Varchar​ (c) Float​ (d) Char
Answer :- (c) Float

m
Ku
12.​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
Answer :- (b) False

h
13.​Which of the following data can a date data type store?

es
(a) Date​ (b) Time​ (c) Both date and time​ (d) Neither date nor time
Answer :- (c) Both date and time
av
14.​Which of the following is true about LibreOffice Base?
Pr
(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.
Answer :- (b) It is free and open source software
r.
:M

15.​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
Answer :- (c) Both a and b
by

16.​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
ed

Answer :- (a) Database

at

17.​Which is the shortcut key to open an existing database?

(a) Ctrl+ D​ (b) Ctrl+O​ (c) Ctrl+E​ (d) Ctrl+F
re

Answer :- (b) Ctrl+O

C

18.​ The Design view of Table Creation window in LibreOffice Base is divided into ​ sections
or panes.
(a) 2​ (b) 3​ (c) 4​ (d) 5
Answer :- (a) 2

19.​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
Answer :- (a) Tab
20.​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
Answer :- (d) All of the above

21.​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
Answer :- (d) All of the above

ar
22.​Which of the following is checked by a DBMS?

m
(a) Redundancy​ (b) Inconsistency​ (c) Both (a) and (b)​ (d) Neither (a) nor (b)

Ku
Answer :- (c) Both (a) and (b)

23.​Which of the following is required to set a relationship between the two tables?
(a)​Both the tables must be in different databases

h
(b)​Both the tables must have a common field

es
(c)​Both the tables must have the same name
(d)​Both tables must be stored in documents folder only.
av
Answer :- (b) Both the tables must have a common field
Pr
24.​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.
r.

(c)​The record in the transaction table is called the transaction record.

:M

(d)​It is possible to add a record in the master table

Answer :- (b) The corresponding record in transaction table can only be entered once.
by

25.​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
Answer :- (b) One-to-many
ed

26.​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
at
re
C

27.​Which of the following menus contains the Relationship option?

(a) Edit​ (b) File​ (c) Tools​ (d) View
Answer :- (c) Tools
28.​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)
Answer :- (a) Add Tables

29.​ 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
Answer :- (c) Drag and Drop

30.​ Which of the following is NOT an option that can be used to maintain referential integrity

ar
in a database?
(a) No Action​ (b) Set NULL​ (c) Set Default​ (d) Set Value

m
Answer :- (d) Set Value

Ku
31.​Which of the following is NOT true about forms?
(a)​It is the front end for data entry

h
(b)​It can contain text fields
(c)​Graphics can be inserted on the form

es
(d)​It can accept only fixed number of records
Answer :- (d) It can accept only fixed number of records
av
32.​ Abha wants to create a connection between two or more tables. Suggest her the
option to accomplish the task.
Pr

(a) Table​ (b) Form​ (c) Relationships​ (d) Sorting

Answer :- (c) Relationships
r.
:M

33.​Which of the following is refer to asking questions from the database?

(a) Report​ (b) Table​ (c) Query​ (d) Database
Answer :- (c) Query
by

34.​Which of the following are the ways to design a query?

(a) Wizard​ (b) Design View​ (c) SQL​ (d) All of the above
ed

Answer :- (d) All of the above

35.​Which is a flexible way to create a query?

at

(a) Wizard​ (b) Design View​ (c) Both (a) and (b)​ (d) Neither (a) nor (b)
Answer :- (b) Design View
re
C

36.​Into how many parts is the query design window divided?

(a) One​ (b) Two​ (c) Three​ (d) Four
Answer :- (b) Two

37.​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
Answer :- (d) A query once created cannot be edited
38.​Which of the following is the shortcut key to run the query?
(a) F3​ (b) F4​ (c) F5​ (d) F6
Answer :- (c) F5

39.​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
Answer :- (d) All of the above

40.​ 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?

ar
(a) >​ (b) <​ (c) ∨​ (d) ∧
Answer :- (a) >

m
Ku
41.​ 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

h
Answer :- (d) Add Form

es
42.​ Which of the following dialog box is present when the Query Design window is opened for the
first time to design a query?
av
(a) Add Table​ (b) Add Query​ (c) Add Table or Query​ (d) None of the above
Answer :- (c) Add Table or Query
Pr

43.​ Which of the following step is not performed if there is no numerical data to be worked upon
r.

in a query?
(a) Selection of fields​ (b) Giving Aliases​ (c) Summarizing​ (d) Selection of tables
:M

Answer :- (c) Summarizing

44.​Which of the following toolbars contains the Label tool?

by

(a)​Standard Toolbar​ (b) Forms Controls Toolbar

(c) Records toolbar​ (d) Formatting toolbar
Answer :- (b) Forms Controls Toolbar
ed

45.​The Record toolbar has the buttons to move to the

at

(a) first record​ (b) second record​ (c) last record​ (d) all records
Answer :- (d) all records
re

46.​Which of the following is NOT true about forms?

C

(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
Answer :- (b) It can contain only text fields

47.​Which of the following keys is pressed to select only textbox on the form?
(a) Alt​ (b) Shift​ (c) Ctrl​ (d) Tab
Answer :- (c) Ctrl
48.​Which key uniquely identify each record?
(a) primary key​ (b) unique key
(c) secondary key​ (d) candidate key
Answer :- (a) primary key

49.​ 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
Answer :- (b) Help Text

ar
50.​ Which of the following objects of LibreOffice Base is used to display data retrieved from one or
more tables in a presentable manner?

m
(a) Query​ (b) Form​ (c) Report​ (d) Panel

Ku
Answer :- (c) Report

51.​Which of the following values of Date Format property is selected to view a calendar on the form?

h
(a) Standard (short)​ (b) Standard (long)​ (c) Default​ (d) Standard (Medium)
Answer :- (b) Standard (long)

es
52.​ Which of the following commands on the Forms Control toolbar is used to toggle between
av
Design View and Form view?
(a) Design Mode​ (b) Toggle Mode​ (c) View Mode​ (d) Print mode
Pr
Answer :- (a) Design Mode

53.​Using which of the following objects in a database, can a report be generated?

r.

(a) Tables​ (b) Queries​ (c) Both a and b​ (d) Neither a nor b
:M

Answer :- (c) Both a and b

54.​Which of the following statement is correct about ‘CREATE’ table command?

by

(a)​It is mandatory to insert at least a single row while creating a table

(b)​we can assign a data type to column even after creating a table
(c)​while creating a table we need to assign a data type to each column
ed

(d)​None of these
Answer :- (c) while creating a table we need to assign a data type to each column
at

55.​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)
re

Answer :- (c) Both (a) and (b)

C

56.​Which of the following best defines "information"?

(a)​Unprocessed raw facts such as names, marks, and addresses.
(b)​ Organized and processed data that provides meaningful
insights. graphics stored without any processing.
(d) A collection of unrelated raw facts.
Answer :- (b) Organized and processed data that provides meaningful insights.
57.​What does referential integrity in a database ensure?
(a)​All primary keys are unique across the database.
(b)​All records in a table must have a value in every column.
(c)​Every foreign key value must match a primary key in the referenced table or be null.
(d)​Data can be freely deleted from any table without constraints
Answer :- (c) Every foreign key value must match a primary key in the referenced table or be null.

58.​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

ar
Answer :- (a) Relational Data Model

m
59.​Which of the following is/are the advantages of database?

Ku
(a) Data Sharing​ (b) Enforcement of standards
(c) Enhanced data security​ (d) All of the above
Answer :- (d) All of the above

h
60.​Which of the following statements are true about primary key in a database?

es
(a)​It is a field that can have duplicate values.
(b)​It uniquely identifies each record in a table.
av
(c)​It can have null values
(d)​It is an optional field in a database table.
Pr
Answer :- . (b) It uniquely identifies each record in a table.

61.​ Which of the following dialog boxes appears when the Query Design window is opened for the
r.

first time to design a query?

:M

(a) Add Table​ (b) Add Query

(c) Add Query or Report​ (d) Add Table or Query
Answer :- (d) Add Table or Query
by

62.​ What feature in OpenOffice Base allows users to present retrieved data in a user-friendly
and formatted manner?
ed

(a) Query​ (b) Form​ (c) Report​ (d) Data view

Answer :- (c) Report
at

63.​ Which of the following is the validation rule that allows values less than or equal to 200 in the
re

field of Roll_No?
(a) >=200​ (b) <=200​ (c) !=200​ (d) >200
C

Answer :- (b) <=200

64.​A ​ is a collection of records that store data in Mail merge.

a. Data Source​ b. Main Document​ c. Document​ d. Merge Field
Answer :- a. Data Source

65.​It enables users to view, enter, and change data directly in database objects.
a. Report​ b. Query​ c. Form​ d. Database
Answer :- c. Form

66.​There are ​ types of Relationships in a table of a database.

a. One​ b. 3​ c. 4​ d. Many
Answer :- b. 3

67.​ A Relational database uses ​ commands which is a standard user application that
provides an easy programming interface for database interaction.
a. Access​ b. Python​ c. SQL​ d. Protocol
Answer :- c. SQL

ar
68.​ Suraj wants to create a database for his clients. For this purpose, she needs to store the Email

m
IDs of his clients. Which datatype should he use to accomplish this purpose?

Ku
a. Numeric​ b. Varchar​ c. Binary​ d. Boolean
Answer :- b. Varchar

h
69.​ Geet has written a SQL query in SQL view. But he doesn’t know how to execute the query
using keyboard keys. Suggest him the shortcut key to complete the task.

es
a. Enter​ b. Ctrl + E​ c. Space bar​ d. F5
Answer :- d. F5
av
70.​A table can have only ​ primary key in a database.
Pr

a. 1​ b. 2​ c. 3​ d. Many
Answer :- a. 1
r.

71.​Which of the following application is not appropriate to store data about ABC Bank customers?
:M

a. Open Office Base​ b. Open Office Writer​ c. MS Access​ d. MS Excel

Answer :- c. Open Office Writer
by

72.​Multiple copies of the same file leads to ​ .

a. Data Inconsistency​ b. Data Redundancy
c. Data Consistency​ d. Foreign Key
ed

Answer :- c. Data Redundancy

at

73.​ Identify the property which help to set the number of characters in text/ varchar type field of a
table in DBMS.
re

a. Entry Required​ b. Size​ c. Default Value​ d. Length

Answer :- d. Length
C

74.​The length of the field value of text data type is ​ characters by default in DBMS.
a. 10​ b. 25​ c. 20​ d. 50
Answer :- d. 50 (in wizard) (100 in Design view)

75.​Database servers are referred to as ​ .

a. Front-ends​ b. Back-ends​ c. Clients​ d. Model
Answer :- b. Back-ends
76.​ A table is a set of data elements that is organized using a model of vertical ​ and
horizontal ​ .
a. Rows, Tables​ b. Columns, Rows​ c. Rows, Columns​ d. Forms, Reports
Answer. b. Columns, Rows

77.​Application Based Questions:-

Q. Consider the table given below and answer the questions that follow:-

ar
(a)​Name the fields in the given table.

m
Answer :- Book_Id, BookName, AuthorName, Price, Publisher
(b)​Which field should be made the primary key?

Ku
Answer :- Book_Id

h
Unit 4 : Maintain Healthy, Safe and Secure Working Environment

es
1.​Workplace safety is essential in organisation ​ .
(a)​to avoid the accident and injury​ (b) to increase the productivity
av
(c) to improve the work environment​ (d) All of the above
Pr

Answer :- (d) All of the above

2.​Which of the following is not mandatory to keep the good health of an employee?
r.

(a) Cleanliness​ (b) Food court​ (c) Clean and fresh air​ (d) Clean washroom
:M

Answer :- (b) Food court

3.​The security department is not responsible for ​ .

by

(a)​personal safety​ (b) computer system and equipment safety

(c) electrical safety​ (d) personal belongings
Answer :- (d) personal belongings
ed

4.​The proper security procedures will increase ​ .

at

(a)​liabilities​ (b) insurance

(c) business revenue​ (d) operational charges of the company
re

Answer :- (c) business revenue

C

5.​Which kind of hazards can occur in IT industry?

(a) Biological​ (b) Chemical​ (c) Physical​ (d) Ergonomic
Answer :- (d) Ergonomic

6.​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
Answer :- (a) Poor sitting postures or excessive duration of sitting in one position

7.​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
Answer :- (c) Using a tool with loose handles

8.​What are the potential cause of hazards at workplace?

(a) Poor ventilation​ (b) Poor lighting

ar
(c) Poor housekeeping​ (d) All of the above
Answer :- (d) All of the above

m
9.​To provide healthy and safety working environment, every organisation must have ​ .

Ku
(a) Cleanliness​ (b) Filtered water​ (c) Clean wash-room​ (d) All of the above
Answer :- (d) All of the above

h
10.​Air pollution is mostly caused by production of the ​ in the surrounding air.

es
(a) dust​ (b) mixture of solid particles​ (c) gases​ (d) All of above
Answer :- (d) All of above
av
11.​Repetitive use of muscle may feel pain in your ​ .
Pr
(a) neck​ (b) shoulder​ (c) wrist or fingers​ (d) All of the above
Answer :- (d) All of the above
r.

12.​The security department organisation is not responsible for ​ .

:M

(a)​other safety​ (b) computer system safety

(c) electrical safety​ (d) transport safety
Answer :- (b) computer system safety
by

13.​Do not wear ​ when working with machines.

(a) jewellery​ (b) safety glasses​ (c) masks​ (d) gloves
ed

Answer :- (a) jewellery

14.​Sore lower back is caused due to ​ .

at

(a)​reaching forward frequently​ (b) no lumbar support

re

(c) no upper back support from chair​ (d) reaching forward for long periods
Answer :- (b) no lumbar support
C

15.​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
Answer :- (d) Blink the eyes

16.​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
Answer :- (d) All of the above

17.​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
Answer :- (d) All of the above

18.​In fire classification, all liquid, grease, and gas material comes under ​ .

ar
(a)​Class A material​ (b) Class B material
(c) Class C material​ (d) Class A material

m
Answer :- (b) Class B material

Ku
19.​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

h
Answer :- (d) Class D material

es
20.​In fire classification, material wood, cloth, and paper comes under ​ .
av
(a)​Class A material​ (b) Class B material
(c) Class C material​ (d) Class D material
Pr
Answer :- (a) Class A material
r.

21.​To provide healthy and safety working environment, every organisation must have ​ .
(a) Cleanliness​ (b) Filtered water
:M

(c) Clean wash-room​ (d) All of the above

Answer :- (d) All of the above
by

22.​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
ed

Answer :- (c) Class C material

23.​When do we use a fire extinguisher?

at

(a)​In case of flood​ (b) In case of electric shock

re

(c) In case of fire​ (d) In case of burn injury

Answer :- (c) In case of fire
C

24.​What is the primary fire emergency telephone number is?

(a) 011​ (b) 101​ (c) 108​ (d) 111
Answer :- (b) 101

25.​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)
Answer :- (d) Both (a) and (b)
26.​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)
Answer :- (d) Both (a) and (b)

27.​What is the main goal of applying ergonomics in an office setting?

(a)​To increase the amount of work done in a shorter time

ar
(b)​To design tasks that are more interesting for employees
(c)​To ensure easy and safe use of equipment, reducing the risk of injury

m
(d)​To promote social interactions among employees

Ku
Answer :- (c) To ensure easy and safe use of equipment, reducing the risk of injury

28.​What should you do with the problem of dry eyes?

(a)​Forget to blink​ (b) Rest eyes periodically and do simple eye exercises

h
(c) Do exercise​ (d) Blink the eyes

es
Answer :- (b) Rest eyes periodically and do simple eye exercises
av
29.​What is one way to mitigate hazards associated with prolonged computer use?
Pr
(a)​Increasing screen brightness​ (b) Stretching at regular intervals or doing simple yoga
(c) Using a smaller screen​ (d) Sitting in a fixed position
Answer :- (b) Stretching at regular intervals or doing simple yoga
r.
:M

30.​ In a situation where a small fire breaks out in the office, what should you use to address
the emergency?
(a) A Blanket​ (b) A Fire Extinguisher​ (c) A Towel​ (d) Baking Soda
by

Answer :- (b) A Fire Extinguisher

31.​The best course of action to take during a medical emergency is to ​ .

ed

(a)​Begin first aid immediately

(b)​Activate the emergency plan for reporting injuries
(c)​Notify the person's family about the situation
at

(d)​Both (a) and (b)

re

Answer :- (d) Both (a) and (b)

32.​Which of the following is a recommended way to manage stress at work?
C

(a)​Engage in aggressive conflicts with colleagues

(b)​Work longer hours without breaks
(c)​Seek conflict resolution strategies with colleagues
(d)​Avoid hobbies that promote relaxation
Answer :- (c) Seek conflict resolution strategies with colleagues

33.​Which of the following can lead to musculoskeletal problems while working on a computer?
(a)​Using anti glare screen​ (b) Sitting in a wrong posture and using an uncomfortable chair
 (c) Using Air Conditioners​ (d) Taking frequent breaks
Answer :- (b) Sitting in a wrong posture and using an uncomfortable chair

34.​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
Answer :- (d) All of the above

ar
m
*************************

Ku
h
es
av
Pr
r.
:M
by
ed
at
re
C