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

Laravel MCQ

01st
Dec
React JS MCQ

React JS MCQ

01st
Jan
AngularJs MCQ

AngularJs MCQ

01st
Jul
Node js MCQ

Node js MCQ

01st
Jul
Angular 2 MCQ

Angular 2 MCQ

01st
Jul
JSON MCQ

JSON MCQ