Cut, Copy, Paste
Find and Replace
Select All
All of these
AutoFilter
Advanced Filter
Standard
Sorting
98
97
91
None
Line chart
Pie chart
Bar chart
Square chart
1024
1048576
16384
Inserting
Filtering
Deleting
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
4
20
25
50
Ctrl+F12
F2
Ctrl+1
Ctrl+F1
Match the following cell referencing types with their descriptions.
A-1, B-2, C-3, D-4
A-2, B-1, C-4, D-3
A-3, B-4, C-1, D-2
A-4, B-3, C-2, D-1
Ctrl + F6
Ctrl + H
Ctrl + F8
Ctrl + F1
do calculations
create graphics
plot graphs
plot charts
Data Series
Chart Series
Chart Elements
Chat type
Open Find dialog box
Open Find & Replace dialog box
Font dialog box
Format dialog box
N10
M11
M9
M12
Untitled1
Calc1
Spreadsheet1
None of These
###
The cell size increase automatically
####
#Name?
X.502
X.503
X.510
X.509
Freeze current column
Freeze current cell
Freeze current row
Freeze First Row
Non-breaking space
Non-breaking hyphen
Word Joiner
Sentence Joiner
Instant messaging, address book, antivirus, mailing list
Forms, data analysis, conditional formatting, sorting and filtering
Graphics, templates, spell checker, thesaurus
Accessibility, multimedia, hyperlinks, updated
Match the following mathematical functions with their purposes.
A-2, B-3, C-4, D-1
A-4, B-1, C-2, D-3
CTRL+P
CTRL+Shift+P
Alt+P
CTRL+Alt+P
Searching
Validating
To add data
Formatting
To add formula
Bring to Front
Send to Back
Send to Front
Forward One
16348
1084576
1024598
200
300
00
2.75
8
10
12
14
Ctrl + +
Ctrl + -
Ctrl + D
Delete
Calculating result
Sorting on result
Filtering on result
Draw
Impress
Calc
Writer
400
6.25
7
500
Data
Text
Mathematical
String
Ctrl+Shift+V
Ctrl+V
Ctrl+C
Strl+Shift+S
Shift+F2
Shift+F5
Shift+F3
CTRL+F9
3
1
Data formatting
Data sorting
Data filtering
Data validation
Line
Pie
Bar
Column
Ctrl+E
Ctrl+W
Ctrl+T
Ctrl+Q
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
Sorts data
Adjusts row/column size automatically
Creates formulas
Protects cells
=ADD(A1:A10)
=TOTAL(A1:A10)
=SUM(A1:A10)
=SUM(A1,A10)
Ctrl + Space
Shift + Space
Ctrl + Shift + Page down
Match the following error types in LibreOffice Calc with their meanings.
A-3, B-1, C-4, D-2
A-2, B-4, C-1, D-3
15
5
Letter
Fax
Agenda
E-mail
256
1028
10000