Nested Function
Function
General Function
Condition Function
Match the following mathematical functions with their purposes.
A-1, B-2, C-3, D-4
A-2, B-3, C-4, D-1
A-3, B-4, C-1, D-2
A-4, B-1, C-2, D-3
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
Save As
Save
Save File
Save As File
Ctrl + Shift + C
Ctrl + C
Ctrl + Shift + T
Ctrl + Alt + C
OpenDocument
Microsoft Excel
PDF
All the above
1048576
16348
1084576
1024598
Non-breaking space
Non-breaking hyphen
Word Joiner
Sentence Joiner
A,B,C,….
1,2,3….
A1, B1, C1…
1A, 1B, 1C…
Cut, Copy, Paste
Find and Replace
Select All
All of these
1048576 Rows & 1024 Columns
1048576 Rows & 16384 Columns
16384 Rows & 1048576 Columns
1024 Rows & 1048576 Columns
Ctrl + Shift + 1
Ctrl + Shift + 5
Ctrl + Shift + 4
Ctrl + Shift + 3
Untitled1
Calc1
Spreadsheet1
None of these
Shift+F7
CTRL+F7
Shift+F9
CTRL+F9
1
15
56
-1
=SUM(J14:J16)
=SUM(J14?J16)
SUM(J14:J16)
J14+J15+J16
Open Find dialog box
Open Find & Replace dialog box
Font dialog box
Format dialog box
Ctrl + F2
Ctrl + F4
Ctrl + F3
do calculations
create graphics
plot graphs
plot charts
.ods
.odt
.ott
.odf
Horizontal
Vertical
Both A and B
None of These
Sorting
Inserting
Filtering
Deleting
Ctrl + 4
Ctrl + 3
Ctrl + 2
Ctrl + 1
###
The cell size increase automatically
####
#Name?
Bring to Front
Send to Back
Send to Front
Forward One
Formula Bar
Address Book
Name box
None
Letter
Fax
Agenda
E-mail
Spreadsheet
Double sheet
Multi-sheet
Cannot determine
Chart Title
Data Label
Chart Area
Chart Line
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
2
3
4
35
-35
12
Searching
Validating
Match the following chart types in LibreOffice Calc with their suitable use cases.
A-4, B-3, C-2, D-1
A-2, B-1, C-4, D-3
CTRL+E
CTRL+ Alt+ E
CTRL+Shift+E
Pause
Stop
Freeze
Scroll Off
Line
Pie
Bar
Column
Mathematical
Financial
Statistical, logical
Freeze current column
Freeze current cell
Freeze current row
Freeze First Row
=
*
/
-
Match the following chart elements with their descriptions.
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
Shift + F3
Alt + F3
Ctrl + Shift + B
Ctrl + Shift + P
Ctrl + Shift + +
Ctrl+Shift+V
Ctrl+V
Ctrl+C
Strl+Shift+S
32000
48000
60000
1024 rows and 1048576 columns
10000 rows and 32000 columns
1,048,576 rows and 16,384 columns
None of above
DCOUNT
DCOUNTA
DSUM
SUM
Insert
Data
Tools
View