Ctrl + A
Ctrl + shift + Space
Ctrl + Shift + A
A & B both
%
$
&
=
Prediction Values
Result Values
What-if Values
Assumption Values
Up and Down scroll
Right and left
Horizontal and Vertical
All of above
Directly typing function name in a cell
Using function wizard or selecting from toolbar
Both (a) and (b)
Depends on the function
Chart Title
Data Label
Chart Area
Chart Line
256
1028
10000
None of These
=SUM(J14:J16)
=SUM(J14?J16)
SUM(J14:J16)
J14+J15+J16
Recalculated formulas in all sheets
Update chart
Open Styles
Create a document template
Media Playback
3D settings
Painting
Drawing
Formula Bar
Address Book
Name box
None
Calc
Write
Publisher
Excel
Google Drive
One Drive
IBM Lotus Notes
FTP
Match the following chart types in LibreOffice Calc with their suitable use cases.
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
Column
Value
Address
Cell
Shift + 1
Ctrl + 1
Alt + 1
Ctrl + Alt + 1
Mathematical
Financial
Statistical, logical
All of these
Bubble
Circle
Baloon
Hollow
N10
M11
M9
M12
Line
Pie
Bar
Data Series
Chart Series
Chart Elements
Chat type
Cut, Copy, Paste
Find and Replace
Select All
Store data
Manipulate data
Create graphical representation of data
OpenDocument
Microsoft Excel
PDF
All the above
Pie Chart
Line Chart
Doughnut Chart
Radar Chart
.ods
.xls
.odx
.txt
C1:10H
C1:H10
C1:H-10
C1:H:10
1024
1048576
16384
Name Box
Address Bar
A3
$A$3
A$3
$A3
Center
Split Cells
Split and merge
Merge and center
500%
400%
350%
600%
Shift + V
Ctrl+ V
Ctrl + Alt + V
Ctrl + Shift + V
'=' sign
Alphabets
Numbers
All of the these
Ctrl + W
Ctrl + Q
Ctrl + Shift + C
Shift + W
F2
Ctrl + Shift + M
Ctrl + M
F3
Ctrl + F6
Ctrl + H
Ctrl + F8
Ctrl + F1
Ctrl + F2
Ctrl + F4
Ctrl + F3
None of these
Ctrl+Shift+V
Ctrl+V
Ctrl+C
Strl+Shift+S
To add data
Formatting
To add formula
Ctrl + Shift + P
Ctrl + Shift + O
Ctrl + P
Function
Formula
Graph
Chart
Ctrl + Shift + F
Ctrl + Shift + S
Single-click the boundary to the left to the column heading
Double click the boundary to the right of the column heading
Press Alt and single click anywhere in the column
AMJ
XFD
AMG
EMJ
B1&B5
B1*B5
B1#B5
B1:B5
8
12
14
10
###
The cell size increase automatically
####
#Name?
Line chart
Pie chart
Bar chart
Square chart
3
7
1