Filter
Sort
List
Arrange
200
300
00
2.75
Ctrl + Shift + F
Ctrl + Shift + S
Ctrl + F2
None
Instant messaging, address book, antivirus, mailing list
Forms, data analysis, conditional formatting, sorting and filtering
Graphics, templates, spell checker, thesaurus
Accessibility, multimedia, hyperlinks, updated
15
3
4
5
Calc
Write
Publisher
Excel
Base
Writer
Impress
Sorting
Inserting
Deleting
Single-click the boundary to the left to the column heading
Double click the boundary to the right of the column heading
Press Alt and single click anywhere in the column
All of above
Ctrl + Shift + P
Ctrl + Shift + O
Ctrl + P
None of These
Shape
Object
Chart
Pie
Store data
Manipulate data
Create graphical representation of data
All of these
AutoFilter
Conditional formatting
Pivot tables
Data validation
'=' sign
Alphabets
Numbers
All of the these
Change
Text
Transpose
Convert
cell reference
cell identify
cell across
cell identification number
Center
Split Cells
Split and merge
Merge and center
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
Line chart
Pie chart
Bar chart
Square chart
Bold, Italics, Underline
Left, Center, Right, Justify
Font Name, Font Size, Font Color
Data
Mathematical
String
Ctrl + Shift + 1
Ctrl + Shift + 5
Ctrl + Shift + 4
Ctrl + Shift + 3
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
247
240
200.47
Untitled1
Calc1
Spreadsheet1
None of these
.odp
.ods
.odd
.odt
.ott
.odf
1024
1048576
16384
Tab
Ctrl + Tab
Ctrl + Shift + Tab
Shift + Tab
Heading1
Good
Bad
Poor
Cut, Copy, Paste
Find and Replace
Select All
14000
14200
14300
14243.25
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
Data formatting
Data sorting
Data filtering
Ctrl + Shift + C
Ctrl + C
Ctrl + Shift + T
Ctrl + Alt + C
Format
Style
Sheet
Edit
1
56
-1
Horizontal
Vertical
Both A and B
=SUM(J14:J16)
=SUM(J14?J16)
SUM(J14:J16)
J14+J15+J16
Advanced Filter
Standard
Two
Three
Four
Five
Draw
Open Find dialog box
Open Find & Replace dialog box
Font dialog box
Format dialog box
###
The cell size increase automatically
####
#Name?
2
C1:10H
C1:H10
C1:H-10
C1:H:10
Media Playback
3D settings
Painting
Drawing
8
10
12
14