By manual entry
By auto-sum
By formula
By sum function
Sorting
Searching
Filtering
Validating
F2
Ctrl + Shift + M
Ctrl + M
F3
Shift + F3
Ctrl + F2
Ctrl + F3
Alt + F3
15
3
4
5
Nested Function
Function
General Function
Condition Function
1
56
-1
Mathematical
Financial
Statistical, logical
All of these
Edited
Shown
Deleted
All the above
7,2
7+2
9
5,7
AutoFilter
Conditional formatting
Pivot tables
Data validation
Ctrl + +
Ctrl + -
Ctrl + D
Delete
X.502
X.503
X.510
X.509
CTRL+E
CTRL+ Alt+ E
CTRL+Shift+E
CTRL+F9
Format
Style
Sheet
Edit
Formula Bar
Address Book
Name box
None
32000
48000
60000
None of these
Ctrl + F6
Ctrl + H
Ctrl + F8
Ctrl + F1
Non-breaking space
Non-breaking hyphen
Word Joiner
Sentence Joiner
Advanced Filter
Standard
Add Database
Add Table
Add Relation
Exchange Database
Insert
Data
Tools
View
Inserting
Deleting
.odt
.ods
.odp
.xlsx
14000
14200
14300
14243.25
###
The cell size increase automatically
####
#Name?
1048576
16348
1084576
1024598
Math / Tring
String
Center
Split Cells
Split and merge
Merge and center
$D$10
AMJ1048575
XFD1048576
$AMD$1048576
Ctrl + Shift + V
Ctrl + V
Ctrl + Alt + V
Shift + V
10
7
Find and replace
By Copy only
By copy command
By preview command
Ctrl + Shift + P
Ctrl + Shift + O
Ctrl + P
None of These
1024 rows and 1048576 columns
10000 rows and 32000 columns
1,048,576 rows and 16,384 columns
None of above
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
#name?
#name
Whatever is written in a formula will remain the same
Text
Calc
Write
Publisher
Excel
Google Drive
One Drive
IBM Lotus Notes
FTP
Ctrl + W
Ctrl + Q
Ctrl + Shift + C
Shift + W
Filter
A,B,C,….
1,2,3….
A1, B1, C1…
1A, 1B, 1C…
Ctrl + v
Ctrl + Shift + F
Ctrl + 1
Untitled1
Calc1
Spreadsheet1
-5
25
50
11
12
13
Ctrl+E
Ctrl+W
Ctrl+T
Ctrl+Q
Spreadsheet
Double sheet
Multi-sheet
Cannot determine