19th
Jan
LibreOffice Calc MCQ

LibreOffice Calc MCQ

  • Admin
  • 19th Jan, 2021
  • 884 Followers

LibreOffice Calc MCQ Online Test

Following are mostly asked Libreoffice calc MCQ test that are designed for professionals like you to crack you interviews. You can take this Libreoffice calc online test before appearing to you real interview. This Libreoffice calc quiz there are around 30+ multiple choice questions on Libreoffice calc with four options.

1) How many columns are there in libreoffice calc:

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

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

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

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

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

4) 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

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

  • A. *
  • B. #
  • C. \
  • D. $
Download Free : LibreOffice Calc MCQ PDF

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

  • A. True
  • B. False

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

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

8) 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

9) What is the last column in LibreOffice Calc?

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

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

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

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

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

12) 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

13) 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

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

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

15) 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

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

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

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

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

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 maximum zoom in LibreOffice Calc?

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

20) What is the minimum zoom in LibreOffice Calc?

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

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

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

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

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

23) 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

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

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

25) How many total charts in LibreOffice Calc?

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

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

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

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

  • A. 995
  • B. 1200
  • C. 1100
  • D. 1300

28) Which shortcut key is used for current date?

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

29) 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

30) 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

31) What is the default file extension of LibraOffice Calc?

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

32) Libra Office Calc is the spreadsheet component of LibreOffice.

  • A. True
  • B. False

33) ___ allows us to organise, analyse and store data in tabular form.

  • A. Libra Office Calc
  • B. Libra Office Impress
  • C. Libra Office Writer
  • D. None of the above

34) In LibreOffice Calc a formula start with a symbol ____.

  • A. %
  • B. $
  • C. &
  • D. =

35) What will be the result of the formula MAX(B1:B3)+MIN(B1:B3) if B1=5, B2=2, B3=7?

  • A. 7,2
  • B. 7+2
  • C. 9
  • D. 5,7

36) In LibreOffice Calc the address of any Cell is shown in ___.

  • A. Formula Bar
  • B. Address Book
  • C. Name Box
  • D. None of these

37) What is the shortcut key to close the Libra Office Calc's Current Window?

  • A. Ctrl + Q
  • B. Ctrl + W
  • C. Ctrl + T
  • D. None of the above

38) Which of the following displays the contents of the cell B1 plus B2?

  • A. =B1+B2
  • B. =B1+2
  • C. =1+B2
  • D. =B(1+2)

39) Which of the following formula calculates sum of the cells B10 to B14?

  • A. =SUM(B10:B14)
  • B. =SUM(B10:14)
  • C. =SUM(10:14)
  • D. All of the above

40) Which of the following formula displays the result of the multiplication of A1 and A2?

  • A. A1*2
  • B. A(1*2)
  • C. A1*A2
  • D. All of the above

41) Which of the following used for displaying and editing data functions(such as sum, percentage, etc)?

  • A. Toolbar
  • B. Name Box
  • C. Formula Bar
  • D. All of the above

42) Formatting toolbar contains text formatting controls.

  • A. True
  • B. False

43) ___ displays the information about the current status of a program,

  • A. Status Bar
  • B. Menu bar
  • C. Tool bar
  • D. All of the above

44) ___, as opposed to ____, determines a fixed location of the cell.

  • A. Absolute address, relative address
  • B. relative address, absolute address
  • C. positive address, negative address
  • D. None of the above

45) In LibreOffice Calc, ____ are predefined expressions (formulas) that perform a calculation using values called function arguments.

  • A. Formulas
  • B. Expressions
  • C. Functions
  • D. All of the above

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Mar
GIT MCQ
01st
Mar
Devops  Mcq
01st
Mar
Cobol MCQ