ExamLookup
Menu mobile
Home
Current Affairs
General Knowledge
Computer
Python
HTML
- LIBREOFFICE CALC QUIZ | MCQ Questions
- LIBREOFFICE CALC QUIZ | MCQ Questions
00:00:00
English
Hindi
Question No# :
01
out of 50
What will happen if the Excel formula bar does not contain = before the formula?
What will happen if the Excel formula bar does not contain = before the formula?
A.
#name?
#name?
B.
#name
#name
C.
Whatever is written in a formula will remain the same
फार्मूला एक बार में जो भी लिखा होगा वही रहेगा
D.
####
####
Question No# :
02
out of 50
Which Of The Following Chart Is Present In Libreoffice Calc?
Which Of The Following Chart Is Present In Libreoffice Calc?
A.
Bubble
Bubble
B.
Circle
Circle
C.
Baloon
Baloon
D.
Hollow
Hollow
Question No# :
03
out of 50
In which menu the Merge Cells command found in LibreOffice Calc
In which menu the Merge Cells command found in LibreOffice Calc
A.
Format
Format
B.
Style
Style
C.
Sheet
Sheet
D.
Edit
Edit
Question No# :
04
out of 50
Extension of LibreOffice Calc file is
Extension of LibreOffice Calc file is
A.
.ods
.ods
B.
.xls
.xls
C.
.odx
.odx
D.
.txt
.txt
Question No# :
05
out of 50
Data in a table can only be arranged in ascending order
Data in a table can only be arranged in ascending order
A.
TRUE
B.
FALSE
Question No# :
06
out of 50
Which shortcut key is used to clear the formatting of Cell in LibreOffice Calc?
Which shortcut key is used to clear the formatting of Cell in LibreOffice Calc?
A.
Ctrl + v
Ctrl + v
B.
Ctrl + M
Ctrl + M
C.
Ctrl + Shift + F
Ctrl + Shift + F
D.
Ctrl + 1
Ctrl + 1
Question No# :
07
out of 50
Where the address of a active cell is appear in LibreOffice Calc?
Where the address of a active cell is appear in LibreOffice Calc?
A.
Formula Bar
Formula Bar
B.
Address Book
Address Book
C.
Name box
Book Name box
D.
None
None
Question No# :
08
out of 50
Which shortcut key is used for print preview in LibreOffice Calc?
Which shortcut key is used for print preview in LibreOffice Calc?
A.
Ctrl + Shift + P
Ctrl + Shift + P
B.
Ctrl + Shift + O
Ctrl + Shift + O
C.
Ctrl + P
Ctrl + P
D.
None of These
इनमे से कोई नहीं
Question No# :
09
out of 50
Which shortcut key is used to delete a cell in LibreOffice Calc?
Which shortcut key is used to delete a cell in LibreOffice Calc?
A.
Ctrl + +
Ctrl + +
B.
Ctrl + -
Ctrl + -
C.
Ctrl + D
Ctrl + D
D.
Delete
Delete
Question No# :
10
out of 50
Spell check shortcut key?
Spell check shortcut key?
A.
F5
F5
B.
Shift+F5
Shift+F5
C.
F7
F7
D.
Shift+F7
Shift+F7
Question No# :
11
out of 50
Which key do Libreoffice Calc use to move to the left (one step back) of the cell?
Which key do Libreoffice Calc use to move to the left (one step back) of the cell?
A.
Alt +Tab
Alt +Tab
B.
Tab
Tab
C.
Alt
Alt
D.
Shift + Tab
Shift + Tab
Question No# :
12
out of 50
What is the last cell address in LinreOffice Calc?
What is the last cell address in LinreOffice Calc?
A.
$D$10
$D$10
B.
AMJ1048575
AMJ1048575
C.
XFD1048576
XFD1048576
D.
$AMD$1048576
$AMD$1048576
Question No# :
13
out of 50
Which shortcut key is used to convert a number into currency format in LibreOffice Calc?
Which shortcut key is used to convert a number into currency format in LibreOffice Calc?
A.
Ctrl + Shift + 1
Ctrl + Shift + 1
B.
Ctrl + Shift + 5
Ctrl + Shift + 5
C.
Ctrl + Shift + 4
Ctrl + Shift + 4
D.
Ctrl + Shift + 3
Ctrl + Shift + 3
Question No# :
14
out of 50
Which of the following is not a part of the chart?
Which of the following is not a part of the chart?
A.
Chart Title
Chart Title
B.
Data Label
Data Label
C.
Chart Area
Chart Area
D.
Chart Line
Chart Line
Question No# :
15
out of 50
A function should start with
A function should start with
A.
‘=’ sign
‘=’ sign
B.
Alphabets
Alphabets
C.
Numbers
Numbers
D.
All of the these
इनमे से सभी
Question No# :
16
out of 50
In Calc, most common commands present in which Bar?
In Calc, most common commands present in which Bar?
A.
Title bar
Title bar
B.
Standard Toolbar
Standard Toolbar
C.
Formatting Toolbar
Formatting Toolbar
D.
Formula Bar
Formula Bar
Question No# :
17
out of 50
Shortcut to activate Extension Manager in LibreOffice Calc is_________.
Shortcut to activate Extension Manager in LibreOffice Calc is_________.
A.
CTRL+E
CTRL+E
B.
CTRL+ Alt+ E
CTRL+ Alt+ E
C.
CTRL+Shift+E
CTRL+Shift+E
D.
CTRL+F9
CTRL+F9
Question No# :
18
out of 50
What is called to arrange data in ascending or descending order?
What is called to arrange data in ascending or descending order?
A.
Sorting
Sorting
B.
Filter
Filter
C.
Inserting
Inserting
D.
Deleting
Deleting
Question No# :
19
out of 50
What will be the value of = 10 * 20/4 * 8 in LibreOffice Calc?
What will be the value of = 10 * 20/4 * 8 in LibreOffice Calc?
A.
400
400
B.
6.25
6.25
C.
7
7
D.
500
500
Question No# :
20
out of 50
What will be the value of =Product (7, -5)?
What will be the value of =Product (7, -5)?
A.
35
35
B.
-35
-35
C.
12
12
D.
2
2
Question No# :
21
out of 50
Which shortcut is used to insert function in LibreOffice Calc?
Which shortcut is used to insert function in LibreOffice Calc?
A.
Shift + F3
Shift + F3
B.
Ctrl + F2
Ctrl + F2
C.
Ctrl + F3
Ctrl + F3
D.
Alt + F3
Alt + F3
Question No# :
22
out of 50
The process of production of customer list in alphabetical order falls under the category of
The process of production of customer list in alphabetical order falls under the category of
A.
Editing
संपादन (Editing)
B.
Sorting
श्रेणीबद्ध करना (Sorting)
C.
Updating
अद्यतीकरण (Updating)
D.
Calculating
गणना करना (Calculating)
Question No# :
23
out of 50
What will be the value of = product (5,2)?
What will be the value of = product (5,2)?
A.
10
10
B.
3
3
C.
7
7
D.
1
1
Question No# :
24
out of 50
What is the name of mechanism to arrange the data in a particular order?
What is the name of mechanism to arrange the data in a particular order?
A.
Sorting
Sorting
B.
Searching
Searching
C.
Filtering
Filtering
D.
Validating
Validating
Question No# :
25
out of 50
Which shortcut key is used for Paste Special in LibreOffice Calc?
Which shortcut key is used for Paste Special in LibreOffice Calc?
A.
Ctrl + Shift + V
Ctrl + Shift + V
B.
Ctrl + V
Ctrl + V
C.
Ctrl + Alt + V
Ctrl + Alt + V
D.
Shift + V
Shift + V
Question No# :
26
out of 50
LibreOffice Calc does not give a wizard for
LibreOffice Calc does not give a wizard for
A.
Letter
पत्र
B.
Fax
फैक्स
C.
Agenda
एजेंडा
D.
E-mail
ईमेल
Question No# :
27
out of 50
We can replace multiple occurrences of a word using which of the following facilities of Calc?
We can replace multiple occurrences of a word using which of the following facilities of Calc?
A.
Find and replace
Find and replace
B.
By Copy only
By Copy only
C.
By copy command
By copy command
D.
By preview command
By preview command
Question No# :
28
out of 50
Which of the following will be the output of =100/-10/2 in LibreOffice calc?
Which of the following will be the output of =100/-10/2 in LibreOffice calc?
A.
-5
-5
B.
5
5
C.
25
25
D.
50
50
Question No# :
29
out of 50
How many rows and columns are there in LibreOffice Calc?
How many rows and columns are there in LibreOffice Calc?
A.
1024 and 1048576
1024 and 1048576
B.
10000 and 32000
10000 and 32000
C.
1048576 and 1024
1048576 and 1024
D.
None of above
इनमें से कोई भी नहीं
Question No# :
30
out of 50
If a variable is missing from the formula then error message displayed?
If a variable is missing from the formula then error message displayed?
A.
511
511
B.
576
576
C.
510
510
D.
566
566
Question No# :
31
out of 50
Which key is used to enable editing the cell?
Which key is used to enable editing the cell?
A.
F2
F2
B.
Ctrl + Shift + M
Ctrl + Shift + M
C.
Ctrl + M
Ctrl + M
D.
F3
F3
Question No# :
32
out of 50
Dates and times stored in Libreoffice Calc internally treated as numbers?
Dates and times stored in Libreoffice Calc internally treated as numbers?
A.
TRUE
TRUE
B.
FALSE
FALSE
Question No# :
33
out of 50
Conditional formatting can be done in LibreOffice Cal based on
Conditional formatting can be done in LibreOffice Cal based on
A.
Date
डेट
B.
Formula
फॉर्मूला
C.
Cell Value
सेल वैल्यू
D.
All the above
उपरोक्त सभी
Question No# :
34
out of 50
Which shortcut key is used to open the Cell Format dialog box in Libreoffice Calc?
Which shortcut key is used to open the Cell Format dialog box in Libreoffice Calc?
A.
Ctrl + 4
Ctrl + 4
B.
Ctrl + 3
Ctrl + 3
C.
Ctrl + 2
Ctrl + 2
D.
Ctrl + 1
Ctrl + 1
Question No# :
35
out of 50
What is the default file extension for a spreadsheet in Libreoffice Calc?
What is the default file extension for a spreadsheet in Libreoffice Calc?
A.
.odp
.odp
B.
.ods
.ods
C.
.odd
.odd
D.
.odt
.odt
Question No# :
36
out of 50
Which is not a valid Formatting mark in LibreOffice Ca
Which is not a valid Formatting mark in LibreOffice Ca
A.
Non-breaking space
नॉन -ब्रेकिंग स्पेस
B.
Non-breaking hyphen
नॉन -ब्रेकिंग हायफ़न
C.
Word Joiner
वर्ड जॉइनर
D.
Sentence Joiner
सेंटेंस जॉइनर
Question No# :
37
out of 50
Which error code indicates the missing equals sign from the formula in calc?
Which error code indicates the missing equals sign from the formula in calc?
A.
511
511
B.
508
508
C.
510
510
D.
509
509
Question No# :
38
out of 50
Which of the following technique can be used to allow only date value in cell ?
Which of the following technique can be used to allow only date value in cell ?
A.
Data formatting
Data formatting
B.
Data sorting
Data sorting
C.
Data filtering
Data filtering
D.
Data validation
Data validation
Question No# :
39
out of 50
What is included in Calc to prepare result analysis and merit list preparation ?
What is included in Calc to prepare result analysis and merit list preparation ?
A.
Calculating result
Calculating result
B.
Sorting on result
Sorting on result
C.
Filtering on result
Filtering on result
D.
All of these
इनमे से सभी
Question No# :
40
out of 50
What is the address of the last column in LibreOffice Calc?
What is the address of the last column in LibreOffice Calc?
A.
AMJ
AMJ
B.
XFD
XFD
C.
AMG
AMG
D.
EMJ
EMJ
Question No# :
41
out of 50
In LibreOffice Calc, in which menu is the merge cell command available?
In LibreOffice Calc, in which menu is the merge cell command available?
A.
Format
Format
B.
Style
Style
C.
Sheet
Sheet
D.
Edit
Edit
Question No# :
42
out of 50
How many number of columns in LibreOffice Calc?
How many number of columns in LibreOffice Calc?
A.
1024
1024
B.
1048576
1048576
C.
16384
16384
D.
None
None
Question No# :
43
out of 50
In Libreoffice Calc, what is the value if there is a larger value than the cell (For Date Type)?
In Libreoffice Calc, what is the value if there is a larger value than the cell (For Date Type)?
A.
###
###
B.
The cell size increase automatically
सेल बड़ी हो जाती है और मान सही आता है
C.
####
####
D.
#Name?
#Name?
Question No# :
44
out of 50
A formula start with which symbol in LibreOffice Calc?
A formula start with which symbol in LibreOffice Calc?
A.
$
$
B.
@
@
C.
=
=
D.
None of These
इनमें से कोई नहीं
Question No# :
45
out of 50
LibreOffice calc, which one of the following is a valid choice under the option Freeze cells?
LibreOffice calc, which one of the following is a valid choice under the option Freeze cells?
A.
Freeze current column
Freeze current column
B.
Freeze current cell
Freeze current cell
C.
Freeze current row
Freeze current row
D.
Freeze First Row
Freeze First Row
Question No# :
46
out of 50
____ chart is best suited to represent the overall structure in proportion of different components .
____ chart is best suited to represent the overall structure in proportion of different components .
A.
Line
Line
B.
Pie
Pie
C.
Bar
Bar
D.
Column
Column
Question No# :
47
out of 50
What is the default File Name of LibreOffice Clac?
What is the default File Name of LibreOffice Clac?
A.
Untitled1
Untitled1
B.
Calc1
Calc1
C.
Spreadsheet1
Spreadsheet1
D.
None of these
इनमें से कोई नहीं
Question No# :
48
out of 50
Libreoffice Calc has alphabet right and numbers left align?
Libreoffice Calc has alphabet right and numbers left align?
A.
TRUE
TRUE
B.
FALSE
FALSE
Question No# :
49
out of 50
LibreOffice Calc does not provide following Toolbar
LibreOffice Calc does not provide following Toolbar
A.
Media Playback
मीडिया प्लेबैक
B.
3D settings
3D सेटिंग्स
C.
Painting
पेंटिंग
D.
Drawing
पॉइंट ड्राइंग
Question No# :
50
out of 50
How many axes are presents in charts of LibreOffice Calc?
How many axes are presents in charts of LibreOffice Calc?
A.
Two
Two
B.
Three
Three
C.
Four
Four
D.
Five
Five
CCC Online Test 2021
CCC Practice Test Hindi
Python Programming Tutorials
Best Computer Training Institute in Prayagraj (Allahabad)
O Level NIELIT Study material and Quiz
Bank SSC Railway TET UPTET Question Bank
career counselling in allahabad
Sarkari Exam Quiz
Website development Company in Allahabad