Relative address
Absolute address
Mixed address
Dynamic address
N10
M11
M9
M12
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
35
-35
12
2
Insert
Data
Tools
View
Ctrl + F6
Ctrl + H
Ctrl + F8
Ctrl + F1
Ctrl + W
Ctrl + Q
Ctrl + Shift + C
Shift + W
Cell
Tabel
Position
Mathematical
Financial
Statistical, logical
All of these
Ctrl + Shift + P
Ctrl + Shift + O
Ctrl + P
None of These
Shift + 1
Ctrl + 1
Alt + 1
Ctrl + Alt + 1
Calc
Base
Writer
Impress
14000
14200
14300
14243.25
Function
Formula
Graph
Chart
DCOUNT
DCOUNTA
COUNTA
COUNTIF
AMJ
XFD
AMG
EMJ
Data Series
Chart Series
Chart Elements
Chat type
Use the WEEK() function
Press Enter repeatedly after typing Monday
se the Calendar
Type Monday, then drag the fill handle
SUM
COUNT
AVERAGE
MEAN
Store data
Manipulate data
Create graphical representation of data
Ctrl + V
Ctrl + M
Ctrl + Shift + F
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
A dark wide border
A dotted border
A blinking border
By italic text
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
Sorting
Filter
Inserting
Deleting
1048576
16348
1084576
1024598
Ctrl + C
Ctrl + Shift + T
Ctrl + Alt + C
256
1028
10000
A,B,C,….
1,2,3….
A1, B1, C1…
1A, 1B, 1C…
Ctrl + ;
Ctrl + Shift + :
A and B both
None
.ods
.odt
.ott
.odf
Corel Draw
Wordstar
EXCEL
MS-WORD
###
The cell size increase automatically
####
#Name?
1024 rows and 1048576 columns
10000 rows and 32000 columns
1,048,576 rows and 16,384 columns
None of above
DSUM
File name
Location where the file is to be saved
Both A and B
None of these
Left
Right
Center
Justified
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
B1&B5
B1*B5
B1#B5
B1:B5
Edited
Shown
Deleted
All the above
Instant messaging, address book, antivirus, mailing list
Forms, data analysis, conditional formatting, sorting and filtering
Graphics, templates, spell checker, thesaurus
Accessibility, multimedia, hyperlinks, updated
To format cells
To perform calculations and manipulate data
To insert images
Text Files
Satellite data
Sensor data
Seismic imagery data
Filtering
1048576 Rows & 1024 Columns
1048576 Rows & 16384 Columns
16384 Rows & 1048576 Columns
1024 Rows & 1048576 Columns
'=' sign
Alphabets
Numbers
All of the these
Untitled1
Calc1
Spreadsheet1
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
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
A3
$A$3
A$3
$A3