LibreOffice Calc MCQ Questions

LibreOffice Calc MCQ Questions | Freshers & Experienced

  • Satyam Jaiswal
  • 22nd May, 2021

We are introducing here the best LibreOffice Calc MCQ Questions, which are very popular & asked various times. This Quiz contains the best 25+ LibreOffice Calc MCQ with Answers, which cover the important topics of LibreOffice Calc. for which, you can perform best in LibreOffice Calc Exams, CCC Exams, O-Level Exams, Interviews, and Placement activities.

 

LibreOffice Calc MCQ Questions

1) LibreOffice Calc is the _________ component of the LibreOffice.

  • A. Text
  • B.Presentation
  • C.Spreadsheet
  • D.File

2) Libre Office exceeds the capabilities of Microsoft Excel.

  • A. Yes
  • B.No
  • C.May be
  • D.Can't say

3) LibreOffice Calc is a spreadsheet application that can be used to ________

  • A. calculate
  • B.analyze
  • C.manage your data
  • D.All of the above

4) The shortcut key to insert a function in libreoffice calc is ________.

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

5) Total charts in LibreOffice Calc are ______.

  • A. 11
  • B.10
  • C.12
  • D.9

6) There are _______ columns in LibreOffice Calc.

  • A. 512
  • B.1024
  • C.2048
  • D.3072

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

  • A. 175
  • B.0
  • C.200
  • D.190

8) ________ sign is visible when there is a Formula Error in Libreoffice Calc.

  • A. %
  • B.#
  • C.$
  • D.@

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

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

10) _______ key is used for current date.

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

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

  • A. 400
  • B.200
  • C.600
  • D.300

12) What will be the default name of the file saved in LibreOffice calc?

  • A. Spreadsheet1
  • B.Untitled1
  • C.Calc1
  • D.None of the above

13) In ________ menu, merge cells command is found.

  • A. Sheet
  • B.Style
  • C.Format
  • D.None of the above

14) In LibreOffice Calc, each sheet can have a maximum of ________ rows

  • A. 102424
  • B.1,048,576
  • C.57698
  • D.41256

15) What is the last column in LibreOffice Calc?

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

16) In LibreOffice Calc, cos,sin, fact,exp are category of ________.

  • A. Data
  • B.Science
  • C.Calculation
  • D.Mathematical

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

  • A. 14
  • B.-14
  • C.24
  • D.-24

18) The combination of row and column in LibreOffice Calc is called _______.

  • A. Table
  • B.Cell
  • C.Schema
  • D.All of the above

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

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

20) In LibreOffice Calc, the shortcut key of going at the last of left of the cell is _______.

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

21) In LibreOffice Calc, What will be the result if the value is larger than the cell space?

  • A. $$$
  • B.###
  • C.@@@
  • D.%%%

22) _______ is maximum zoom in LibreOffice Calc.

  • A. 300%
  • B.350%
  • C.400%
  • D.500%

23) ______ is the minimum zoom in LibreOffice Calc.

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

24) There are maximum _______ characters in one cell in LibreOffice Calc.

  • A. 12568
  • B.7823
  • C.52469
  • D.32767

25) In LibreOffice Calc a formula start with _______ symbol.

  • A. &
  • B.*
  • C.+
  • D.=

26) ______ is the shortcut key to increase the cell width in LibreOffice Calc.

  • A. Alt + Right Arrow
  • B.Alt + Leftt Arrow
  • C.Ctrl + Right Arrow
  • D.None of the above

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

  • A. =B2+2
  • B.=B1+2
  • C.=B1+B2
  • D.All of the above

28) _________ displays the result of the multiplication of x and y.

  • A. x**y
  • B.y%x
  • C.x*y
  • D.*(x+y)

29) Formatting toolbar contains text formatting controls.

  • A. True
  • B.False

30) ________ displays the information about the current status of a program.

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

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.