Ctrl + Shift + F
Ctrl + Shift + S
Ctrl + F2
None
Shift + F3
Ctrl + F3
Alt + F3
10
0
5
15
%
$
&
=
do calculations
create graphics
plot graphs
plot charts
Up and Down scroll
Right and left
Horizontal and Vertical
All of above
Bottom left of the menu bar
Top left over menubar
On the status bar
Bottom right side of the menu bar
$D$10
AMJ1048575
XFD1048576
$AMD$1048576
Ctrl + Shift + P
Ctrl + Shift + O
Ctrl + P
None of These
Ctrl + A
Ctrl+ Shift + A
Ctrl + Shift + Space
A and C Both
AMJ
XFD
AMG
EMJ
Column
Value
Address
Cell
Recalculated formulas in all sheets
Update chart
Open Styles
Create a document template
Calculating result
Sorting on result
Filtering on result
All of these
Function
Formula
Graph
Chart
Ctrl + shift + Space
Ctrl + Shift + A
A & B both
Prediction Values
Variable Cell
What if Values
Target Value
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
DCOUNT
DCOUNTA
DSUM
SUM
Draw
Impress
Calc
Writer
Shift+F2
Shift+F5
Shift+F3
CTRL+F9
Spreadsheet
Double sheet
Multi-sheet
Cannot determine
Ctrl+F12
F2
Ctrl+1
Ctrl+F1
8
12
14
Match the following chart elements with their descriptions.
A-1, B-2, C-3, D-4
A-4, B-1, C-2, D-3
A-3, B-4, C-1, D-2
A-2, B-3, C-4, D-1
Ctrl + Shift + 1
Ctrl + Shift + 5
Ctrl + Shift + 4
Ctrl + Shift + 3
Change
Text
Transpose
Convert
Bold, Italics, Underline
Left, Center, Right, Justify
Font Name, Font Size, Font Color
Date
Cell Value
All the above
511
508
510
509
Match the following LibreOffice Calc data tools with their functionalities.
A-4, B-3, C-2, D-1
A-2, B-1, C-4, D-3
Match the following cell referencing types with their descriptions.
Format
Style
Sheet
Edit
200
300
00
2.75
Sorting
Inserting
Filtering
Deleting
Bubble
Circle
Baloon
Hollow
Instant messaging, address book, antivirus, mailing list
Forms, data analysis, conditional formatting, sorting and filtering
Graphics, templates, spell checker, thesaurus
Accessibility, multimedia, hyperlinks, updated
11
13
cell reference
cell identify
cell across
cell identification number
1024
1048576
16384
Pause
Stop
Freeze
Scroll Off
Data formatting
Data sorting
Data filtering
Data validation
Date( )
Now( )
Time( )
Find and replace
By Copy only
By copy command
By preview command
Add Database
Add Table
Add Relation
Exchange Database
Ctrl + Shift + V
Ctrl + V
Ctrl + Alt + V
Shift + V
Match the following LibreOffice Calc Error code with its description
1 → B, 2 → E, 3 → D, 4 → A
1 → B, 2 → F, 3 → D, 4 → E
1 → A, 2 → B, 3 → F, 4 → C
1 → F, 2 → E, 3 → D, 4 → A
Insert
Data
Tools
View
Ctrl + ;
Ctrl + Shift + :
A and B both
Save As
Save
Save File
Save As File