8
12
14
10
CTRL+E
CTRL+ Alt+ E
CTRL+Shift+E
CTRL+F9
B2:C7 – includes all cells from B2 to C7
B2:C7 – includes only B2 and C7
B2:C7 – includes B2:B7 and C2:C7 but skips B3:C6
B2:C7 – includes only the first row and first column
Shift + 1
Ctrl + 1
Alt + 1
Ctrl + Alt + 1
Store data
Manipulate data
Create graphical representation of data
All of these
Media Playback
3D settings
Painting
Drawing
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
All of above
Calc
Base
Writer
Impress
CTRL+P
CTRL+Shift+P
Alt+P
CTRL+Alt+P
7
3
1
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
Lock Cells
Freeze Panes
Split Sheet
Protect Sheet
Horizontal
Vertical
Both A and B
None of These
Data Series
Chart Series
Chart Elements
Chat type
View
Data
Tools
Format
Non-breaking space
Non-breaking hyphen
Word Joiner
Sentence Joiner
1024
1048576
16384
A,B,C,….
1,2,3….
A1, B1, C1…
1A, 1B, 1C…
35
-35
2
Ctrl + Shift + P
Ctrl + Shift + O
Ctrl + P
Ctrl+E
Ctrl+W
Ctrl+T
Ctrl+Q
Ctrl + ]
Alt +D
Ctrl + ;
Shift + K
Nested Function
Function
General Function
Condition Function
DCOUNT
DCOUNTA
DSUM
SUM
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
Split Cells
Insert Row
Merge Cells
Delete Column
Draw
Numbers (1, 2, 3...)
Letters (A, B, C...)
Both numbers and letters
Special symbols
@
#
$
&
Match the following error types in LibreOffice Calc with their meanings.
A-1, B-2, C-3, D-4
A-3, B-1, C-4, D-2
A-4, B-3, C-2, D-1
A-2, B-4, C-1, D-3
Cell
Tabel
Position
Ctrl+]
Ctrl+[
Ctrl+}
Ctrl+{
Directly typing function name in a cell
Using function wizard or selecting from toolbar
Both (a) and (b)
Depends on the function
Prediction Values
Variable Cell
What if Values
Target Value
Bring to Front
Send to Back
Send to Front
Forward One
Shape
Object
Chart
Pie
256
1028
10000
15
56
-1
None
File
Edit
Insert
Relative address
Absolute address
Mixed address
Dynamic address
COUNTA
COUNTIF
AMJ
XFD
AMG
EMJ
To add data
Formatting
To add formula
Ctrl + Shift + F
Ctrl + Shift + S
Ctrl + F2
Formula Bar
Name Box
Address Book
Address Bar
247
200
240
200.47
AutoFilter
Advanced Filter
Standard
Sorting
Match the following chart types in LibreOffice Calc with their suitable use cases.
A-3, B-4, C-1, D-2
A-2, B-1, C-4, D-3