Format
Style
Sheet
Edit
Function
Formula
Graph
Chart
Ctrl+]
Ctrl+[
Ctrl+}
Ctrl+{
Left
Right
Center
Justified
511
508
510
509
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
Spreadsheet
Double sheet
Multi-sheet
Cannot determine
Bottom left of the menu bar
Top left over menubar
On the status bar
Bottom right side of the menu bar
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
Ctrl + Shift + B
Ctrl + Shift + P
Ctrl + Shift + +
None of these
A dotted border
A dark wide border
A blinking border
By italic text
Shift + V
Ctrl+ V
Ctrl + Alt + V
Ctrl + Shift + V
AMJ
XFD
AMG
EMJ
Ctrl+E
Ctrl+W
Ctrl+T
Ctrl+Q
Ctrl + Space
Shift + Space
Ctrl + Shift + Page down
None
Ctrl + Shift + C
Ctrl + C
Ctrl + Shift + T
Ctrl + Alt + C
Ctrl+f
Ctrl+D
Ctrl+L
Ctrl+1
1024
1048576
16384
Shift + 1
Ctrl + 1
Alt + 1
Ctrl + Alt + 1
Use the WEEK() function
Press Enter repeatedly after typing Monday
se the Calendar
Type Monday, then drag the fill handle
Calculating result
Sorting on result
Filtering on result
All of these
Ctrl + A
Ctrl + shift + Space
Ctrl + Shift + A
A & B both
do calculations
create graphics
plot graphs
plot charts
See Only Specific Data
Arrange data
Copy Data
Making Chart
Shift+F2
Shift+F5
Shift+F3
CTRL+F9
Ctrl + V
1199
1210
1188
Horizontal
Vertical
Both A and B
None of These
Ctrl + M
Ctrl + Shift + F
Match the following mathematical functions with their purposes.
OpenDocument
Microsoft Excel
PDF
All the above
Match the LibreOffice Calc functions with their output.
1 → E, 2 → B, 3 → D, 4 → C
1 → D, 2 → A, 3 → E, 4 → C
1 → B, 2 → E, 3 → A, 4 → D
1 → B, 2 → C, 3 → A, 4 → E
File name
Location where the file is to be saved
Mathematical
Financial
Statistical, logical
Pause
Stop
Freeze
Scroll Off
Pie Chart
Line Chart
Doughnut Chart
Radar Chart
1048576 Rows & 1024 Columns
1048576 Rows & 16384 Columns
16384 Rows & 1048576 Columns
1024 Rows & 1048576 Columns
Change
Text
Transpose
Convert
200
300
00
2.75
###
The cell size increase automatically
####
#Name?
1
15
56
-1
Ctrl + ;
Ctrl + Shift + :
A and B both
.ods
.xls
.odx
.txt
=ADD(A1:A10)
=TOTAL(A1:A10)
=SUM(A1:A10)
=SUM(A1,A10)
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
@
#
$
&
300%
200%
400%
500%
Media Playback
3D settings
Painting
Drawing
Date
Cell Value