AutoFilter
Advanced Filter
Standard
Sorting
AMJ
XFD
AMG
EMJ
Ctrl + A
Ctrl+ Shift + A
Ctrl + Shift + Space
A and C Both
10
0
5
15
Cell
Tabel
Position
Data
Ctrl + ]
Alt +D
Ctrl + ;
Shift + K
7
3
No one
Match the following chart types in LibreOffice Calc with their suitable use cases.
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
Nested Function
Function
General Function
Condition Function
File
Edit
View
Insert
X.502
X.503
X.510
X.509
Searching
Filtering
Validating
1
56
-1
2
4
Shift + 1
Ctrl + 1
Alt + 1
Ctrl + Alt + 1
Bold, Italics, Underline
Left, Center, Right, Justify
Font Name, Font Size, Font Color
None of These
Cut, Copy, Paste
Find and Replace
Select All
All of these
Ctrl + v
Ctrl + M
Ctrl + Shift + F
1024
1048576
16384
None
Find and replace
By Copy only
By copy command
By preview command
Heading1
Good
Bad
Poor
Ctrl + shift + Space
Ctrl + Shift + A
A & B both
do calculations
create graphics
plot graphs
plot charts
#name?
#name
Whatever is written in a formula will remain the same
####
1199
1210
1188
%
$
&
=
'=' sign
Alphabets
Numbers
All of the these
Open Find dialog box
Open Find & Replace dialog box
Font dialog box
Format dialog box
DCOUNT
DCOUNTA
DSUM
SUM
Ctrl + Shift + P
Ctrl + Shift + O
Ctrl + P
Two
Three
Four
Five
.ods
.odt
.ott
.odf
256
1028
10000
@
#
Untitled1
Calc1
Spreadsheet1
None of these
Directly typing function name in a cell
Using function wizard or selecting from toolbar
Both (a) and (b)
Depends on the function
11
12
13
Ctrl + F2
Ctrl + F4
Ctrl + F3
Inserting
Deleting
F2
Ctrl + Shift + M
F3
Formula Bar
Address Book
Name box
Text
Mathematical
String
A dotted border
A dark wide border
A blinking border
By italic text
Ctrl + F6
Ctrl + H
Ctrl + F8
Ctrl + F1
35
-35
Calc
Write
Publisher
Excel
By manual entry
By auto-sum
By formula
By sum function
1024 rows and 1048576 columns
10000 rows and 32000 columns
1,048,576 rows and 16,384 columns
None of above