01st
Feb
LibreOffice Calc MCQ

LibreOffice Calc MCQ

  • Admin
  • 01st Feb, 2023
  • 600 Followers

Take LibreOffice Calc MCQ Test to Test your Knowledge

Practice top LibreOffice Calc MCQ Questions that check your basic knowledge of LibreOffice Calc. This LibreOffice Calc MCQ Online Test contains 30 Multiple Choice Questions. also download the LibreOffice Calc MCQ Pdf completely free.

LibreOffice Calc MCQ Online Test

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

2) What is the output of the calc expression is = 100/10/2?

  • A. 5
  • B.25
  • C.50
  • D.200

3) Shortcut key used to opens the function wizard in LibreOffice Calc is ..................

  • A. Alt+F1
  • B.Ctrl+F6
  • C.F2
  • D.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

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
Download Free : LibreOffice Calc MCQ PDF

6) What is the file extension of LibreOffice Calc spreadsheet?

  • A. .ods
  • B..xlx
  • C..odp
  • D..odt

7) What is the maximum number of characters in one cell in calc spreadsheet?

  • A. 6000
  • B.32767
  • C.255
  • D.1021

8) How many spreadsheets on LibreOffice calc by default?

  • A. 0
  • B.1
  • C.2
  • D.3

9) What will result from adding = A1+A2 to calc?

  • A. 0
  • B.1
  • C.10
  • D.5

10) what is the maximum number of cell per spreadsheets in calc?

  • A. 6000
  • B.1000
  • C.1073741824
  • D.1048576

11) What is the maximum zoom percentage in LibreOffice Calc?

  • A. 100%
  • B.200%
  • C.400%
  • D.500%

12) What is the maximum zoom percentage in LibreOffice Calc?

  • A. 100%
  • B.200%
  • C.400%
  • D.500%

13) F7 key is used for spell check in the current sheet.

  • A. True
  • B.False

14) Which shortcut key is used to insert comment in LibreOffice Calc?

  • A. Ctrl+Alt+C
  • B.Ctrl+Shift+J
  • C.Ctrl+Alt+S
  • D.None of the above

15) The LibreOffice Calc is similar to Microsoft Excel, with almost the same abilities.

  • A. True
  • B.False

16) Ctrl+Shift+J is used for full screen mode in LibreOffice Calc.

  • A. True
  • B.False

17) Ctrl+F1 is used to display comments that is attached to the current cell.

  • A. False
  • B.True

18) Page down key is used to moves the viewable rows down one screen.

  • A. True
  • B.False

19) =A1+10 displays the contents of cell A1 plus 10.

  • A. True
  • B.False

20) Which short cut key is used to insert function in LibreOffice Calc?

  • A. Ctrl+F3
  • B.Ctrl+F1
  • C.Ctrl+F2
  • D.Ctrl+F4

21) In LibreOffice package, spreadsheet is called ...............

  • A. Excel
  • B.Row
  • C.Column
  • D.Calc

22) How many numbers of rows in the LibreOffice Calc spreadsheet?

  • A. 1048575
  • B.1048578
  • C.1048576
  • D.1048577

23) Which shortcut key is used to delete cell?

  • A. Ctrl+-
  • B.Ctrl++
  • C.Ctrl+=
  • D.Ctrl+|

24) Which shortcut key is used to insert cell in LibreOffice Calc?

  • A. Ctrl+-
  • B.Ctrl+=
  • C.Ctrl++
  • D.Ctrl+|

25) How many number of columns in LibreOffice Calc Spreadsheet?

  • A. 1000
  • B.1024
  • C.1020
  • D.1025

26) ............. menus are found in LibreOffice Calc.

  • A. 5
  • B.6
  • C.7
  • D.9

27) ..................... is used to opens the Thesaurus if the current cell contains text.

  • A. Ctrl+F7
  • B.Ctrl+F6
  • C.Ctrl+F8
  • D.Ctrl+F9

28) ............................ option is found in Edit Menu in LibreOffice Calc.

  • A. Find
  • B.Replace
  • C.Share
  • D.Both Find & Replace

29) What is the minimum font size in LibreOffice Calc?

  • A. 1
  • B.2
  • C.3
  • D.5

30) ............... is used to highlight cells containing numeric valuses.

  • A. Ctrl+F7
  • B.Ctrl+F6
  • C.Ctrl+F8
  • D.Ctrl+F5

1 comment(s) :

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Jun
Unix MCQ
01st
Jun
IOS Swift MCQ
01st
Mar
IOT MCQ
01st
Jun
Blue Prism MCQ