Ctrl + ]
Alt +D
Ctrl + ;
Shift + K
AutoFilter
Advanced Filter
Standard
Sorting
300%
200%
400%
500%
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
0
5
15
Change
Text
Transpose
Convert
Find and replace
By Copy only
By copy command
By preview command
1048576 Rows & 1024 Columns
1048576 Rows & 16384 Columns
16384 Rows & 1048576 Columns
1024 Rows & 1048576 Columns
Untitled1
Calc1
Spreadsheet1
None of These
Tab
Ctrl + Tab
Ctrl + Shift + Tab
Shift + Tab
By manual entry
By auto-sum
By formula
By sum function
Left
Right
Center
Justified
Draw
Impress
Calc
Writer
@
#
$
&
Ctrl + Shift + B
Ctrl + Shift + P
Ctrl + Shift + +
None of these
Ctrl + W
Ctrl + Q
Ctrl + Shift + C
Shift + W
A3
$A$3
A$3
$A3
Google Drive
One Drive
IBM Lotus Notes
FTP
Date
Formula
Cell Value
All the above
7
3
No one
'=' sign
Alphabets
Numbers
All of the these
Data
Mathematical
String
Base
N10
M11
M9
M12
Ctrl + C
Ctrl + M
Ctrl + Shift + M
None
Ctrl + Shift + 1
Ctrl + Shift + 5
Ctrl + Shift + 4
Ctrl + Shift + 3
Recalculated formulas in all sheets
Update chart
Open Styles
Create a document template
Relative address
Absolute address
Mixed address
Dynamic address
Ctrl + F6
Ctrl + H
Ctrl + F8
Ctrl + F1
###
The cell size increase automatically
####
#Name?
Ctrl+Shift+V
Ctrl+V
Ctrl+C
Strl+Shift+S
Bubble
Circle
Baloon
Hollow
#name?
#name
Whatever is written in a formula will remain the same
Shift+F7
CTRL+F7
Shift+F9
CTRL+F9
Ctrl + Shift + O
Ctrl + P
B1&B5
B1*B5
B1#B5
B1:B5
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
Ctrl + Shift + V
Ctrl + V
Ctrl + Alt + V
Shift + V
Store data
Manipulate data
Create graphical representation of data
All of these
C1:10H
C1:H10
C1:H-10
C1:H:10
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
Bring to Front
Send to Back
Send to Front
Forward One
1024
1048576
16384
Cell
Tabel
Position
Edited
Shown
Deleted
Column
Row
Sheet
%
=
Media Playback
3D settings
Painting
Drawing
14000
14200
14300
14243.25
16348
1084576
1024598