InterviewQueries.

LibreOffice Calc MCQ Questions

LibreOffice Calc MCQ Questions

Satyam Jaiswal
23rd Nov, 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.

Home
Interview Questions
LibreOffice Calc MCQ Questions

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 :

Your Comment

Valid name is required.

Name *

Valid name is required.

Your Email *

Valid email id is required.

Arduino MCQ Questions 02nd Sep, 2023

3D Printing MCQ 23rd Nov, 2021

Bioinformatics MCQ Questions 12th Mar, 2022

Business Intelligence MCQ 15th Apr, 2022

Salesforce MCQ 28th Feb, 2022

SAP ABAP MCQ 05th Mar, 2022

Related MCQ/Quiz

01st
Aug

Powerpoint MCQ

01st
Nov

Tomcat MCQ

01st
Jul

MS Word MCQ

01st
Nov

MySQL MCQ Questions

MySQL MCQ Questions

01st
Feb

Blue Prism MCQ

01st
Nov

ExpressJS MCQ Questions

ExpressJS MCQ Questions