NEW
Font size
WorksheetsLibreOffice Calc Quiz
Total questions: 24
Worksheet time: 12mins
Which of the following feature is not used for data analysis in spreadsheet?
Consolidating data
Goal Seek
Subtotal
Page layout
Which of the following office tool is known for data analysis?
Writer
Calc
Impress
Draw
Which of the following operations cannot be performed using LibreOffice Calc?
Store and manipulate data
Create graphical representation of data
Analysis of data
Mail merge
What is the extension of spreadsheet file in Calc?
.odb
.odt
.odg
.ods
The default function while using Consolidate is ____________.
Average
Sum
Max
Count
Group by is used in _____________ tool to apply summary functions on columns.
Consolidate function
Group and Outline
What-if scenario
Subtotal tool
Which tool is used to predict the output while changing the input?
Consolidate function
What-if scenario
Goal seek
Fine and Replace
Which of the following is an example for absolute cell referencing?
C5
$C$5
$C
#C
_____________ analysis tool works in reverse order, finding input based on the output.
Consolidate function
Goal seek
What-if analysis
Scenario
Macro Recordings can be enabled from the ________ option in the menu bar.
Sheet
Data
Tools
Window.
Which of the following is an invalid Macro Name?
1formatword
format word
format*word
Format_word.
Which of the following Libraries contains modules with prerecorded macros and should not be changed?
My Macros
LibreOfficeMacros
Untitled1
Test.
Identify which of the following is a programming Language?
Calc
BASIC
Writer
Macro.
The Module can be executed from the IDE by pressing _________________.
F3
F4
F5
F6
Which of the following is the default name of the Macro _______________.
Default
Main
Macro1
Main_Macro
Insert Sheet dialog can be invoked from _______________.
sheet
insert
tools
Windows
______________ refers to cell G5 of sheet named My Sheet.
$My Sheet.’G5’
$My Sheet_’G5’
$ ‘MySheet’.G5
$ ‘MySheet’_G5
The path of a file has ____________ forward slashes.
four
three
two
one
Which of the following feature is used to jump to a different spreadsheet from the current spreadsheet in LibreOffice Calc?
Macro
Hyperlink
connect
Copy
Sharing allows to edit the spreadsheet by ......................
single user
different users simultaneously
one by one users
one after other users
Sharing spreadsheet feature allows to save the changes in ..................
multiple sheets
user’s sheet
in a same sheet
in different sheet
The Recording Changes feature of LibreOffice Calc provides different ways to record the changes made by ____________ in the spreadsheet.
one user
other user
the user
one or other users
In Calc, the comments are added ...................
automatically
by author
by reviewer
all of above
The changes by team members in the spreadsheet can be accepted or rejected by
the team members
any of the user
owner
other users
