Relative address
Absolute address
Mixed address
Dynamic address
Ctrl + F2
Ctrl + F4
Ctrl + F3
None of these
400
6.25
7
500
@
#
$
&
CTRL+E
CTRL+ Alt+ E
CTRL+Shift+E
CTRL+F9
256
1028
10000
None of These
Sorting
Inserting
Filtering
Deleting
Open Find dialog box
Open Find & Replace dialog box
Font dialog box
Format dialog box
14000
14200
14300
14243.25
By manual entry
By auto-sum
By formula
By sum function
10
0
5
15
Chart Title
Data Label
Chart Area
Chart Line
Two
Three
Four
Five
Line
Pie
Bar
Column
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
1
2
3
4
1024
1048576
16384
Ctrl + ;
Ctrl + Shift + :
A and B both
None
File
Edit
View
Insert
Shape
Object
Chart
56
-1
Ctrl+Shift+V
Ctrl+V
Ctrl+C
Strl+Shift+S
Add Database
Add Table
Add Relation
Exchange Database
Formula Bar
Address Book
Name box
Cut, Copy, Paste
Find and Replace
Select All
All of these
Ctrl + Shift + F
Ctrl + Shift + S
2,4,6,2,4
2,4,6,8,10
6,6,6,6
Error
Shift+F2
Shift+F5
Shift+F3
C1:10H
C1:H10
C1:H-10
C1:H:10
=
Left
Right
Center
Justified
Line chart
Pie chart
Bar chart
Square chart
8
12
14
Ctrl + W
Ctrl + Q
Ctrl + Shift + C
Shift + W
Media Playback
3D settings
Painting
Drawing
200
300
00
2.75
A3
$A$3
A$3
$A3
Bring to Front
Send to Back
Send to Front
Forward One
N10
M11
M9
M12
.ODF
.ODT
.ODS
.OBT
247
240
200.47
Searching
Validating
Up and Down scroll
Right and left
Horizontal and Vertical
All of above
Ctrl + +
Ctrl + -
Ctrl + D
Delete
Ctrl + A
Ctrl + shift + Space
Ctrl + Shift + A
A & B both
Format
Style
Sheet
#name?
#name
Whatever is written in a formula will remain the same
####
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