Relative address
Absolute address
Mixed address
Dynamic address
300%
200%
400%
500%
Shape
Object
Chart
Pie
Ctrl + Shift + 1
Ctrl + Shift + 5
Ctrl + Shift + 4
Ctrl + Shift + 3
Match the following error types in LibreOffice Calc with their meanings.
A-1, B-2, C-3, D-4
A-3, B-1, C-4, D-2
A-4, B-3, C-2, D-1
A-2, B-4, C-1, D-3
Ctrl + Space
Shift + Space
Ctrl + Shift + Page down
None
Calc
Write
Publisher
Excel
Data
Math / Tring
Mathematical
String
Instant messaging, address book, antivirus, mailing list
Forms, data analysis, conditional formatting, sorting and filtering
Graphics, templates, spell checker, thesaurus
Accessibility, multimedia, hyperlinks, updated
Ctrl + 4
Ctrl + 3
Ctrl + 2
Ctrl + 1
1048576 Rows & 1024 Columns
1048576 Rows & 16384 Columns
16384 Rows & 1048576 Columns
1024 Rows & 1048576 Columns
400
6.25
7
500
###
The cell size increase automatically
####
#Name?
Ctrl + ]
Alt +D
Ctrl + ;
Shift + K
Chart wizard
Pie wizard
Shap
Column
Value
Address
Cell
.odt
.ods
.odp
.xlsx
Edited
Shown
Deleted
All the above
Date
Formula
Cell Value
7,2
7+2
9
5,7
Date( )
Now( )
Time( )
A dotted border
A dark wide border
A blinking border
By italic text
1024
1048576
16384
200
300
00
2.75
Ctrl + Shift + :
A and B both
To apply predefined formatting to cells based on specific conditions
To perform complex calculations and data analysis
To filter and display only the rows that meet specific criteria
To create charts and graphs
Heading1
Good
Bad
Poor
Financial
Statistical, logical
All of these
A,B,C,….
1,2,3….
A1, B1, C1…
1A, 1B, 1C…
Nested Function
Function
General Function
Condition Function
Left
Right
Center
Justified
Untitled1
Calc1
Spreadsheet1
None of These
CTRL+P
CTRL+Shift+P
Alt+P
CTRL+Alt+P
256
1028
10000
1199
1210
1188
Format
Style
Sheet
Edit
Line chart
Pie chart
Bar chart
Square chart
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
Match the following mathematical functions with their purposes.
A-2, B-3, C-4, D-1
A-3, B-4, C-1, D-2
A-4, B-1, C-2, D-3
Cut, Copy, Paste
Find and Replace
Select All
Match the following LibreOffice Calc data tools with their functionalities.
A-2, B-1, C-4, D-3
8
12
14
10
350%
600%
Save As
Save
Save File
Save As File
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
Shift + F3
Ctrl + F2
Ctrl + F3
Alt + F3
@
#
$
&
cell reference
cell identify
cell across
cell identification number
Ctrl + A
Ctrl+ Shift + A
Ctrl + Shift + Space
A and C Both
Tab
Ctrl + Tab
Ctrl + Shift + Tab
Shift + Tab