19th
Jan
LibreOffice Calc MCQ

LibreOffice Calc MCQ

  • Admin
  • 19th Jan, 2021
  • 480 Followers

LibreOffice Calc MCQ Online Test

1) What will be the value of = 10 * 20/4 * 8 in libreoffice calc?

  • A. 6.35
  • B. 8
  • C. 400
  • D. 600

2) What is the shortcut key to reach first column in LibreOffice Calc?

  • A. Ctrl + Home
  • B. Alt + Home
  • C. Home
  • D. None of the above

3) How many total charts in LibreOffice Calc?

  • A. 5
  • B. 10
  • C. 15
  • D. 20

4) What is maximum zoom in LibreOffice Calc?

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

5) What is the value of =round (1175,-2)?

  • A. 995
  • B. 1200
  • C. 1100
  • D. 1300
Download Free : LibreOffice Calc MCQ PDF

6) What is the shortcut key of formatting of the cell in LibreOffice Calc?

  • A. Ctrl + 2
  • B. Ctrl + F2
  • C. Ctrl + M
  • D. Ctrl + 1

7) In which menu, merge cells command is found?

  • A. Edit
  • B. Style
  • C. Formate
  • D. Sheet

8) What is the shortcut key to reach of last cell of a spreadsheet in LibreOffice Calc?

  • A. Ctrl + Shift + Home
  • B. Ctrl + End
  • C. Ctrl + Home
  • D. None of the above

9) What is the minimum zoom in LibreOffice Calc?

  • A. 5%
  • B. 20%
  • C. 15%
  • D. 10%

10) LibreOffice Calc by default provides an auto calculator feature that displays as if in a selected range range?

  • A. True
  • B. False

11) What is the value of =round (175,-2)?

  • A. 95
  • B. 100
  • C. 200
  • D. 185

12) To break a merged cell in Libreoffice Calc, you have to select that cell and click on the ……… button?

  • A. Splide
  • B. Center
  • C. Merge and center
  • D. Split and merge

13) How many columns are there in libreoffice calc:

  • A. 1024
  • B. 164890
  • C. 10461203
  • D. None

14) In LibreOffice Calc, the shortcut key of going at the last of left of the cell is?

  • A. Alt
  • B. Shift + Tab
  • C. Tab
  • D. Alt+Tab

15) What is the shortcut key of deleting of the cell in LibreOffice Calc?

  • A. Delete
  • B. Ctrl + +
  • C. Ctrl + D
  • D. Ctrl + -

16) How many maximum characters in one cell in LibreOffice Calc?

  • A. 104580
  • B. 43621
  • C. 59870
  • D. 32767

17) Which sign is visible when there is a Formula Error in Libreoffice Calc?

  • A. *
  • B. #
  • C. \
  • D. $

18) In LibreOffice Calc, if the value is larger than the cell space, what result comes?

  • A. Cell enlarges and result comes correctly
  • B. ####
  • C. ###
  • D. #Name?

19) What is the shortcut key of print preview in LibreOffice Calc?

  • A. Ctrl + Shift + O
  • B. Ctrl + P
  • C. Ctrl + Shift + P
  • D. None of the above

20) What is the combination of row and column in LibreOffice Calc?

  • A. Table
  • B. Data
  • C. Cell
  • D. Position

21) How many total rows are there in LibreOffice Calc?

  • A. 1048576
  • B. 1024
  • C. 16384
  • D. None of the above

22) What will be the result of product (7,-2)?

  • A. 5
  • B. 14
  • C. -14
  • D. None of the above

23) What is the shortcut key of edit mode of a cell in LibreOffice Calc?

  • A. Ctrl + Shift + M
  • B. Ctrl + M
  • C. F2
  • D. F3

24) What is the mail merge option in LibreOffice Calc?

  • A. Used to merge two mails together
  • B. To mail a created file to someone
  • C. Used for mailing many people
  • D. None of the above

25) COS, EVEN, FACT, EXP are functions of which category in Libreoffice Calc?

  • A. Math / Tring
  • B. Mathematical
  • C. Data
  • D. String

26) What is the shortcut key for adding cell in LibreOffice Calc?

  • A. (A) Ctrl + -
  • B. ADD
  • C. Ctrl + +
  • D. Ctrl + D

27) What is the last column in LibreOffice Calc?

  • A. AMG
  • B. XFD
  • C. AMJ
  • D. EMJ

28) The shortcut key to insert a function in libreoffice calc?

  • A. Alt + F3
  • B. Ctrl + F2
  • C. Shift + F3
  • D. Shift + F4

29) Which shortcut key is used for current date?

  • A. Ctrl + shift :
  • B. Shift+F3
  • C. Shift + F5
  • D. Ctrl + ;

30) What is the shortcut key of inserting time in LibreOffice Calc?

  • A. Ctrl + T
  • B. Ctrl + ;
  • C. Ctrl + Shift + ;
  • D. None of the above

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Dec
Laravel MCQ
01st
Dec
React JS MCQ
01st
Jan
AngularJs MCQ
01st
Jul
Node js MCQ
01st
Jul
Angular 2 MCQ
01st
Jul
JSON MCQ