LN . 1 Digital Documentation using LibreOffice Writer.

Chapter 1: Introduction to Styles

1. A _ is a collection of all formatting information in LibreOffice

Writer.
b. Style

2. Writer provides _ different types of Style in LibreOffice Writer.

d. 6

3. What are the different ways where you can access the Style in
LibreOffice Writer.
a. Sidebar, Menu Bar, Style Drop Down list

4. __ Style includes page layout like page size, page margin,

borders and background, footnote and header and footer.
a. Page Style

5. _ Style includes text alignment, tab stops, line spacing and

borders.
b. Paragraph Style

6. Which Style includes text color, highlighting text, text size.

c. Character Style

7. _ style specifying containers size, border, position and how

the text is placed around the picture.
d. Frame Style

8. Which Style includes numbering or bullets in LibreOffice

Writer.
b. List Style

9. Which Style include table related style for example aligning

text inside the table, border color or adding border in LibreOffice
Writer.
d. Table Style

10. The Style and Formatting windows you can open from which
of the following methods.
a. From Style Menu from menu bar
b. Sidebar clicking on Style icon
c. Shortcut Key F11 Function
d. All of the above

11. Which shortcut key is used to open Style and Formatting

windows in LibreOffice Writer.
c. F11

12. What is the fill format in LibreOffice Writer?

a. Allow you to apply styles quickly

13. To apply Style on Writer, which of the following methods is

used to apply quickly.
a. Fill Format

14. Where Fill Format option is available in LibreOffice Writer.

b. In Styles window

15. If existing styles do not match your requirement then it is

also possible to create a __.
c. Custom Style

16. Instead of creating a new style in LibreOffice for small

changes, you can use __ .
b. Update a Style

18. __ method is used to copy styles from an existing template or

document from another document.
b. Load Style
 Chapter 2: Working with Image

20. In a digital document graphic or image is called __.

b. Digital Image

21. Which of the following methods is used to insert images in

documents.
a. Using Image dialog box
b. Using drag and drop option
c. Using Cut, Copy and Paste and by Linking
d. All of the above

22. The image toolbar automatically appears when an image is _.

a. Inserted in the document
b. Selected in the document
c. Both a) and b)

23. If multiple copies of the image you want to insert in

LibreOffice writer, which option will be beneficial.
d. Inserting a Link

24. How many image filters are available in LibreOffice Writer.

b. 11

25. Image can be changed to black and white or gray scale

using __.
b. Invert

26. Which of the following options is used to cut off the non
desirable part of the image.
c. Crop

27. Which of the following filters is used to soften the contrast of

the image.
a. Smooth
28. Which of the following filters is used to increase the contrast
of the image.
c. Sharpen

29. Which of the following filters removes single pixels from the
image.
d. Remove Noise

30. Which of the following filters is used to convert dark appears

light and light appears dark.
b. Solarisation

31. Which filter is used to join the group of pixels into a single
area of one color.
a. Mosaic

32. To resize the image in LibreOffice, which of the following

tools is used to drag the image.
a. Sizing handles

33. To display the Drawing Toolbar in the Writer window you can
click on __.
b. View > Toolbars > Drawing

34. LibreOffice Writer allows combining multiple images in a

single image without affecting their size and position.
a. Grouping Image

35. In LibreOffice Writer how many groups are available in group

options.
d. 4

36. What are the different group options available under

Grouping?
a. Group and Ungroup
b. Enter Group
c. Exit Group
d. All of the above
37. The position of the current drawing in relation to other
drawings or text is determined by __.
a. Arrangement

38. _ allows an image to retain its position to a paragraph, page,

character or frame.
b. Anchoring

39. _ permits the image to be positioned either vertically or

horizontally.
c. Alignment

40. Using the Alignment option the image can be aligned

in __ different styles.
c. 3 Horizontal and 3 Vertical

41. In Text Wrapping there are _ different choices.

d. 6

42. __ permits the positioning of an image in relation to text.

b. Wrap off

43. Which tools are used to flow around the image or rearrange
the text on the page.
a. Page Wrap

44. In __ if the space between image and margin is less then 2 cm

then text will not placed.
c. Optimal Page Wrap

Chapter 3: Advanced Features of Writer

45. Which of the following features is based on different types of

heading styles.
b. Table of Content
46. Which of the following features can be used to keep a track of
different users.
a. Track Change

47. __ allows inserting an automated index in a document.

b. Table of Content

48. LibreOffice Writer supports up to _ levels of headings.

c. 10 Heading

49. Which tools protect the ToC from any accidental change.
a. Protected against Manual Changes

51. A __ is a preset layout that helps to create professional and

formal documents easily.
b. Template

53. Which of the following shortcut keys is used to open the

template dialog box.
c. Ctrl + Shift + N

54. LibreOffice Writer temple gives a blank document as a __.

a. Default temple

55. Which of the following features makes the process of

commenting, editing and reviewing of the document easy
between multiple users.
b. Track Change

56. __ feature of Writer offers an alternative method to keep a

record of all the changes made in the original document.
b. Track Change

57. Once the Track Change feature is ON then the reviewers can
begin recording the changes in the document using _.
a. Record Change

58. Writer allows to compare the original document with the

reviewed document using which of the following tools.
c. Comparing Document

59. Any template can be set as a __.

a. New Template

Ln 2 Electronic Spreadsheet using LibreOffice Calc

Chapter 4 – Analyze Data using Scenarios and Goal

Seek

1. What is the extension of a spreadsheet file in Calc?

d. .ods

2. The LibreOffice Calc can perform _.

a. Analysis automate repeated tasks
b. Calc can create link
c. Calc can share and review data
d. All of the above

3. Which of the following software is best for data analysis.

b. LibreOffice Calc

4. __ is a function which combines data from multiple sheets and

summarizes the information in one place.
b. Consolidating Data

5. __ compare a variety of data in a single spreadsheet to identify

relationships and trends.
b. Consolidating Data
6. What we need to check before consolidating data in
LiberOffice Calc.
a. Data types must match which you want to consolidate
b. Match the levels from all the sheets
c. First column should be primary column
d. All of the above

7. Which option you will select to open Data Consolidation.

a. Data > Consolidate

8. Which function cannot be performed through Subtotal in a

Spreadsheet?
d. Percentage

9. Scenarios are a tool to test questions.

c. What-if

10. _ means combining data in a spreadsheet from different

worksheets into master worksheet
b. Consolidating

11. What is the shortcut key used for opening the consolidated
dialog window.
b. Alt + D

12. If you want to consolidate the sheet by matching the label,

which option will be helpful in consolidating data.
c. Row label and Column label

13. What does “Copy result to” mean when it comes to data
consolidation?
a. Specify where you want to display the result

14. Which of the following options is used to update the data of

the consolidated sheet automatically.
c. Link to source data
15. If you want to consolidate the data by matching the label
which option you will select.
a. Row label and Column labels

16. The consolidated sheet will have all the consolidated data
along with the original data, if you want to view original data of
both the sheets then you can click on _.
b. + Sign

17. _________is a spreadsheet function that is designed to

minimize or maximize a result based on a set of rules that you
describe.
c. Solver

18. In LibreOffice Calc, if you want to collapse to hide data you

can click on the _ sign.
a. – Sign

19. In LibreOffice Calc, if you want to expand data you can click
on the _ sign.
b. + Sign

20. In LibreOffice Calc, if you want to group the data you can
select.
a. Data > Group and Outline

21. In LibreOffice Calc, the Subtotal tool creates the group of

data __.
a. Automatically

22. Which option you will use to open Subtotal in LibreOffice

Calc.
b. Data > Subtotal
23. In LibreOffice Calc Subtotal is used to __.
c. Both a) and b)

24. Subtotal tool can create subtotal for up to _ arrays arranged

in Labeled columns.
a. Three

25. Which of the following tools is used to display hierarchical

structure of the data.
d. Subtotal

26. In the Subtotal tool data can be sorted in the following order.
c. Both a) and b)

27. If you want to remove the outline feature from the sheet then
you can use.
c. Data > Group and Outline > Remove Outline

28. __ is a set of values that can be used within the calculations.

b. Scenario

29. We can shift from one scenario to another by _

a. Navigator

30. Default name of first scenario created in Sheet1 of Calc is __

b. Sheet1_Scenario_1

31. Why what-if analysis tool is used in LibreOffice calc.

b. Depend on different input values and their impact on result

32. Which of the following will not be considered as a What-if

analysis tool in LibreOffice Calc.
a. Scenario
b. Solver
c. Goal Seek
d. None of the above
33. Which tools used to explore and compare various
alternatives depending on changing conditions.
a. Scenario

34. __ is a more elaborate form of Goal Seek.

c. Solver

36. Which of the following tool is used to predict the output while
changing the input.
c. Scenarios

37. How you will open scenarios dialog box from the menu bar.
b. Tools > Scenarios

38. __ tools creates a formula array to display the list of results.

d. Multiple Operation

39. Which of the following tools is also known as a planning tool

for what-if questions.
d. Multiple Operation

40. How you will open Multiple Operations from the menu bar.
c. Data > Multiple Operations

41. The Multiple Operations tool is used to create __ arrays of

cells.
a. 2

42. How to open the Goal Seek dialog box from the LibreOffice
Calc menu bar.
c. Tools > Goal Seek

43. __ helps in finding out the input for the specific output.
c. Goal Seek

Chapter 5 – Using Macros in Spreadsheet

44. A _ is a single instruction that executes a set of instructions.
b. Macro

45. _ tools help to create a sequence of commands or keystrokes

that can be used for any number of times later.
b. Macro

46. Macro recording can be enabled using the _ options in

LibreOffice Calc.
a. Tools > Macros

47. Which of the following actions is not recorded by the Macro.

a. Opening of windows
b. Window switching
c. Actions carried out using mouse
d. All of the above

48. What is the default name of Macro in LibreOffice Calc.

a. Main

49. The name of macro by default is saved in the _.

a. Standard Library in Module 1

50. In LibreOffice Calc, A library is a collection of _.

a. Modules

51. While naming a Macro, Module or a Library the name should

be __.
a. Begin with a letter
b. Not contain space
c. Not contain special characters except underscore
d. All of the above

52. Which of the following is an invalid Macro Name?

d. Format_word
53. To run a macro we need to click on __.
a. Tools > Macros > Run Macro

54. If some formula you want to apply in spreadsheet and there is

no predefined formula for it, what you will do.
a. Create a Macro

55. Macro works like a __.

a. Function

56. The macro’s recorded activity is stored as instructions in the

__ programming language.
a. BASIC

57. The code of a macro begins with Sub followed by the name of
the macro and ends with _.
b. End Sub

Chapter 6 – Linking Spreadsheet Data

58. How you will add comments in the macro programming code.
a. Using single quote

59. To add a new sheet in the spreadsheet, click on the __.

a. (+) sign located in the left button

60. You can insert a new sheet in LibreOffice calc using which of
the following menu options.
a. Sheet > Insert Sheet

61. To refer to a cell in another sheet precede the cell reference

with __ sign.
b. $ Sign
62. When the cell refers to the other sheet __ are used as there is
a space between the sheet name.
a. ‘ ‘

63. In LibreOffice Calc hyperlink can be either _ or .

c. Relative Hyperlink or Absolute Hyperlink

64. In LibreOffice calc it is possible to jump from one sheet to

another spreadsheet or a website by creating __.
c. Hyperlinks

65. _ hyperlink stores the complete location of the file.

b. Absolute Hyperlinks

66. In absolute hyperlink if the file is removed from location to

another then absolute hyperlink will _.
b. Not work

67. A __ hyperlink stores the location with respect to current

location.
a. Relative Hyperlinks

68. You can create hyperlinks using which of the following menu
bars.
a. Insert > Hyperlink

69. How can hyperlinks in Calc be used?

a. to jump from one sheet to a website
b. to jump from one section to another section of the same sheet
c. to jump from one sheet to another sheet
d. All of the above

70. To insert the HTML tables data in the LibreOffice Calc, you
can use which of the following options.
a. External Data
71. Which type of the following Registered Data Sources can be
used in LibreOffice Calc.
a. LibreOffice Base
b. MySQL
c. Microsoft Access
d. All of the above

72. The file path of a file has _ forward slash in LibreOffice Calc.
b. Three

Chapter 7 – Share and Review a Spreadsheet

73. In LibreOffice Calc, one spreadsheet can be used by more

than one user with the help of __.
b. Sharing

74. Which of the following checkboxes you have to mark checked

while sharing the spreadsheet in LibreOffice Calc.
a. Share this spreadsheet with other users

75. Which feature in LibreOffice Calc provides different ways to

record the changes made by one or other users in the
spreadsheet.
c. Record changes

76. Which type of style you can apply to format the comment
box.
a. Background color
b. Border Style
c. Transparency
d. All of the above

77. In LibreOffice Calc, how you will combine two different

versions of the same spreadsheet file.
b. Using Merging

78. In LibreOffice Calc, you can compare the two spreadsheets

by using which of the following options.
a. Comparing