Tab
Ctrl + Tab
Ctrl + Shift + Tab
Shift + Tab
Untitled1
Calc1
Spreadsheet1
None of These
Ctrl+f
Ctrl+D
Ctrl+L
Ctrl+1
Left
Right
Center
Justified
A,B,C,….
1,2,3….
A1, B1, C1…
1A, 1B, 1C…
Recalculated formulas in all sheets
Update chart
Open Styles
Create a document template
1199
1210
1188
None
Data
Math / Tring
Mathematical
String
Title bar
Standard Toolbar
Formatting Toolbar
Formula Bar
Match the following LibreOffice Calc data tools with their functionalities.
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
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
Ctrl + ]
Alt +D
Ctrl + ;
Shift + K
Edited
Shown
Deleted
All the above
Bubble
Circle
Baloon
Hollow
Bring to Front
Send to Back
Send to Front
Forward One
Drawing charts
Summarizing large datasets
Formatting sheets
Printing reports
CTRL+E
CTRL+ Alt+ E
CTRL+Shift+E
CTRL+F9
To create charts and graphs
To format cells
To perform calculations and manipulate data
To insert images
Spreadsheet
Double sheet
Multi-sheet
Cannot determine
Shift+F7
CTRL+F7
Shift+F9
AutoFilter
Conditional formatting
Pivot tables
Data validation
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
Shift+F2
Shift+F5
Shift+F3
Date( )
Now( )
Time( )
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
Match the following chart types in LibreOffice Calc with their suitable use cases.
Pause
Stop
Freeze
Scroll Off
Sorting
Searching
Filtering
Validating
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
B1&B5
B1*B5
B1#B5
B1:B5
DGET
DAGGREGATE
DSUM
DCOUNT
Data formatting
Data sorting
Data filtering
Deletes unwanted data
Hides records not matching criteria
Sorts data automatically
Creates reports
Ctrl + F2
Ctrl + F4
Ctrl + F3
None of these
Match the following error types in LibreOffice Calc with their meanings.
A-3, B-1, C-4, D-2
A-2, B-4, C-1, D-3
256
1028
10000
Financial
Statistical, logical
All of these
1048576
16348
1084576
1024598
7,2
7+2
9
5,7
Text
Ctrl + A
Ctrl+ Shift + A
Ctrl + Shift + Space
A and C Both
Add Database
Add Table
Add Relation
Exchange Database
Calculating result
Sorting on result
Filtering on result
Ctrl + Shift + F
Ctrl + Shift + S
Print View
Print Preview
Print Screen
Print Document
Heading1
Good
Bad
Poor
Chart Title
Data Label
Chart Area
Chart Line
.ODF
.ODT
.ODS
.OBT
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
Two
Three
Four
Five