Left
Right
Center
Justified
A unique identifier for each cell in the spreadsheet
A function used to format cells
A hyperlink to another cell or document
A shortcut key for accessing cells
14000
14200
14300
14243.25
.ODF
.ODT
.ODS
.OBT
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
Ctrl + ;
Shift + D
Ctrl + D
Alt + D
Sorting
Searching
Filtering
Validating
Match the following mathematical functions with their purposes.
A-2, B-3, C-4, D-1
A-4, B-1, C-2, D-3
Calc
Base
Writer
Impress
#name?
#name
Whatever is written in a formula will remain the same
####
C1:10H
C1:H10
C1:H-10
C1:H:10
AutoFilter
Advanced Filter
Standard
1024
1048576
16384
None of These
Two
Three
Four
Five
256
1028
10000
Mathematical
Financial
Statistical, logical
All of these
To add data
Formatting
To add formula
Ctrl + F2
Ctrl + F4
Ctrl + F3
None of these
Ctrl + +
Ctrl + -
Delete
511
508
510
509
None
8
10
12
14
Edited
Shown
Deleted
All the above
Tab
Ctrl + Tab
Ctrl + Shift + Tab
Shift + Tab
Google Drive
One Drive
IBM Lotus Notes
FTP
Text Files
Satellite data
Sensor data
Seismic imagery data
Insert
Data
Tools
View
Alt+=
Ctrl+=
Shift+=
Alt+S
A3
$A$3
A$3
$A3
Calculating result
Sorting on result
Filtering on result
Function
Formula
Graph
Chart
.ods
.xls
.odx
.txt
.odt
.odp
.xlsx
B1&B5
B1*B5
B1#B5
B1:B5
Column
Value
Address
Cell
Ctrl + C
Ctrl + M
Ctrl + Shift + M
'=' sign
Alphabets
Numbers
All of the these
Spreadsheet
Double sheet
Multi-sheet
Cannot determine
Ctrl + Shift + V
Ctrl + V
Ctrl + Alt + V
Shift + V
Ctrl + W
Ctrl + Q
Ctrl + Shift + C
Shift + W
Format
Style
Sheet
Edit
DCOUNT
DCOUNTA
COUNTA
COUNTIF
Date( )
Now( )
Time( )
cell reference
cell identify
cell across
cell identification number
Ctrl+f
Ctrl+D
Ctrl+L
Ctrl+1
A,B,C,….
1,2,3….
A1, B1, C1…
1A, 1B, 1C…
See Only Specific Data
Arrange data
Copy Data
Making Chart
Row
Shift+F2
Shift+F5
Shift+F3
CTRL+F9
Flipping a selection convert it into a floating selection
Flip Horizontal flip the left side to the right side
Flip Horizontal flips the right to the left side
Flip vertical flips the top to the bottom