Sorting
Filter
Inserting
Deleting
Ctrl + Shift + C
Ctrl + C
Ctrl + Shift + T
Ctrl + Alt + C
A unique identifier for each cell in the spreadsheet
A function used to format cells
A hyperlink to another cell or document
A shortcut key for accessing cells
10
7
3
No one
Ctrl + Shift + V
Ctrl + V
Ctrl + Alt + V
Shift + V
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
Function
Formula
Graph
Chart
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
Ctrl + Shift + P
Ctrl + Shift + O
Ctrl + P
None of These
1199
1210
1188
None
Filtering
File
Edit
View
Insert
300%
200%
400%
500%
Mathematical
Financial
Statistical, logical
All of these
Untitled1
Calc1
Spreadsheet1
None of these
AutoFilter
Advanced Filter
Standard
Instant messaging, address book, antivirus, mailing list
Forms, data analysis, conditional formatting, sorting and filtering
Graphics, templates, spell checker, thesaurus
Accessibility, multimedia, hyperlinks, updated
DCOUNT
DCOUNTA
DSUM
SUM
1024 rows and 1048576 columns
10000 rows and 32000 columns
1,048,576 rows and 16,384 columns
None of above
Open Find dialog box
Open Find & Replace dialog box
Font dialog box
Format dialog box
256
1028
10000
1024
1048576
16384
$D$10
AMJ1048575
XFD1048576
$AMD$1048576
400
6.25
500
.ods
.xls
.odx
.txt
.odp
.odd
.odt
N10
M11
M9
M12
Calc
Write
Publisher
Excel
Cell
Column
Row
Sheet
Google Drive
One Drive
IBM Lotus Notes
FTP
Relative address
Absolute address
Mixed address
Dynamic address
File name
Location where the file is to be saved
Both A and B
OpenDocument
Microsoft Excel
PDF
All the above
Shift + F3
Ctrl + F2
Ctrl + F3
Alt + F3
Heading1
Good
Bad
Poor
7,2
7+2
9
5,7
Format
Style
1
15
56
-1
Ctrl+F12
F2
Ctrl+1
Ctrl+F1
Prediction Values
Variable Cell
What if Values
Target Value
247
200
240
200.47
Sort
List
Arrange
4
5
Ctrl + ;
Shift + D
Ctrl + D
Alt + D
Base
Writer
Impress
Ctrl + Shift + F
Ctrl + Shift + S
Line chart
Pie chart
Bar chart
Square chart
Ctrl+f
Ctrl+D
Ctrl+L
Media Playback
3D settings
Painting
Drawing