.odp
.ods
.odd
.odt
Shift+F7
CTRL+F7
Shift+F9
CTRL+F9
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
300%
200%
400%
500%
Untitled1
Calc1
Spreadsheet1
None of These
Shape
Object
Chart
Pie
Sorting
Searching
Filtering
Validating
Ctrl + F2
Ctrl + F4
Ctrl + F3
None of these
Center
Split Cells
Split and merge
Merge and center
Bold, Italics, Underline
Left, Center, Right, Justify
Font Name, Font Size, Font Color
400
6.25
7
500
Filter
Inserting
Deleting
Ctrl + F6
Ctrl + H
Ctrl + F8
Ctrl + F1
1048576 Rows & 1024 Columns
1048576 Rows & 16384 Columns
16384 Rows & 1048576 Columns
1024 Rows & 1048576 Columns
AutoFilter
Conditional formatting
Pivot tables
Data validation
Ctrl + A
Ctrl + shift + Space
Ctrl + Shift + A
A & B both
To create charts and graphs
To format cells
To perform calculations and manipulate data
To insert images
Ctrl+F12
F2
Ctrl+1
Ctrl+F1
247
200
240
200.47
Calc
Write
Publisher
Excel
Date
Formula
Cell Value
All the above
Ctrl+]
Ctrl+[
Ctrl+}
Ctrl+{
Base
Writer
Impress
Date( )
Now( )
Time( )
Match the following mathematical functions with their purposes.
A-1, B-2, C-3, D-4
A-2, B-3, C-4, D-1
A-3, B-4, C-1, D-2
A-4, B-1, C-2, D-3
Ctrl + Shift + 1
Ctrl + Shift + 5
Ctrl + Shift + 4
Ctrl + Shift + 3
Ctrl + v
Ctrl + M
Ctrl + Shift + F
Ctrl + 1
Ctrl + 4
Ctrl + 3
Ctrl + 2
Sort
List
Arrange
Heading1
Good
Bad
Poor
32000
48000
60000
256
1028
10000
Bring to Front
Send to Back
Send to Front
Forward One
Mathematical
Financial
Statistical, logical
All of these
.xlsx
Ctrl+ Shift + A
Ctrl + Shift + Space
A and C Both
Tab
Ctrl + Tab
Ctrl + Shift + Tab
Shift + Tab
350%
600%
Find and replace
By Copy only
By copy command
By preview command
Store data
Manipulate data
Create graphical representation of data
Corel Draw
Wordstar
EXCEL
MS-WORD
14000
14200
14300
14243.25
Letter
Fax
Agenda
E-mail
Ctrl + Space
Shift + Space
Ctrl + Shift + Page down
None
Ctrl + Shift + S
Match the following error types in LibreOffice Calc with their meanings.
A-3, B-1, C-4, D-2
A-4, B-3, C-2, D-1
A-2, B-4, C-1, D-3
Match the following LibreOffice Calc data tools with their functionalities.
A-2, B-1, C-4, D-3
#name?
#name
Whatever is written in a formula will remain the same
####