Relative address
Absolute address
Mixed address
Dynamic address
1048576
16348
1084576
1024598
Bold, Italics, Underline
Left, Center, Right, Justify
Font Name, Font Size, Font Color
None of These
Ctrl + +
Ctrl + -
Ctrl + D
Delete
Ctrl + ;
Ctrl + Shift + :
A and B both
None
Bring to Front
Send to Back
Send to Front
Forward One
AMJ
XFD
AMG
EMJ
32000
48000
60000
None of these
Date
Formula
Cell Value
All the above
400
6.25
7
500
Match the following LibreOffice Calc Error code with its description
1 → B, 2 → E, 3 → D, 4 → A
1 → B, 2 → F, 3 → D, 4 → E
1 → A, 2 → B, 3 → F, 4 → C
1 → F, 2 → E, 3 → D, 4 → A
Line
Pie
Bar
Column
N10
M11
M9
M12
1024
16384
Two
Three
Four
Five
By manual entry
By auto-sum
By formula
By sum function
F2
Ctrl + Shift + M
Ctrl + M
F3
Instant messaging, address book, antivirus, mailing list
Forms, data analysis, conditional formatting, sorting and filtering
Graphics, templates, spell checker, thesaurus
Accessibility, multimedia, hyperlinks, updated
Nested Function
Function
General Function
Condition Function
Calculating result
Sorting on result
Filtering on result
All of these
Ctrl + Shift + ;
Ctrl + T
Store data
Manipulate data
Create graphical representation of data
=
*
/
-
cell reference
cell identify
cell across
cell identification number
###
The cell size increase automatically
####
#Name?
.ods
.xls
.odx
.txt
AutoFilter
Conditional formatting
Pivot tables
Data validation
Shift+F2
Shift+F5
Shift+F3
CTRL+F9
Match the following LibreOffice Calc data tools with their functionalities.
A-1, B-2, C-3, D-4
A-4, B-3, C-2, D-1
A-3, B-4, C-1, D-2
A-2, B-1, C-4, D-3
@
#
$
&
Untitled1
Calc1
Spreadsheet1
Ctrl + Space
Shift + Space
Ctrl + Shift + Page down
Sorting
Searching
Filtering
Validating
Ctrl + V
Ctrl + Shift + F
Ctrl + 1
Calc
Write
Publisher
Excel
Match the following error types in LibreOffice Calc with their meanings.
A-3, B-1, C-4, D-2
A-2, B-4, C-1, D-3
15
3
4
5
Inserting
Deleting
Bottom left of the menu bar
Top left over menubar
On the status bar
Bottom right side of the menu bar
Ctrl + A
Ctrl+ Shift + A
Ctrl + Shift + Space
A and C Both
Up and Down scroll
Right and left
Horizontal and Vertical
All of above
Tab
Ctrl + Tab
Ctrl + Shift + Tab
Shift + Tab
=SUM(J14:J16)
=SUM(J14?J16)
SUM(J14:J16)
J14+J15+J16
.ODF
.ODS
.OBT
Format
Style
Sheet
Edit
Save As
Save
Save File
Save As File
Graph
Chart
1199
1210
1188
OpenDocument
Microsoft Excel
PDF