300+ TOP LibreOffice Calc MCQs and Answers Online Test Quiz

LibreOffice Calc Multiple Choice Questions

1. How is the cell selected in LibreOffice Calc defined?
A. A Deep Wide Border
B. A Dotted Border
C. A Blinking Border
D. By Italic text

Answer: A

2. What is the shortcut key to move from one cell to another in LibreOffice Calc?
A. Tabs
B. Ctrl + Q
C. Ctrl + M
D. None

Answer: A

3. In LibreOffice Call, there are some numbers in cell A1, A2, A3, A4. What will be the cell address when transpose them?
A. A1, B1, C1, D1
B. B1, C1, D1, E1
C. B1, B2, B3, B4
D. A1: B4

Answer: A

4. Which of the following is used to convert a row into a column?
A. Row to column
B. Transpose
D. Convert
D. Reverse

Answer: B

5. How to edit cell in LibreOffice Calc spreadsheet, or what shortcut key will be used to edit the cell?
A. F1
B. F2
C. F12
D. None

Answer: B

6. Which shortcut key will be used to edit the current cell?
A. Ctrl + F4
B. F3
C. F2
D. None

Answer: C

7. What is the shortcut key to close LibreOffice spreadsheet?
A. Ctrl + Shift + E
B. Ctrl + H
C. Ctrl + T
D. Ctrl + Q

Answer: D

8. Which of the following charts is not in the chart menu?
A. Pie Chart
B. Bar Chart
C. Line Chart
D. Square Chart

Answer: D

9. Which of the following charts is used to display a data series?
A. Column
B. Buble
C. Pie
D. None

Answer: C

10. How many types of charts are available in LibreOffice Calc?
A. 9
B. 10
C. 11
D. 12

Answer: B

11. In LibreOffice Calc, is the extension name of the template file?
A.. ods
B. .Xlsx
C. .Xlt
D. .Ots

Answer: D

12. What will be the value of ‘= Average (3,4,5)’?
A. 3
B. 4
C. 6
D. 8

Answer: B

13. In LibreOffice, give the value of ‘= Average (1, 2, 4, 9)’?
A. 1
B. 3
C. 4
D. 5

Answer: C

Q.14. Which of the following is the correct function?
A. = Average (5,8,9)
B. = Average (G2, G5, R4)
C. = Average (2 + 3 + 5)
D. a and b

Answer: D

15. Is the correct formula for extracting average in Microsoft Excel?
A. = Average ()
B. = Averg ()
C. = Averagee ()
D. None

Answer: A

16 In the LibreOffice Calc spreadsheet, what is the font size found in the font size dropdown-menu?
A. 27
B. 25
C. 23
D. 28

Answer: D

17. What is the shortcut key to clear direct format in Libra Office Calc?
A. Ctrl + V
B. Ctrl + Shift + M
C. Ctrl + M
D. Ctrl + N

Answer: C

18. What will be the value of ‘= 256 / min (5,0,8)’?
A. # div / 0!
B. 0
C. 8
D. 5

Answer: A

19. Which of the following options is used to show the current date?
A. Today
B. Now
C. Date
D. None

Answer: B

20. What does SUMIF Function do?
A. Adds up cell values ​​based on a condition
B. Adds all numbers in a range of cells
C. Returns a subtotal in a list or database
B. All of above

Answer: A

21. What will be the value of ‘= SUM (A1: B2)’? If A1 = 1, A2 = 2, B1 = 3, B4 = 5.
A. 3
B. 5
C. 6
D. 10

Answer: C

22. What will be the value of ‘= SUM (2 (PRODUCT (3,7))’?
A. 41
B. 42
C. 43
D. 44

Answer: B

23.Select the correct formula from the following-
A. = Sum (D1: D2)
B. = Sum (D1? D2)
C. SUM (D1: D2)
d. All of the above

Answer: A

24. What will be the value of ‘= SUM (5,2)’?
A. 3
B. 7
C. 10
D. 25

Answer: B

25. The correct formula is to add cells B6, B8, B10?
A. = SUM (B6, B8, B10)
B. = SUM (B6: B8: B10)
C. = SUM (B6-B8-B10)
D. = SUM (B6, B8.B10)

Answer: A

26. Calculates the sum of cells from B10 to B14 and adds the value of B8, then what will be the formula?
A. = SUM (B12: B14) + B8
B. = SUM (B10: B14) + B8
C. = SUM (B11: B14) + B8
D. None

Answer: B

27. Which is the function used in the ‘= SUM (A1: A2)’ formula?
A. logical
B. text
C. numerical
D. Mathematical

Answer: D

28. Which of the following can represent a column in LibreOffice Calc?
A. 1,2,3,4
B. A, B, C, D
C. A1, B1, C1
D. 1A, 1B, 1C

Answer: B

29. Which of the following can represent Row in LibreOffice Calc?
A. 1,2,3,4
B. A, B, C, D
C. A1, B1, C1
D. 1A, 1B, 1C

Answer: A

30. The maximum width of a column can be?
A. 100
B. 200
C. 300
D. 400

Answer: A

31. The formula in LibreOffice Kalka starts with?
A. ?
B. @
C. =
D. None

Answer: C

32. 1 or more worksheets are found in LibreOffice Calc ……….
A. Template
B. Workbook
C. Worksheet
D. cell

Answer: B
Libreoffice English Mcq

33. What will be the value of ‘= Ceiling (120,22)’?
A. 231
B. 121
C. 120
D. 111

Answer: B

34. Where is the Goal Seek option in LibreOffice Calc?
A. Windows
B. Tools
C. Data
D. Format

Answer: C

35. Which shortcut key is used to go to the front seat in LibreOffice Calc?
A. Ctrl + A
B. Ctrl + S
C. Ctrl + Tab
D. Ctrl + T

Answer: C

36. Which shortcut key will be used to go to the back seat in LibreOffice Calc?
A. Ctrl + Tab
B. Ctrl + Shift + Tab
C. Both
D. None

Answer: B

37. Which command is used to uppercase text written in lower case?
A. Cycle case
B. = Proper (text)
C. = Upper (text)
D. None

Answer: C

38. Which shortcut key is used to go to the back row in LibreOffice Calc?
A. Ctrl + Tab
B. Shift + Tab
C. Alt + Tab
D. Shift + Enter

Answer: D

39. By what other name is the formula bar known in LibreOffice Kalk?
A. function bar
B. Name box
C. input line
D. none of these

Answer: C

40. Which side of the legend appears by default in Bar Chart?
A. right
B. left
C. in the middle
D. below

Answer: A

41. Ctrl + F2 shortcut key is used for?
A. Function Wizard
B. format cell
C. print preview
D. none of these

Answer: A

42. Which menu will be required to comment in LibreOffice Calc?
A. Insert
B. View
C. Format
D. Data

Answer: A

43. If the cell address changes after copying the formula, then the address is known as ……….
A. Absolute address
B. Relative Address
C. Mixed Address
D. Dynamic address

Answer: B

44. In which menu is the option of Donnet found in LibreOffice Writer or Kalk?
A. Edit
B. View
C. Help
D. None

Answer: C

45. What is the number of by default rows and columns in LibreOffice Calc?
A. 1048576, 16384
B. 1048576, 1024
C. 65536, 256
D. None

Answer: B

46. What is the address of last cell in LibreOffice Calc?
A. AMJ1024
B. AMJ1048576
C. XFD1048576
D. XFD1024

Answer: B

47. What is the last row and column name in Libreoffice Calc?
A. 1048576, AMJ
B. 1048776, AMH
C. 1048556, AME
D. 1047576, AMJ

Answer: A

48. What is the shortcut key to save as in LibreOffice spreadsheet?
A. Shift + Alt + S
B. Ctrl + S
C. Ctrl + Shift + S
D. None

Answer: C

49. In the LibreOffice call, is there a shortcut key to select the entire column?
A. Ctrl + Space
B. Ctrl + Shift + Space
C. Shift + Space
D. None

Answer: A

50. To insert columns in LibreOffice call it has to be used?
A. format
B. seat
C. Style
D. Insert

Answer: B

51. Which of the following formula is correct?
A. Max (A1, A2)
B. Max (A1: A2)
C. = Max (A1, A2)
B. = Max (A1: A2)

Answer: D

52. What is the total number of Row in LibreOffice call?
A. 1048575
B. 1048576
C. 1048577
D. 1048578

Answer: B

53. Shortcut key to insert cell in Libreoffice Calc?
A. Ctrl + shift + +
B. Ctrl + +
C. Alt + +
D. Ctrl + –

Answer: B

54. Shortcut key ‘Ctrl + -‘ used for?
A. Delete row
B. Delete column
C. Delete sheet
D. Delete cell

Answer: D

55. Currently you are on a G7 cell in a Libreoffice Calc spreadsheet, which of the following will you be in after pressing the Home key of the keyboard?
A. A1
B. A7
C. F7
D. G1

Answer: A
Libreoffice Calc Questions English

56. What is the shortcut key to full screen Libreoffice Calc?
A. Ctrl + Shift + J
B. Ctrl + Shift + G
C. Ctrl + Alt + G
D. None

Answer: A

57. Which shortcut key will be used to go to the bottom ROW in the spreadsheet?
A. Ctrl + Down Arrow
B. Ctrl + Shift + Down Arrow
C. Both
D. None

Answer: A

58. What is the minimum font size in LibreOffice call?
A. 4
B. 5
C. 6
D. None

Answer: C

59. What is the maximum font size in LibreOffice call?
A. 104
B. 65
C. 96
D. None

Answer: C

60. What is the default size of a font in Libreoffice Calc?
A. 10
B. 12
C. 14
D. 18

Answer: A

61. What will be the value of ‘= Product (35, -8)’?
A. -280
B. 280
C. 276
D. -329

Answer: A

62. What will be the value of ‘= Product (2, sum (5,7))’?
A. 14
B. 24
C. 17
D. None

Answer: B

63. Which function in Libreoffice Calc only shows Date?
A. Now ()
B. Today ()
C. Weekdays ()
D. None of the above

Answer: B
Libreoffice Calc English Questions And Answers

64. What is the shortcut key for inserting date in Libreoffice Calc?
A. Ctrl +;
B. Ctrl +:
C. Shift +;
D. None

Answer: A

65. How many types of ‘cell references’ are there in LibreOffice Calc?
A. 1
B. 2
C. 3
D. 4

Answer: B

66. What is made at the place where the column and row cut each other?
A. Cell
B. Formula
C. Column
D. None

Answer: A

67. Will this option be used to divide any table into different parts?
A. Split cell
B. Split row
C. Split column
D. Split table

Answer: D

68. The shortcut key to access A1 Cell is?
A. Ctrl + Home
B. Shift + Home
C. Home
D. Ctrl + Page up

Answer: A

69. Non-numeric Libreoffice Calc occurs in which element?
A. Right
B. Left
C. Center
D. Justified

Answer: B

70. Which bar is at the top of LibreOffice Calc?
A. status bar
B. Manubar
C. title bar
D. format bar

Answer: C
Libreoffice Calc Mcq Questions In English

71. What will be the value of ‘= ROUND (1762.667, -2)’?
A. error
B. 1700
C. 1762.67
D. 1800

Answer: D

72. What is the shortening type in LibreOffice Calc?
A. two
B. three
C. four
D. five

Answer: A

73. In LibreOffice Calc, which key is used along with the control key to create a new line or paragraph inside the cell?
A. Alt
B. Ctrl
C. Shift
D. Enter

Answer: D

74. What is the shortcut key to select cells in Libreoffice Calc?
A. Ctrl + 1
B. Ctrl + Shift + 1
C. Ctrl + A
D. Shift + D

Answer: C

75. Which is the easy way to select a column?
A. Ctrl + A shortcut key
B. Double clicking on any cell in the column
C. Selecting by dragging from the topmost cell of the column to the bottom
D. Clicking on the column heading and selecting

Answer: C

76. What does this ###### display in the cell?
A. The width of the cell is insufficient from the performance of the material.
B. The formula is incorrect.
C. data is not valid
D. none

Answer: A

77. Which shortcut key will be used to open the dialog box that formats the cell in LibreOffice Calc?
A. Alt + 1
B. Ctrl + 1
C. Alt + Shift + 1
D. None

Answer: B
Libreoffice Calc Questions And Answers In English

78. How many seats are there by default in the work book of LibreOffice Calc?
A. 1
B. 2
C. 3
D. 4

Answer: A

79. What is the number of seats by default in LibreOffice 6.0 Calc?
A. 1
B. 2
C. 3
D. 4

Answer: A

80. The formula that will be multiplied by the value of B2 years after adding the value of cell C2 with the value of D4?
A. (D4 + C2) * B2
B. D4 + C2 * B2
C. = (D4 + C2) * B2
D. = [(B2 * (D4 + C2)]]

Answer: C

81. What is the maximum cell height in Libreoffice calc?
A. 3.37 Inches
B. 39 Inches
C. 39.37 Inches
D. None

Answer: C

82. What is the default width of the column in the libre office column?
A. .18 inch
B. .89 inch
C. 1.28 inch
D. 1.05 inch

Answer: B

83. What will be the value of ‘= Floor (15257, -5)’?
A. 16000
B. 15000
C. Error
D. 16257

Answer: C
Libreoffice Calc Practical Questions

84. There are shortcut keys to cut in Libreoffice Calc?
A. Shift + X
B. Ctrl + X
C. Ctrl + Alt + X
D. Ctrl +0

Answer: B

85. How many worksheets are there in LibreOffice Calc?
A. 32000
B. 48000
C. 60000
D. no limit

Answer: A

86. Calc has shortcut keys to add a1 + a2?
A. = A1 + A2
B. = Add (a1 + a2)
C. = Max (a1 + a2)
D. None

Answer: A

87. Which Zoom cannot be done in LibreOffice Calc?
A. 100%
B. 300%
C. 400%
D. 500%

Answer: D

88. Which of the following zoom libre office is of Kalk?
A. 20% to 400%
B. 20% to 600%
C. 10% to 500%
D. 5% to 3000%

Answer: A

89. What is the maximum zoom in LibreOffice Calc?
A. 400%
B. 500%
C. 600%
D. 700%

Answer: A

90. Maximum value in A1 to A4?
A. = Max (A1; A4)
B. = Max (A1: A4)
C. = Max (A1, A4)
D. None

Answer: B

91. Which of the following is not a financial function?
A. FV ()
B. SUM ()
C. NPV ()
D. PMT ()

Answer: B
English Libreoffice Calc Questions

92. What will be the value of ‘= Min (5,2,4) / Count (a, B.’?
A. 1
B. 12
C. 11
D. #div!

Answer: D

93. M.S. What is the maximum number of Zoom you can do in Excel?
A. 400
B. 500
C. 600
D. 3000

Answer: A

94. What is the alignment of numbers in Libre Office Calc?
A. Right
B. Left
C. Center
D. All

Answer: A

95. What cannot be done with the formula in Libreoffice Calc?
A. Numeric Add
B. Circulr Refrence
C. A and B
D. Only Text

Answer: C

96. What will be the value of ‘= QUOITENT (5,2)’?
A. 2
B. 5
C. 7
D. 10

Answer: A

97. What is the page orientation of LibreOffice Calc?
A. Horizontal
B. landscape
C. Portrait
D. none of the above

Answer: C

98. From which menu is the text color changed in LibreOffice Calc?
A. edit
B. formatting
C. Style
D. view

Answer: B
Libreoffice Calc Questions In English

99. Which shortcut key is used to increase the width of columns in LibreOffice Calc?
A. Alt + Left Arrow
B. Alt + Right Arrow
C. Both
D. None

Answer: B

100. What is the default font name of LibreOffice Calc?
A. Times New Roman
B. Liberation Sans
C. Liberation Serif
D. Calibri

Answer: B

101. If we use the function ‘= COUNT (‘ A ‘,’ B ‘,’ C ‘, 1,2)’ what will be the result?
A. 2
B. 3
C. 4
D. 5

Answer: A

102. What is Libre office Calc file extension name?
A. .odt
B. .ods
C. .odb
D. .odm

Answer: B

103. Identify the correct formula from the following?
A. = 5 (2 * (6/2)
B. = 5 (2 * 6/2))
C. 5 (2 * (6/2)
D. = 5 (2 * [6/2]

Answer: B

104. What will be the value of ‘= Quotient (509.8,7)’?
A. 72
B. 73
C. 77
D. 80

Answer: A

105. What will be the value of ‘= Power (5,2)’?
A. 25
B. 125
C. 4
D. 2

Answer: A

106. Which menu is used for Wizard in LibreOffice Calc?
A. File
B. Insert
C. Edit
D. None

Answer: A
Libreoffice Calc Questions And Answers

107. Which menu will be used to image Libreoffice in Kalk?
A. File
B. Insert
C. View
D. Table

Answer: B

108. Clicking on the column name in LibreOffice Call is selected in the entire column.
A. True
B. False

Answer: A

109. Can Ctrl + W close Excel’s workbook?
A. True
B. False

Answer: A

110. Columns in Libreoffice Calc can have different widths?
A. True
B. False

Answer: A

111. Count function (= COUNT ()) of LibreOffice Calc contains both word and number count?
A. True
B. False

Answer: B

112. Can Libreoffice increase the width of a single selected row in Calc?
A. True
B. False

Answer: A

113. Can unlimited rows be added to LibreOffice Calc?
A. True
B. False

Answer: B

114. Can a chart be inserted in Libreoffice Calc?
A. True
B. False

Answer: A

115. Can a cell be edited when the Libreoffice Calc window is full screen?
A. True
B. False

Answer: A

116. Can 2 workbooks have the same name in a spreadsheet?
A. True
B. False

Answer: B

117. In LibreOffice Calc, entire sheet can be selected at once?
A. True
B. False

Answer: A

118. Can we hide Row in LibreOffice Calc?
A. True
B. False

Answer: A

119. Ctrl + Shift + Arrow UP shortcut key is used to select the column from the current cell to the first cell?
A. True
B. False

Answer: A

120. Are Row and Column the same?
A. True
B. False

Answer: B

121. There is no option of mail merge in spreadsheet?
A. True
B. False

Answer: A

122. Can I put a password on a file saved on a Libreoffice spreadsheet?
A. True
B. False

Answer: A

123. In LibreOffice Calc, the + is used before the formula?
A. True
B. False

Answer: B

124. Cannot add Header and Footer in Libreoffice Calc?
A. True
B. False

Answer: B
Libreoffice Calc English Mcq Questions

125. Can the column in Libreoffice Calc be reduced or enlarged?
A. True
B. False

Answer: A

126. Libreoffice Calc does not allow to open more than one Document?
A. True
B. False

Answer: B

127. The shortcut key to add a comment in LibreOffice Calc is Ctrl + Alt + C?
A. True
B. False

Answer: A

128. By default grid line is printed in LibreOffice Calc?
A. True
B. False

Answer: B

129. The cells of a single column of LibreOffice Calc Spreadsheet can have different widths?
A. True
B. False

Answer: B

130. In LibreOffice Calc, the maximum zoom is up to 100 percent.
A. True
B. False

Answer: B

131. Can the chart added to LibreOffice Calc be seen in 3D?
A. True
B. False

Answer: A

132. Page margin cannot be set while printing the LibreOffice Call Spreadsheet?
A. True
B. False

Answer: B

133. If the spreadsheet is hidden in the program then it remains in it?
A. True
B. False

Answer: A

134. Can you view the print preview in LibreOffice Calc by zooming in?
A. True
B. False

Answer: A

135. Can I view recent open document in LibreOffice Calc?
A. True
B. False

Answer: A

136. Can you put formula in any cell using F2 key in LibreOffice call?
A. True
B. False

Answer: B

libreoffice calc mcq questions

1. Which shortcut key is used for reach to last edit cell in LibreOffice Calc?
A. Ctrl+Home
B. Ctrl+End
C. Ctrl+H
D. Alt+Ctrl+O
Answer: Ctrl+End

2. What is the output of the calc expression is = 100/10/2?
A. 5
B. 25
C. 50
D. 200
Answer: 5

3. Shortcut key used to opens the function wizard in LibreOffice Calc is ………………
A. Alt+F1
B. Ctrl+F6
C. F2
D. Ctrl+F2
Answer: Ctrl+F2

4. The combination of the column letter and row number for a cell in an Calc spreadsheet is called ……………
A. Cell across
B. Cell reference
C. Cell identify
D. Cell Identification number
Answer: Cell reference

5. Which key is used to opens manage template in LibreOffice calc?
A. Ctrl+T
B. Ctrl+F1
C. Ctrl+O
D. Ctrl+Shift+N
Answer: Ctrl+Shift+N

6. What is the file extension of LibreOffice Calc spreadsheet?
A. .ods
B. .xlx
C. .odp
D. .odt
Answer: .ods

7. What is the maximum number of characters in one cell in calc spreadsheet?
A. 6000
B. 32767
C. 255
D. 1021
Answer: 32767

8. How many spreadsheets on LibreOffice calc by default?
A. 0
B. 1
C. 2
D. 3
Answer: 1

9. What will result from adding = A1+A2 to calc?
A. 0
B. 1
C. 10
D. 5
Answer: 0

10. what is the maximum number of cell per spreadsheets in calc?
A. 6000
B. 1000
C. 1073741824
D. 1048576
Answer: 1073741824

11. What is the maximum zoom percentage in LibreOffice Calc?
100%
200%
400%
500%
Answer: 400%

12. What is the maximum zoom percentage in LibreOffice Calc?
100%
200%
400%
500%
Answer: 400%

13. F7 key is used for spell check in the current sheet.
True
False
Answer: True

14. Which shortcut key is used to insert comment in LibreOffice Calc?
Ctrl+Alt+C
Ctrl+Shift+J
Ctrl+Alt+S
None of the above
Answer: Ctrl+Alt+C

15. The LibreOffice Calc is similar to Microsoft Excel, with almost the same abilities.
True
False
Answer: True

16. Ctrl+Shift+J is used for full screen mode in LibreOffice Calc.
True
False
Answer: True

17. Ctrl+F1 is used to display comments that is attached to the current cell.
False
True
Answer: True

18. Page down key is used to moves the viewable rows down one screen.
True
False
Answer: True

19. =A1+10 displays the contents of cell A1 plus 10.
True
False
Answer: True

20. Which short cut key is used to insert function in LibreOffice Calc?
Ctrl+F3
Ctrl+F1
Ctrl+F2
Ctrl+F4
Answer: Ctrl+F2

21. In LibreOffice package, spreadsheet is called ……………
Excel
Row
Column
Calc
Answer: Calc

22. How many numbers of rows in the LibreOffice Calc spreadsheet?
1048575
1048578
1048576
1048577
Answer: 1048576

23. Which shortcut key is used to delete cell?
Ctrl+-
Ctrl++
Ctrl+=
Ctrl+|
Answer: Ctrl+-

24. Which shortcut key is used to insert cell in LibreOffice Calc?
Ctrl+-
Ctrl+=
Ctrl++
Ctrl+|
Answer: Ctrl++

25. How many number of columns in LibreOffice Calc Spreadsheet?
1000
1024
1020
1025
Answer: 1024

26. …………. menus are found in LibreOffice Calc.
5
6
7
9
Answer: 9

27. ………………… is used to opens the Thesaurus if the current cell contains text.
Ctrl+F7
Ctrl+F6
Ctrl+F8
Ctrl+F9
Answer: Ctrl+F7

28. ………………………. option is found in Edit Menu in LibreOffice Calc.
Find
Replace
Share
Both Find & Replace
Answer: Both Find & Replace

29. What is the minimum font size in LibreOffice Calc?
1
2
3
5
Answer: 2

30. …………… is used to highlight cells containing numeric valuses.
Ctrl+F7
Ctrl+F6
Ctrl+F8
Ctrl+F5
Answer: Ctrl+F8

LibreOffice Calc objective questions with answers pdf download online exam test

Multiple choice Questions

• Which of the following technique can be used to allow only date value in cell ?
  1. Data formatting    
  2. Data sorting
  3. Data filtering
  4. Data validation
• Which of the following options when selected deletes all data validation?
  1. Delete formatting
  2. Delete all
  3. Delete formula
  4. Delete me
• We can replace multiple occurrences of a word using which of the following facilities of Calc?
  1. Find and replace
  2. By copy only
  3. By copy command
  4. By preview command
• What is the name of a mechanism to arrange the data in a particular order?
  1. Sorting
  2. Searching
  3. Filtering
  4. Validating
• What is the name of mechanism to filter out unnecessary data?
  1. Sorting
  2. Searching
  3. Filtering
  4. Validating
• Which of the following type of package does Calc refer to ?
  1. Spreadsheet
  2. Double sheet
  3. Multi-sheet
  4. Cannot determine
• Which of the following is an extension of a worksheet created in Calc?
  1. .ods
  2. .odd
  3. .xls
  4. .obj
• How can one calculate the total of values entered a worksheet column of?
  1. By manual entry
  2. By auto-sum
  3. By formula
  4. By sum functions
• What is the correct way to enter a function in Calc?
  1. Directly typing function name in a cell
  2. Using function wizard to selecting from toolbar
  3. Both (a) and (b)
  4. Depends on the function
• A function should start with                              
  1. ̔= ̓ sign
  2. alphabets
  3. numbers
  4. All of the these
• Which of the following option is used to print a chart?
  1. Insert → Chart
  2. File → View
  3. File→ Print
  4. View → Chart
• How many axes does chart in Calc have?
  1. Two
  2. Three
  3. Two or Three
  4. Four

LibreOffice Calc MCQ

• The chart preview can be seen in .
  1. Page preview
  2. Chart preview
  3. Export chart
  4. All of these

• What is theshortcut key of print preview in LibreOffice Calc?

1. Ctrl + Shift + P
2. Ctrl + P
3. Ctrl + Shift + O
4. None

• Which key will be used to select the entire seat in LibreOffice calc?

1. Ctrl + A
2. Ctrl + Shift + A
3. Ctrl + shift + Space
4. a & b both

• Which key do you use to edit the cell in edit mode?

1. Ctrl + Shift + M
2. Ctrl + M
3. F3
4. F2

• Cannot do maximum Zoom in LibreOffice Calc

1. 200%
2. 500%
3. 300%
4. 400%

• Which shortcut key do you use for cell  formatting in LibreOffice Calc

1. Ctrl + M
2. Ctrl + F2
3. Ctrl + 2
4. Ctrl + 1

• How many columns are there in LibreOffice Calc

1. 1048576
2. 16384
3. 1024
4. None

• Which shortcut key do you use to insert time in libreOfficecalc

1. Ctrl + Shift +
2. Ctrl + T
3. Ctrl +;
4. None

• In which menu is the Merge Cells command found in LibreOffice Calc ?

1. Edit
2. Style
3. Sheet
4. Format

• LibreOffice Calc has number left alignment and alphabet right alignment.

1. True
2. False

• In LibreOffice Calc , what is the value if there is a larger value than the cell

1. ####
2. ###
3. The    cell becomes large and the value is correct
4. #Name?

• What is the shortcut to delete a cell?

1. Ctrl + D
2. Ctrl + –
3. Ctrl + +
4. Delete

• Which shortcut key do you use to select the entire row

1. Shift + Space
2. Ctrl + Shift + Page down
3. Ctrl + Space
4. None

• Which key do LibreOffice use to insert a function in calc

1. Ctrl + F4
2. Ctrl + F3
3. Ctrl + F2
4. None

• Round and Truncate  functions are the same

1. True
2. False

• What is the default file extension in LibreOffice Calc  ?

1. .ods
2. .odp
3. .odt
4. .xlsx

• By what name is the LibreOffice Calc file saved by default ?

1. Spreadsheet1
2. Calc1
3. Untitled1
4. None

• Which key do you use to comment in LibreOffice

1. Ctrl + Alt + C
2. Ctrl + Shift + T
3. Ctrl + Shift + C
4. Ctrl + C

• What is a Cycle Case

1. Sentence Case
2. Lower case
3. Upper case
4. All of above

• What will be the value of Product (7, 8) ?

1. 15
2. 56
3. 1
4. -1

• Which key do you use to move to the next seat

1. Ctrl + Tab
2. Ctrl + Shift + Tab
3. Tab
4. Shift + Tab

• LibreOffice can convert entire cell into a cell in calc 

1. False
2. True

• Which shortcut key do you use to full screen in LibreOffice

1. Ctrl + Shift + J
2. Ctrl + Shift + F
3. Ctrl + Shift + F
4. None

• Which shortcut key do you use to highlight a value in LibreOffice Calc 

1. Ctrl + F8
2. Ctrl + F6
3. Ctrl 
4. Ctrl + F1

• Where a cell’s address appears in LibreOffice Calc 

1. Address Book
2. Name box
3. Formula Bar
4. None

• In LibreOffice Writer, mail merge option is in which menu?

1. Insert
2. Tools
3. Format
4. Form

• Which key is used with the control to create a new line or paragraph inside the cell of LibreOffice Calc?

1. Tab
2. Shift
3. Enter
4. Alt

• LibreOffice Calc Formula always start with a Symbol?
• &
• %
• =
• $
• How Many types of Cell Reference are there in LibreOffice Calc?
  1. 3
  2. 1
  3. 4
  4. 2
• What is the maximum number of worksheets LibreOffice Calc Can have?

1. 10000
2. 256
3. 1028
4. None

• What is the shortcut key to open the Cell Format dialog box in Libreoffice Calc?
  1. Ctrl + Alt + 1
  2. Alt + 1
  3. Ctrl + 1
  4. Shift + 1

• LibreOffice is the shortcut to insert a function in Calc?
  • Ctrl + F2
  • Shift + F3
  • Alt + F3
  • Ctrl + F3
• Which categories of functions are COS, EVEN, FACT, EXP in LibreOffice Calc?
  • Math / string
  • Mathematical
  • String
  • Data
• What is the shortcut key of print preview in LibreOffice Calc?
  • Ctrl + Shift + O
  • Ctrl + Shift + P
  • Ctrl + P
  • None
• What key do LibreOffice use to insert a function in calc?
  • Ctrl + F3
  • Ctrl + F2
  • Ctrl + F4
  • None
• LibreOffice Calc What is the default file extension?
  • .Xlsx
  • .odp
  • .ods
  • .odt
• Which shortcut key do you use to insert time in LibreOffice Calc?
  • Ctrl + Shift + ;
  • Ctrl + ;
  • Ctrl + T
  • None
• Which shortcut key do you use for cell formatting in LibreOffice Calc?
  • Ctrl + M
  • Ctrl + 1
  • Ctrl + F2
  • Ctrl + 2
• In which menu is the Merge Cells command found in LibreOffice Calc?
  • Style
  • Sheet
  • Format
  • Edit
• Which key do you use to convert a number into currency format in LibreOffice Calc?
  • Ctrl + Shift + 1
  • Ctrl + Shift + 3
  • Ctrl + Shift + 4
  • Ctrl + Shift + 5
• LibreOffice is the shortcut to clear the direct format in Calc?
  • Ctrl + M
  • Ctrl + V
  • Ctrl + 1
  • Ctrl + Shift + F
• Which shortcut key do you use to highlight a value in LibreOffice Calc?
  • Ctrl + F8
  • Ctrl + F1
  • Ctrl + F6
  • Ctrl
• Where does the address of a cell appear in LibreOffice Calc?
  • Name box
  • Formula bar
  • Address book
  • None
• Which key will be used to select the entire seat in LibreOffice Calc?
  • Ctrl + Shift + Space
  • Ctrl + Shift + A
  • Ctrl + A
  • a & b both
• LibreofficeCalc Select a cell to break a merged cell …… ..button click?
  • Splide
  • Center
  • Merge and center
  • Split and merge
• What do you do to write in LibreOffice Calc from Monday to Sunday?
  • =Week () use the function
  • Press inter on Monday
  • Holding down Monday, holding down the right corner and pulling it down
  • All of the above
• Which key do Libreoffice Calc use to move to the left (one step back) of a cell?
  • Shift + Tab
  • Alt
  • Tab
  • Alt + Tab
• What is the address of the last column in LibreOffice Calc?
  • EMJ
  • AMJ
  • AMG
  • XFD
• What is formed by adding libreoffice Calc rows and columns?
  • DATA
  • CELL
  • TABLE
  • POSITION
• Which sign is visible when there is a formula error in Libreoffice Calc?
  • #
  • $
  • *
• What will be the value of = 10 * 20/4 * 8 in LibreOffice Calc?
  • 7
  • 400
  • 500
  • 25
• LibreOffice Calc has number left alignment and alphabet right alignment?
  • True
  • False
• Libreoffice Calc has alphabet right and numbers left align?
  • Ture
  • False
• LibreOffice Calc by default provides an auto calculator feature that displays as if in a selected range range?
  • True
  • False
• Can LibreOffice convert entire cell into a cell in calc?
  • True
  • False
• In LibreOffice Calc and Writer do Ctrl + D have the same function?
  • True
  • False

  Fill in the blanks

1. The column  immediately  next  to  column    “Z”  is AA
2. The default extension of a workbook created using a LibreOffice Calc spreadsheet is .ods .
3. The spreadsheet feature used to continue the series is called as fill handle.
4. The formula ‘’=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to  =min(d1:d5)
5. The formula in cell A2 is = B2+C3. On copying this formula to cell C2, C2 will change to =d2+e3
6. The cell address of the cell formed by the intersection of the ninth column and the eight row will be 18.
7.  $A1$B2 is an example of mixed referencing in spreadsheet software .
8.  Number entered into a cell are automatically  right aligned.
9.  If A1:A5 contain the number 16 , 10, 3, 25 and 6 then = Average(A1:A5;60) will display 20.
10. In Relative referencing, the reference changes rows and columns automatically when it is copied to a new cell.