Store data
Manipulate data
Create graphical representation of data
All of these
Ctrl + Shift + V
Ctrl + V
Ctrl + Alt + V
Shift + V
A,B,C,….
1,2,3….
A1, B1, C1…
1A, 1B, 1C…
Mathematical
Financial
Statistical, logical
Filter
Sort
List
Arrange
Media Playback
3D settings
Painting
Drawing
Sorting
Inserting
Filtering
Deleting
32000
48000
60000
None of these
Nested Function
Function
General Function
Condition Function
Center
Split Cells
Split and merge
Merge and center
Two
Three
Four
Five
Spreadsheet
Double sheet
Multi-sheet
Cannot determine
AMJ
XFD
AMG
EMJ
Searching
Validating
=SUM(J14:J16)
=SUM(J14?J16)
SUM(J14:J16)
J14+J15+J16
500%
400%
350%
600%
Data
Math / Tring
String
Ctrl+]
Ctrl+[
Ctrl+}
Ctrl+{
Ctrl+f
Ctrl+D
Ctrl+L
Ctrl+1
Shift + F3
Ctrl + F2
Ctrl + F3
Alt + F3
.ods
.xls
.odx
.txt
Calc
Write
Publisher
Excel
7,2
7+2
9
5,7
15
3
4
5
11
12
13
10
1
56
-1
Pause
Stop
Freeze
Scroll Off
1024
1048576
16384
None
Ctrl + Shift + 1
Ctrl + Shift + 5
Ctrl + Shift + 4
Ctrl + Shift + 3
CTRL+E
CTRL+ Alt+ E
CTRL+Shift+E
CTRL+F9
B1&B5
B1*B5
B1#B5
B1:B5
400
6.25
7
500
$
@
=
None of These
2
16348
1084576
1024598
Ctrl + M
Ctrl + Shift + F
Ctrl + 1
Shift + 1
Alt + 1
Ctrl + Alt + 1
Shape
Object
Chart
Pie
Text
Ctrl + F6
Ctrl + H
Ctrl + F8
Ctrl + F1
Google Drive
One Drive
IBM Lotus Notes
FTP
Ctrl + v
X.502
X.503
X.510
X.509
98
97
91
OpenDocument
Microsoft Excel
PDF
All the above
C1:10H
C1:H10
C1:H-10
C1:H:10
Ctrl + A
Ctrl + shift + Space
Ctrl + Shift + A
A & B both
Open Find dialog box
Open Find & Replace dialog box
Font dialog box
Format dialog box
See Only Specific Data
Arrange data
Copy Data
Making Chart