By manual entry
By auto-sum
By formula
By sum function
Ctrl + Space
Shift + Space
Ctrl + Shift + Page down
None
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
Print View
Print Preview
Print Screen
Print Document
14000
14200
14300
14243.25
8
10
12
14
Sorting
Filter
Inserting
Deleting
-5
5
25
50
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 + P
Ctrl + Shift + O
Ctrl + P
None of These
=
*
/
-
Ctrl+F12
F2
Ctrl+1
Ctrl+F1
Directly typing function name in a cell
Using function wizard or selecting from toolbar
Both (a) and (b)
Depends on the function
Filtering
Title bar
Standard Toolbar
Formatting Toolbar
Formula Bar
0
15
Date( )
Now( )
Time( )
=SUM(J14:J16)
=SUM(J14?J16)
SUM(J14:J16)
J14+J15+J16
Column
Value
Address
Cell
AutoFilter
Advanced Filter
Standard
400
6.25
7
500
OpenDocument
Microsoft Excel
PDF
All the above
Searching
Validating
Edited
Shown
Deleted
Match the following chart elements with their descriptions.
A-4, B-1, C-2, D-3
A-2, B-3, C-4, D-1
200
300
00
2.75
1
56
-1
Corel Draw
Wordstar
EXCEL
MS-WORD
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
Ctrl + +
Ctrl + -
Ctrl + D
Delete
3
Find and replace
By Copy only
By copy command
By preview command
Ctrl + ;
Ctrl + Shift + ;
Ctrl + T
Ctrl + Shift + :
A and B both
1024 rows and 1048576 columns
10000 rows and 32000 columns
1,048,576 rows and 16,384 columns
None of above
Shift + 1
Ctrl + 1
Alt + 1
Ctrl + Alt + 1
Heading1
Good
Bad
Poor
A3
$A$3
A$3
$A3
Data Series
Chart Series
Chart Elements
Chat type
AMJ
XFD
AMG
EMJ
Ctrl + A
Ctrl+ Shift + A
Ctrl + Shift + Space
A and C Both
Add Database
Add Table
Add Relation
Exchange Database
98
97
91
Instant messaging, address book, antivirus, mailing list
Forms, data analysis, conditional formatting, sorting and filtering
Graphics, templates, spell checker, thesaurus
Accessibility, multimedia, hyperlinks, updated
Shift + F3
Ctrl + F2
Ctrl + F3
Alt + F3
See Only Specific Data
Arrange data
Copy Data
Making Chart
Match the following mathematical functions with their purposes.
1024
1048576
16384